Access Introduction Aims:Introduces
the workings and concepts of relational databases in Access, including
select queries, forms and reports
Prerequisites:Attendance
of a Windows Introduction or a good understanding of the Windows
environment.
Duration:Two Days
Course Content
An Introduction to Access The Access screen Using the keyboard and
mouse Using the toolbars Working with menus Help and the Office Assistant
Access Basics Database concepts and terminology Creating, opening and
closing databases Understanding the Database Window Access database
objects
Tables Designing Tables Creating Fields Specifying Data Types
Understanding Field Properties Using Primary Keys Data Entry in Tables
Relationships Designing Relationships Relationship types Creating
Relationships between Tables
Forms Creating an AutoForm Using the Form Wizard Modifying Forms
Designing basic Forms Basic design tools Data Entry in Forms
Queries What is a Query? Designing a Query Specifying query criteria
Sorting the results of a Query Query tricks Creating calculated fields
Querying multiple tables
Reports Creating an AutoReport Using the Report Wizard Modifying a Report
Grouping and Summaries Creating Mailing Labels
Course Dates
|
17th - 18th November 2008
|
|
11th - 12th December 2008
|
|
19th - 20th January 2009
|
|
18th - 19th February 2009
|