ACCESS 2013 LAB ONE – MODIFY A DATABASE

/in /by

In this lab, you will:

  • Add two fields to each of the two tables you created in Part One
  • Add two new tables to the database
  • Write a query extracting selected information from the database
  • Generate a report
  • Export a table to Excel for special processing.

A few comments:

  • Save your database and related tables frequently while working with this assignment. If you make a mistake, it is easier to go back to a database that has not been damaged.

Assignment: In this Part Two, you will add two more tables to the database created in Part One and establish relationships between the four tables, completing a query, report, and exporting the data to an Excel Workboo