Microsoft+Access

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 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
 * Office.gif can be found in your lesson 5 folder!

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: