Access Introduction
Aims:
Introduces the workings and concepts of relational databases in Microsoft 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:Training 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 |
|---|
| 16th - 17th May 2012 |
| 18th - 19th June 2012 |
| 16th - 17th July 2012 |
| 13th - 14th August 2012 |
| 12th - 13th September 2012 |
Course Outline:
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
