14.21: Assignment- Create Queries for Access Database
In this assignment you’ll import and existing database of past orders from a bakery and use the skills you have learned in this module to create a query in the data table.
To complete this assignment, download the Excel file here . [1] Follow the directions, then submit your assignment. If you get stuck on a step, review this module and ask your classmates for help in the discussion forum.
- Open a new Access database and save the new Module 14 assignment file to the Rowan folder on your desktop as BA132_LastName_QueryDB.accdb, replacing “LastName” with your own last name. (Example: BA132_Hywater_Memo) It is a good idea to save your work periodically.
-
Import External Data:
With the Access new database open import the Excel data file into Access.
-
Import Wizard:
Set up the imported data into a new table, make sure the box with first row with column heading is checked and let Access add the primary key, and name the table.
-
Create a Query:
Use the Query Wizard and created a query that is a simple query and uses the ‘Product TableProduct Name’ and the ‘Quantity’ sections of the table.
-
Resize Columns of Query:
Resize the first column to be able to read the names of all the products.
- Query Design: Now create a second query, but this time from when you run the wizard button choose to ‘Modify the query design’.
-
Add New Criteria:
Now you wish just to see the number of orders that were chocolate chip cookies. Enter that in the criteria field.
-
Run Query:
Run the query, resize the first column and see how many orders there were for chocolate chip cookies.
-
Run Third Query:
Now, run another query but this time for “pecan” and when the results are displayed, add in an Autosum total at the bottom and see how many pecan orders have been placed. Save this query.
-
Rename Queries:
Rename the queries to match what is queried to better remember for what they are searching.
- Save: Save the file as an Access database and make sure all the queries have been saved as well.
- Submit the presentation file in your course online.
-
Data source: GCFLearnFree.org.
Access – Designing a Simple Query.
Database sample
↵
Contributors and Attributions
CC licensed content, Original
- Assignment: Create Queries for Access Database. Authored by : Sherri Pendleton. Provided by : Lumen Learning. License : CC BY: Attribution