Your first assignment for Microsoft Access comes from a different textbook. These four pages are attached here:


Here are the Access Projects that you are required to complete:

Whenever you print, include your name and the Project # (Project 1-1). Thanks!

Lesson 1: Access Basics
Project 1-1 - Do Not Print, Raise Hand
Project 1-2 - Print (add a record on the bottom, and put your name in it) - Make sure it fits to one page
Project 1-3 - Do Not Print, Raise Hand
Extra Credit: Activity 1-1 - Write response on loose leaf

Lesson 2: Creating a Database
Project 2-1 - Do Not Print, Raise Hand
Project 2-2 - Print - Make sure it fits to one page
Project 2-3 - Do Not Print, Raise Hand
Extra Credit: Activity 2-1 - Do Not Print, Raise Hand

Lesson 3: Creating Queries
Project 3-C - Create a Query that has a calculation. Either use the NBA Salaries or the Rap Artists databases (found in the Access - student files folder that you already copied into your H:Drive)
Project 3-1 - Print before step 7! - Make sure it fits to one page
Project 3-2 - Do Not Print, Raise Hand
Project 3-3 - Save in the Y-Drive, in the Project 3-3 folder (You have to save the Database there, not just the object)
Project 3-4 - Do Not Print, Raise Hand
Extra Credit: Activity 3-1 - Write client's requirements on loose leaf, Raise Hand when all Queries are ready
Extra Credit: Activity 3-2 - Write a brief essay on loose leaf

Lesson 4: Creating and Modifying Forms
(No projects are due)
Extra Credit: Project 4-1 - Do Not Print, Raise Hand - Have record 8 on your screen
Extra Credit: Project 4-2 - Do Not Print, Raise Hand

Lesson 5: Creating and Modifying Reports
Project 5-1, Step 6 - Do Not Print, Raise Hand
Project 5-1, Step 12 - Print - Make sure it fits to one page
Project 5-2 - Do Not Print, Raise Hand *Have it ready in Print Preview
**Office.gif can be found in your lesson 5 folder!
Project 5-3 - Save in the Y-Drive, in the Project 5-3 folder
Extra Credit: Activity 5-1 - Write the correct answer on a sheet of looseleaf
Extra Credit: Activity 5-2 - Write the correct answer on a sheet of looseleaf

Lesson 6: Integrating Access
Project 6-1 - Do Not Print, Raise Hand - Show me your Products Table, starting with Product ID 6001
Do Not Complete Project 6-2
Project 6-3 - Do Not Print, Raise Hand - Show me Record #10 - Hillary Davis
Project 6-4 - Print Record #2
Extra Credit: Activity 6-1 - Write on a separate sheet of paper to turn in.
Extra Credit: Activity 6-2 - (worth up to 5 points) - Complete!

Access Unit Review Answer Key: