Workshop

The Workshop includes quiz questions that are designed to help you test your understanding of the material covered and activities to help put what you've learned to practice. You can find the answers to the questions in the section immediately following the quiz.

Quiz

1:

Name the two file formats that Access 2003 natively supports.

A1:

Access 2000 and Access 2002-2003.

2:

What is the industrywide accepted prefix for naming tables?

A2:

tbl.

3:

Name the three types of fields that support calculations.

A3:

Number, Currency, and Date.

4:

What two types of fields don't support sorting?

A4:

OLE Object and Hyperlink.

5:

How many parts make up a Hyperlink field?

A5:

Three: what the user sees, the URL or UNC, and a subaddress.

Activities

Build a table. Add to the table fields with various types. Give the table a primary key. Save and name the table.



    Part III: Creating Your Own Database and Objects
    Part V: Advanced Topics