Microsoft Office Tutorials and References
In Depth Information
4. Building on Step 3, for each field, determine and set its attributes, such as data type,
field size, and validation rules.
5. Create the database structure using Access. Use the database name ACE , and save
the database in the Level.02\Case5 folder provided with your Data Files. Create the
tables with their fields, following the naming standards used in this tutorial. Be sure
to set each field’s properties correctly, including the Caption property. Select a pri-
mary key for each table, use an input mask for one field, and then define the rela-
tionships between the tables.
6. For each table, create a form that you’ll use to view, add, edit, and delete records in
7. For tables with one-to-many relationships, create a form with a main form for the
primary table and a subform for the related table.
8. Design test data for each table in the database. Your tblCustomer table should con-
tain at least 15 records. Make sure your test data covers common situations. For
example, your test data should include at least two access plans with multiple cus-
tomers using the plans; at least two access plans with no customers using it; mul-
tiple cities, phone prefixes, and next billing dates; residential customers with no
company names; and commercial customers with company names and the first and
last names of the company’s contact. Use your first and last names for the first
record in the tblCustomer table.
9. Add the test data to your tables using the forms you created in Steps 6 and 7.
10. Open each table datasheet, and resize all datasheet columns to their best fit.
11. For the foreign key field in the tblCustomer table, change the field’s data type to
Lookup Wizard, including both the foreign key and its description as lookup
columns. If necessary, resize the lookup column in the table datasheet.
12. Create a query named qryCustomerNames that contains all the fields from the
tblCustomer table. Add a calculated field named CustomerName as the first column
that is either the company name or the concatenation of the last name, a comma, a
space, and the first name; set its Caption property to Customer Name . Sort in
ascending order by CustomerName.
13. Create one parameter query, one crosstab query, and one find unmatched query, and
save them using appropriate object names.
14. Designate the Level.02\Case5 folder as a trusted folder. ( Note: Check with your
instructor before adding a new trusted location.)
15. Close the ACE database without exiting Access, make a backup copy of the data-
base, open the ACE database, compact and repair the database, close the database,
and then exit Access.
| Internet Assignments
Use the Internet to
find and work with
data related to the
topics presented in
The purpose of the Internet Assignments is to challenge you to find information on the
Internet that you can use to work effectively with this software. The actual assignments
are updated and maintained on the Course Technology Web site. Log on to the Internet
and use your Web browser to go to the Student Online Companion for New Perspectives
Office 2007 at www.course.com/np/office2007 . Then navigate to the Internet
Assignments for this tutorial.