|
SYNOPSIS:
This course introduces the skills necessary for setting up and using database
tables in Access. It includes tasks to get started; create, edit, and
work with tables; and set field properties. Students will also learn how
to find, filter, and print data and use the Office Assistant.
PREREQUISITES:
Users who want to learn the basics of using database tables.
OBJECTIVES:
l Getting
Started
l Using the Office Assistant
l Creating Tables
l Working with Tables
l Setting Field Properties
l Editing Tables
l Finding & Filtering Data
l Printing Data
DURATION:
Day One of Two
|
THIS MODULE INCLUDES:
Getting Started
Starting and exiting Access; opening and closing databases; using, opening,
and closing database objects; navigating pages.
Using the Office Assistant
Using and hiding the Assistant, finding an answer, selecting an Assistant,
changing Assistant options.
Creating Tables
Creating a blank database, designing and saving tables, creating tables
in Design view, using the Table Design window and the Table Wizard, adding
field names and descriptions, assigning data types, setting a primary
key.
Working with Tables
Using Datasheet view; navigating fields in tables; adding, selecting,
editing, saving, deleting, and moving through records.
Setting Field Properties
Using field properties; limiting field size; setting number, date/time,
and yes/no formats; setting default values and validation rules and text.
Editing Tables
Changing row height, column width, font attributes, and cell effects;
selecting, moving, hiding, unhiding, and freezing columns.
Finding and Filtering Data
Sorting records; finding specific records and using wildcards; using
Replace, Filter By Selection, Filter Excluding Selection, Filter For,
and Filter By Form; applying and removing a filter.
Printing Data
Printing table data
and selected records, changing page setup.
|
