|
MICROSOFT ACCESS XP – Specifics
Course Aims:
Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports.
Contents:
Defining Relationships
Design considerations
Relational vs. Flat File Database
Creating Relationships
Enforced Referential Integrity
Join Properties
Select Queries
When to use a Select Query
Creating a Select Query
Entering Search Criteria
Query Expressions
Sort Order
Hiding a column
Calculated Fields
Parameter Queries
Creating
Pattern Matching in a Parameter Query
Action Queries
Make Table Queries
Delete Queries
Append Queries
Update Queries
Action Query Problems
Enhanced Table Designs
Setting Field Properties
Formatting Data
Default value Properties
Validation rule Operators
Rules and Limitations
Enhance Form and Report Design
Bands
Controls
Adding Titles, Labels and Fields
Calculated Fields in Forms
Sorting and Grouping
Inserting Objects and Page Breaks
Forms and Sub Forms
Macros
Creating a Macro
The Macro Window
Saving the Macro
Attaching to Command Buttons.
Graphs
Selecting the Graph Data
Free-Standing and Embedded Graphs
Changing a Graphs Properties
Target Audience:
Individuals wishing to design relational databases and build more complex database objects, including tables, queries, forms, reports and macros.
Assumed Knowledge:
Access XP Essentials or equivalent experience is required.
Duration: 1 Day
Suggested Follow Up:
Access XP Specialists
printer friendly version
|
