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
Fees:Course fees for this particular course will depend on your chosen Training solution. Please click on the links below for corresponding course fees:
PDF Course Download
You can download a PDF version of the course.
Download Access Introduction course outline.
If you don't have Adobe Acrobat Reader, this can be downloaded from the www.adobe.com web site.
If you are interested in our Access Introduction course call us on
0113 243 2226
Enquire about
this course Now
Course Dates
| Available dates |
|---|
| 15th - 16th October 2008 |
| 17th - 18th November 2008 |
| 11th - 12th December 2008 |
| 19th - 20th January 2009 |
| 18th - 19th February 2009 |
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
