Microsoft Access

Requirements:

Familiar with Windows, no previous Access experience necessary.

Duration:

3 Half Day Sessions

Cost:

£240.00 plus VAT one-to-one with reductions for group
training.

Course Materials:

Handbooks provided for each trainee.

Further Training:

Follow on one-to-one sessions at £30.00 plus VAT per hour on an Address your Requirements basis.

Session 1

• Getting Started
• Database philosophy - fields, records, etc
• Getting around - relational database aspects, the Access window
  Managing files - new and existing databases
• Starting the Database
• Creating the first table
• Modifying the table design - updating and adding fields
• Creating a basic data entry form and first look at form design
• Adding Records
• Entering data and editing data - deleting, copying and moving
• Modifying the table layout - column widths, formatting, hiding columns, etc
• Establishing a Relationship
• Creating another table and establish a relationship between the two tables
• Creating a customised data entry form for the new table and entering more data
• Introduction to sub forms

Session 2

• Sorting, Finding and Filtering Records
• Sorting and finding data
• Using filters to find data
• Working with Queries
• Creating a query from a filter
• Creating new queries, setting criteria and creating calculated fields
• Developing the Database Further
• Deriving tables and forms from existing ones
• Creating the final table and data entry form, and relating all the tables
• Setting up further queries
• Producing a Printed Output
• Creating a basic report and printing the report

Session 3

• Database Outputs
• Creating customised forms - sub forms, calculations, etc
• Creating a customised report - with sub report and calculations
• Setting up mailing labels
• More advanced queries - parameter queries
• Printing Techniques
• Printing tables, queries, forms etc
• Automating the Database
• Using command buttons
• Opening forms with macros, responding to events and further macro techniques
• Other Database Facilities
• Locking records and fields
• Action queries
• Importing data and linking tables
• Splitting the database into front end and data tables