Introduction to Access (Databases)

HIT1401 Intro to Information Systems

Part 2 – Relationship Diagram:

Part 3 - First Order Details

Part 3 – Category 4 Details

Part 4

Orders by Females

Health Snack Orders

Products by Margin

Customer Deliveries

Orders by Customer

Part 5

Report Orders by Customer

Part 6

Report Orders by Customer

Part 7

Question A – Total Number of Orders

Question B – Total Number of Orders by Gender

Question C – Lowest Orders by Month

Question D – Highest Quantity Sold

Question E – Highest Income Generated

Question F – Highest Profit Generated

Question G – Highest Customer Sales

Part 8

Spreadsheets vs. Databases

List 1: Top 6 Indicators to use a Spreadsheet

1. Storing large amounts of data. Microsoft Excel 2007 can store well over 1,000,000 rows and 16,000 columns of data, ready for manipulation and analysis.

2. Creating formulas to perform complex calculations. Microsoft Excel comes with many simple, built-in formulas a business can select for the ‘Formulas’ ribbon, or a user can have a go at creating their own formula by typing directly into the cell they want to display the answer.

3. Sort or filter data in a flash. Spreadsheet applications allow you to sort data (whether it be alphabetically or in numerical order), or filter data so only data meeting set conditions is displayed.

4. Creating Pivot tables allows a business to quickly ‘Slice and Dice’ data for analysing.

5. Creating graphs and charts using ChartWizard. Displays data graphically in a few easy steps. Easy customization of layouts to meet any businesses needs.

6. Discovering patterns with conditional formatting. Applying conditional formatting to data will help to uncover any patterns or trends within the dataset.

List 2: Top 6 Indicators that you should use a Database Application

1. Multiple users can access and edit the database simultaneously. Microsoft Access only locks...