Microsoft Office Tutorials and References
In Depth Information
Session 1.2
Tutorial Summary
Review
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.
Key Terms
Access
Access window
AutoForm Wizard
AutoReport Wizard
backing up
column selector
common field
compacting
converting
current record symbol
database
database management
system (DBMS)
Database window
datasheet
Datasheet view
field
field selector
field value
foreign key
form
Form Wizard
Groups bar
navigation buttons
Objects bar
primary key
query
Query Wizard
record
record number box
record selector
relational database
relational database
management system
(RDBMS)
report
Report Wizard
row selector
table
Review Assignments
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:
Practice
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
the table.
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 .
Search JabSto ::




Custom Search