Microsoft Office Tutorials and References
In Depth Information
In this tutorial, you learned the basic concepts associated with databases, including how
data is organized in a database and the functions of a relational database management
system. You also learned how the Database window is the main control center for your
work in Access, giving you options for viewing and manipulating all the objects in a data-
base—tables, queries, forms, reports, and so on. By opening and navigating a table
datasheet, you saw how the fields and records in a table are displayed and organized.
Using various wizards, you also learned how to create queries, forms, and reports quickly
in order to view and work with the data stored in a table in different ways. Finally, you
were introduced to some of the important tasks involved in managing a database, includ-
ing backing up, compacting, and converting a database.
current record symbol
record number box
Data File needed for the Review Assignments: Seasons.mdb
In the Review Assignments, you’ll work with the Seasons database, which is similar to
Elsa’s database that you worked with in the tutorial. Complete the following steps:
Take time to practice
the skills you learned in
the tutorial using the
same case scenario.
1. Open the Seasons database, which is located in the Brief\Review folder provided
with your Data Files.
2. Open the Employers table.
3. Use the appropriate navigation buttons to move to the last record in the table, and
then up three records from the last record. Write down the field values for all the
fields in this record.
4. Move back to the first record in the table, print the table datasheet, and then close
5. Use the Simple Query Wizard to create a query that includes the City, EmployerName,
ContactFirstName, ContactLastName, and Phone fields (in that order) from the
Employers table. Name the query EmployerPhoneList . Sort the query results in
ascending order by City. Print the query results, and then close and save the query.
6. Use the AutoForm: Columnar Wizard to create a form for the Employers table. Save
the form as EmployerInfo , and then close the form.
7. Use the AutoReport: Columnar Wizard to create a report based on the Employers table.
Print the first page of the report, and then close the report and save it as Employers .