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 778562 for discounted prices.