|
MICROSOFT ACCESS XP – Essentials
Course Aims:
Participants will learn the basic skills necessary to begin using Access XP. After completion of this course, the participant will understand how to create a database and its tables, view and edit data in tables and forms, perform queries to extract data, create reports to present data clearly and design forms to simplify data entry.
Contents:
Systems Design
What is a Database
Analysis and Investigation
Design and Considerations
Implementation & Maintenance
Understanding Access Objects
Opening a Database
Viewing Database Objects
Tables
Reports
Forms
Queries
Macros
Modules
Creating a Database
Access Menus & Toolbars
Creating a Table from Scratch
Classifying Data Types
Setting simple Field Properties
Setting the Primary Key
Datasheet and Design View
Entering & Replacing Data
Saving the Table
Working with Tables
Find and Sort Data
Filter by Selection, Filter by Form
Show Related Tables
Creating Forms
Auto Forms
Forms Wizard
Editing Forms in Design View
Creating Reports
Reports Wizard
Single Column and Tabular Reports
Editing the Report
Creating Mailing Letters and Labels
Creating Queries
Query Concepts
Creating a New Query
Specifying Criteria in a Query
Parameter Queries
Pattern Matching
Calculated Fields
Defining Relationships
Relational vs. Flat File Database
Identifying Primary Keys
Creating Relationships
Target Audience:
Individuals who have a need to store and retrieve information using automated procedures.
Assumed Knowledge:
Windows fundamentals or equivalent experience is required. No prior knowledge of databases or Access is assumed.
Duration: 1 Day
Suggested Follow Up:
Access XP Specifics
printer friendly version
|
