Access 2016 Details

Assignment focuses on setting up a Basic MS Access 2016 Database. In this set up you will implement the skills covered through Modules 1 & 2.

In order to create and use the Sample Database Students will complete the following by using the Instructions provided in the attached PDF Document:

1. CREATE the FIRST TABLE, Account Manager, using Datasheet view
2. ADD RECORDS to the Account Manager Table
3. PRINT the CONTENTS of the Account Manager Table
4. IMPORT RECORDS into the second table, Account
5. MODIFY the SECOND TABLE using Design view
6. CREATE a QUERY for the Account Table
7. CREATE a FORM for the Account Table
8. CREATE and PRINT a REPORT for the Account Table

Assignment Submission Details:

• Save Access Database as PrattLastYourName
• Complete all Steps in the Access 2016 Document to Page 50 (including Page 50) – (40 Marks)
• Print Account Manager and Account Tables as PDF and Submit (10 Marks)
• Print Page 38 Print Results of your query as PDF and Submit (10 Marks)
• PDF Report Page 41 – Creating and Printing Report – Create Final Report as PDF and Submit (20 Marks)
• Backup your Database – Page 49 – Submit via BB with Reports (10 Marks)