Microsoft Office Tutorials and References
In Depth Information
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.
2. Create two or three tables in the database that can be joined through one-to-many
3. 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).
4. Specify a primary key for each table.
5. Define the necessary one-to-many relationships between the tables in the database
with referential integrity enforced.
6. Enter 20 to 30 records in each table. If appropriate, you can import the data for a
table from another source, such as an Excel spreadsheet or a text file.
7. Create 5 to 10 queries based on single tables and multiple tables. Be sure that some
of the queries you create include some or all of the following: exact match condi-
tions, comparison operators, and logical operators.
8. For some of the queries, use various sorting and filtering techniques to display the
query results in various ways. Save these queries with the sort and/or filter applied.
9. If possible, and depending on the data you are tracking, create at least one calcu-
lated field in one of the queries.
10. If possible, and depending on the data you are tracking, use aggregate functions to
produce summary statistics based on the data in at least one of your tables.
11. Create at least one form for each table in your database. Enhance each form’s
appearance with pictures, AutoFormats, line colors, and so on.
12. Create at least one form with a main form and subform based on related tables in
your database. Enhance the form’s appearance as appropriate.
13. Create at least one report based on each table in your database. Enhance each
report’s appearance with pictures, AutoFormats, color, and so on.
14. Apply conditional formatting to the values in at least one of your reports.
15. Submit your completed database to your instructor as requested. Include printouts of
any database objects, such as reports, if required.