Microsoft Access Level One Outline
Aims of the Two-Day Course
This course combines our Introductory and Intermediate outlines and
has been designed to give first time users in-depth training in the skills
they need to use Microsoft Access to design and create a relational database.
The course is 100% hands on, with exercises to practice the skills as
you learn them.
Course Content
- What is a Database?
- Uses for a Database
- Database Object Types
- Steps to Creating a Database
- Designing and Creating a Database
- Field Properties & Formats
- Design View and Design Properties
- Data Manipulation
- Entering; editing; deleting data
- Finding and Replacing specific entries
- Validating Data Entry
- Building Forms
- Creating controls
- Text boxes; list boxes; combo boxes
- Option buttons; check boxes; toggles
- Forms and sub forms
- Filtering and Sorting
|
- Building a Query
- Analysing and summarising data
- Using the query wizard
- Calculated fields
- Expressions
- Action queries
- Designing and Printing Reports
- Report wizard
- Grouping & totalling; summary reports; mailing labels
- Adding & adjusting controls
- Sorting & grouping
- Page breaks
- Totals and sub totals
- Relational Databases
- Linking tables in queries and forms
- Referential integrity
- Cascading updates and deletes
- Connectivity
- Importing and exporting tables
- Introduction to Macros
|
Prerequisites
No previous experience of using Access is necessary, although keyboard
and mouse experience is assumed. Familiarity with the use of Windows software
is essential.
Course Duration
Twelve hours (9.30am to 12.30pm and 1.30pm to 4.30pm on both days).
Next Course
Microsoft Access Advanced
Prices
|
