1 | P a g e
CHAPTER 10
ACCESS TABLES
CHAPTER 10 QUESTIONS
1. To delete a record from a table, open the table, and then click on the far left side of record (row) you
want to delete. (This selects the record.) Right click in that record, and then click Delete Record from
the short-cut menu which appears.
2. OLE is Object Linking/Embedding: the integration of objects from other applications.
3. There are several things you can do to change the structure of a database. You can change a field’s
information is entered.
8. Input masks are tools in Access that are used to control how data is entered into a database. An input
mask ensures that the data entered will fit the format you design and fit the kind of data you want
entered.
9. Referential integrity is a system of rules to ensure that relationships between records in related
2 | P a g e
CHAPTER 10 ASSIGNMENTS
1. Add, change, and delete records
Product table:
Buyers table:
Category table:
2. Add pictures with an OLE field to database
3. Change the structure of database
Product table (Note: students may have used different captions for column titles. The point is
just to have the table fit on one page with all data showing.)
4 | P a g e
Relationships report:
Documentation from the Product table:
5 | P a g e
Documentation from the Buyer table:
6 | P a g e
CHAPTER 10 CASES
1. Kelly’s Boutique
Book Table:
Department Table:
Publisher Table:
7 | P a g e
Relationships:
Note that the documentation reports below may be different (decimal places and column width) than
your reports.
Documentation of List Price field of Book Table:
Documentation of Phone field of the Publisher Table:
2. Wine Depot
Relationship Report
Buyer Table:
Wine Products Table:
10 | P a g e
Winery Table:
Note that the documentation reports below may be different (decimal places and column width) than
your reports.
11 | P a g e
Documentation of the Phone field in the Buyer Table
Documentation of the Price field in the Wine Products Table:
13 | P a g e
3. Snick’s Board Shop
14 | P a g e
Note that the documentation reports below may be different (decimal places and column width) than
your reports.
15 | P a g e
4. Rosey’s Roses
16 | P a g e
Note that the documentation reports below may be different (decimal places and column width) than
your reports.
