| |
 Microsoft Access Database Development Training
- Intermediate
Class Length 1 Day
Prerequisites Access 2003 Introduction, Windows XP:
Introduction or equivalent knowledge
Maximum Class Size: 10
Course Objectives
- Follow the steps required to properly design a simple database
- Create a new database with related tables
- Control data entry by modifying the design of a table to
streamline data entry and maintain data
integrity
- Find and retrieve desired data by using filters and joins
between tables and within a single table.
- Create flexible queries to display specified records; allow
for user-determined query criteria; and add, update, and delete
data with queries. enhance the appearance, data entry, and data
access capabilities of your forms
- Customize reports to better organize the displayed information
and produce specific print layouts such as mailing labels
- Use Access data in other applications, including Microsoft
Word and Excel
Course Outline
- Planning A Database: design a relational database, identify
database purpose, review existing data, determine fields, group
fields into tables, normalize the data, designate primary and
foreign keys
- Building The Structure Of A Database: create a new database,
create a table using a wizard, create tables in design view,
create relationships between tables
- Controlling Data Entry: restrict data entry with field properties,
create an input mask, create a lookup field
- Finding And Joining Data: find data with filters, create
query joins, join unrelated tables, relate data within a table
- Creating Flexible Queries: set select query properties, create
parameter queries, create action queries
- Improving Your Forms: enhance the appearance of a form, restricted
data entry in forms, add command buttons, create a subform
- Customizing Your Reports: organize report information, set
report control properties, summarize information, add a subreport
to an existing report, create mailing labels
- Expanding The Reach Of Your Data: publish Access data as
a Word document, analyze Access data in Excel, export data to a text file, merge Access data
with a Word document
|
|
