Microsoft Access for Business Professionals

Course Overview

Introduction to Access
What is a database?
Menus and toolbars
The Office Assistant and Help
The database window
Creating Tables and Adding Records
Creating a table using the Table Wizard
Datasheet View
Adding a record
Saving changes
Moving around the datasheet
Finding a record
Modifying and deleting records
Designing Table Structures
Creating tables
Switching between views
Saving tables
Field properties
Field size property
Format and Input mask properties
Caption property
Default value property
Required property
Allow zero length property
Indexed property
Working with Property
Sorting data
Filtering data
Using advanced filters
Forms
What is a form?
Using AutoForm to design forms
Using Wizard to design forms
Entering data using a form
Simple Select Queries
What is a query?
Creating a query
Modifying a query
Restricting records returned by a query
Simple calculated fields
Summary queries
Simple Reports
Reporting from Access
Printing from datasheet view
AutoReports
Designing a report using Report Wizards
Label reports
Modifying reports
Database Design
What is a relational database?
Primary and foreign keys
Relationships
Using field properties for protection
Required
Default value
Input mask
Validation rule and validation text
Lookups
Table Relationships
What is a relationship?
Relationship types
Creating and editing relationships
Using lookups for referential integrity
Multi-table datasheet view
Queries
Multi-table queries
Calculated fields
Adding a calculated field to a query
The Expression Builder
Calculating summary information
Crosstab queries
General query properties
Checking referential integrity
Forms
Form sections
Fom controls
Form control layout
Using form controls
Control properties
Control wizard
Multiple table forms
Reports
Using Report Wizards as the basis of reports
Report sections
Report controls
Report control layout
Using specific controls
Publishing datasheet views on the internet
Adding hyperlinks to datasheet views
Adding hyperlinks to HTML pages
Access Tools
Importing from other data sources
Importing data using Drag-and-Drop
Backing up and restoring a database
Compacting and repairing a database
Database Design
Theory of normal forms
De-normalisation
Naming conventions
Access Performance Issues
Indexes
Data validation
Table level validation
Relationships and referential integrity
Relationships
Field types
Referential integrity options
Join types
Using lookups for referential integrity
Multi-table datasheet view
Building and Modifying Forms
Using advanced form features
The form worksurface
Creating a calculated control
Adding a graphic to a form
Multi-table forms
Using the sub-form control
Switchboard forms
Access and The Internet
Using hyperlinks
Using hyperlinks in forms
Exporting datasheet views to HTML
Data Access pages
Advanced Queries
Filtering query results
Parameter queries
Creating summary queries
Formatting query output
Query join types
Self joins and aliases
Cross joins
Action Queries

What is an action query?
Planning an action query
Make table queries
Append queries
Delete queries
Update queries
Producing Reports

Applying sorting and grouping to reports
Performing calculations on reports
Adding a graphic to a report
Using the sub-report control
Modifying section properties
Using the Chart Wizard

If booking for more than one delegate, please contact us on 01189 778560 for discounted prices.