Jan's Working with Databases

Exercise Access 2-4: On Your Own

---

What you will do:

Create a database of your own

---

You will create a database for a collection. You may use one of your own collections or you may invent a fictional one. Consider collections like antiques, books, records, CDs, computer programs, coins, stamps, action figures, dolls...

Think before your start! Consider:

• Number of tables that you will need
• How the tables will be related.
• Fields that you will need
• What data types the fields should have.
  • Are there fields that you would like to be Lookup fields?
  • Where will the values for the Lookup lists should come from? A list in the table design or from another table?

For example, you might have one table for information about the items in the collection and another that lists the categories or suppliers or types, to be used as the source for a Lookup field.

1. Create a new, blank database. Save it with the name ex2-4-Lastname-Firstname.accdb to your Class disk in the folder databases project2. (Use your own last name and first name, of course!)
2. Create at least 2 tables, using the method of your choice. One table must serve as the source for a Lookup field in the other table. That means they must share a field.
3. Create at least 1 query that sorts or filters one of your tables.
4. Create at least 1 form to enter data into one of your tables.
5. Add at least 4 records to your tables.
6. Print a datasheet for a table.
7. Print at least one record from the form. Make sure that your form fits inside the width of the paper.
8. Create a report based on a table or on your query.
9. Print the report.
10. Print the Relationships Report.