Microsoft Office Tutorials and References
In Depth Information
You interact with databases whenever you place an order on the Internet, check out at a
retail store or restaurant, verify your bank account balance, or register for classes. Most
businesses use databases, and you can also use databases to track data in your personal
life. Examples of personal database use include tracking personal collections, such as
DVDs or books; hobby data, such as family histories or antiques; or items related to
sports teams, theater clubs, or other organizations to which you might belong. In this
exercise, you’ll use Access to create a database that will contain information of your
choice, using the Access skills and features you’ve learned in these tutorials.
Note: Please be sure not to include any personal information of a sensitive nature in the
database you create to be submitted to your instructor for this exercise. Later on, you can
update the data in your database with such information for your own personal use.
1. Create a new Access database to contain personal data you want to track. (If you
completed Tutorials 1-4 of this topic and the Reality Check at the end of Tutorial 4,
you can use and enhance the database you’ve already created, and you can skip this
step.) The database must include two or more tables that you can join through one-
to-many relationships. Define the properties for each field in each table. Make sure
you include a mix of data types for the fields (for example, do not include only Text
fields in each table). Specify a primary key for each table, define the table relation-
ships and enforce referential integrity, and enter records in each table.
2. Create queries that include at least the following: pattern query match, list-of-values
match, parameter, crosstab, find duplicates, find unmatched, and the use of a condi-
tional value in a calculated field.
3. For one or more fields, apply an input mask and specify field validation rules.
4. Create a split form and modify the form.
5. Create a custom form that uses at least the following: combo box for a lookup,
combo box to find records, subform, lines and rectangles, and a tab control. Add
one or more calculated controls to the main form based on the subform’s calculated
control(s), and add a chart, if appropriate. Check the main form’s tab order, and
improve the form’s appearance.
6. Create a custom report that uses at least the following: grouping field, sort field(s),
lines, and rectangles. Hide duplicates, and add the date, page numbers, and a
7. Export two or more objects in different formats, and save the step specifications.
8. Create a PivotTable and PivotChart for one of the tables or queries.
9. Designate a trusted folder, backup the database, and compact and repair it.
10. Submit your completed database to your instructor as requested. Include printouts of
any database objects, if required.