1 / 8

Query Creation for Computer Company Expenses

Learn how to calculate total and average salesman expenses by department using Microsoft Access. Step-by-step guide with screenshots included.

moorelawrence
Download Presentation

Query Creation for Computer Company Expenses

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Activity 4 Creating a query for a computer company In this activity, we are going to create a query for a computer company. The query will calculate the total and average expenses of the salesmen for each department. • Start Microsoft Access and open the database file ch11_01.mdb in the hard disk. • Click ‘Queries’ in the ‘Objects’ column and then click . • Double-click ‘Simple Query Wizard’ in the ‘New Query’ dialogue box. New

  2. In the Simple Query Wizard window, select the table ‘Salesmen Expenses’ from the ‘Tables/Queries’ pull down menu. Activity 4 Creating a query for a computer company

  3. Click to move all the fields except ‘Salesman’ from the list box ‘Available Fields’ to that of ‘Selected Fields’. Click when ready. Activity 4 Creating a query for a computer company Next

  4. Select the ‘Summary’ option to create a summary query that shows the total and average expenses. Then, click . Activity 4 Creating a query for a computer company Summary Options

  5. In the ‘Summary Options’ window, click the check boxes to include the total (Sum) and average (Avg) expenses as shown below. Click to return to the previous screen in Step 6. Activity 4 Creating a query for a computer company OK Only numeric fields can be chosen for calculations.

  6. Click . Enter ‘Statistics Query’ as the query titleand then click . Activity 4 Creating a query for a computer company Next Finish

  7. (a) Which department has the highest total expense on transportation? ____________________________________ (b) Create a new query with the Simple Query Wizard to calculate the total expense on meal. Total expense on meal is $________. Close the query and database file. Then, exit Microsoft Access. Activity 4 Creating a query for a computer company CPU 5513

  8. (a) Which department has the highest total expense on transportation? ____________________________________ (b) Create a new query with the Simple Query Wizard to calculate the total expense on meal. Total expense on meal is $________. Close the query and database file. Then, exit Microsoft Access. Activity 4 Creating a query for a computer company CPU 5513

More Related