MS Access Project 2: Querying a Database
Completion requirements
Course Learning Outcomes:
Grade Contribution: This project will contribute 30% of your grade for the Database Portion of the class.
Instructions
This assignment addresses:
Module Objectives:- Create Databases
- Create Tables in Datasheet View
- Enter Data into Datasheets
- Import Data into Tables
- Filter and Sort Datasheets
- Preview and Print Datasheets
- Create Queries with the Simple Query Wizard
- Create Queries in Design View
- Create, design, and modify databases, tables, and records
- Apply database and table knowledge to create/modify database records.
- Apply database and table knowledge in order to query a database and create information
Steps for completing the Assignment:
- Note: Make sure your copy of Lastname_Firstname_Access_Practice2.mdb from the module practice activities is completed before completing this assignment.
- Ask your instructor in advance if you have issues completing this.
- Download the attached 'Module Access 2 Assignment.pdf' file and go over the instructions included
- Name your database: Lastname_Firstname_Access_Practice3 <- use your last and first name.
- Complete the assignment using the MS Access software.
- Create a zip file of the MS Access database submit to your instructor via email. The zip file should be named Lastname_Firstname_Access_Practice3.zip <- use your last and first name.
- Note that if the file is too large, email a OneDrive link to the zip file to your instructor.
- EMAIL YOUR INSTRUCTOR ASAP IF YOU RUN INTO ANY ISSUES. DO NOT WAIT TILL THE LAST MINUTE!
- May 26 2022, 11:40 AM