OPTION 1 Update Lab 6 (The easy option)
• Copy your lab 6 folder, rename it lab 7. Rename the database to yourname-lab7.accdb
 • Using your Lab 6 database, apply the following concepts
   • Add at least 5 additional records to each tables, must use the same exact name for both tables

   • When creating queries, remember to open your join query, change view to Design, add your criteria, Run !,
      then save as a new object with a meaningful name
   • Create and save at least ONE new query, demonstrating a logical operator
     ( less than, greater than, equal to) or use one calculation query (see selected help for Lab 7 below) or
   • Create and save at least ONE new query, demonstrating a parameter query ([ ] )
     • make sure each query is saved with a meaningful name (File Save As, save object as, and save the query)
     • Summarize the parts of the book we did not discuss in class.
     • Save the Word document in the lab 7 folder as yourname-lab7.docx

1. 1A include Good Database Design
2. 1A Change the structure of tables
3. 1B Template to complete a database
4. 1B Organize objects in Navigation Pane
5. 2A Sort Records
6. 2A Sort Query results
7. 2B Calculated fields
8. 2B Use wildcards
9. 2B Crosstab queries
   should be about 1 1/4 to 1 1/2 pages
   
   Selected Help for Lab 7
   Access Tips (based Access 2003, but still illustrative)

Complete only one of the two options... I strongly suggest Option #1:

OPTION 2 Use the book's databases (the harder, time consuming option for people who might actually like using databases)
Complete Activity A and B from the book for Microsoft Access

Unique identifier

a collection of tables

a way to output, or print

Input, or view and maintain data

Rows in a table

easily view the fields and data types

Question to process

data is presented in rows and columns