Microsoft Office Access

For a scalable relational database solution suitable for SME use, Microsoft Office Access takes some beating. Few people harness the real power of Access, which lies in the relationships it is possible to create between entities and the graphical nature of the software that allows the construction of complex joins without any knowledge of SQL.

Access can be found in use in a wide cross-section of businesses, and in web applications using Windows servers. Our courses are tailored to the levels our clients demand. Introduction covers the concepts in database creation, including the terminology so many people find difficult to fathom. Out Intermediate course builds on this foundation, while the Advanced offers Form creation, Internet integration and a look at SQL statements to create more sophisticated queries.

Access 2000 (XP and 2003 use the 2000 engine) and 2007 versions are offered.

Introduction - Course content

Database Concepts	Working with Fields and Records
Database concepts and terminology	Changing the design of a table
Exploring the Access environment	Adding and deleting records
Planning and designing databases	Finding and editing records
Getting help	Sorting and filtering records
Closing a database and Access
Access Basics	Creating Databases
Exploring tables	Creating a database
Examining queries	Using the table wizard
Exploring reports	Working in design view
Querying Tables	Creating and Using Forms
Creating and using queries	Creating forms by using AutoForm
Modifying query results and queries	Using the form wizard
Using calculations in queries	Using design view
Importing, Exporting and Linking	Creating and Using Reports
Importing Access objects	Using the report wizard and queries
Exporting Access objects	Creating, modifying and printing reports
Linking Access objects

 

Intermediate - Course content

Creating relational databases	Working with related tables
Database normalising	The lookup wizard
Introducing relating tables	Changing lookup fields
Adding referential integrity	Inputting data to related tables
Defining data entry rules	Using advanced query features
Using input masks	How to join a table in queries
Setting a property	Creating a calculated field
Setting a validation rule	Using an action query
Creating advanced queries	Creating advanced form design
Summarise and group values	Working with graphics
Create a cross tab query	Working with calculations
Using a parameter query	Working with combo boxes
Using an index	Working with unbound controls
Using advanced report features
Create customized headers and footers
Add a calculated value
Work with sub-reports

 

Advanced - Course content

 

Creating Advanced Forms	Macros
Designing a form based on joined tables	Create and run macros
Automating data entry	Attach macros to events of database objects
Grouped control
How to improve the user interface
Designing sub forms
Creating Advanced Macros	Exploring Access SQL
Create macros to provide user interaction	Identify different clauses in an SQL statement
Create macros requiring user decision	Writing SQL statements
Use Auto Keys and AutoExec macros	Attach an SQL statement to database objects
Integrating the Internet	Managing Databases
Work with hyperlink fields	Work with database utilities to optimise resources
Work with data access pages	Secure data by database replication
Security Fundamentals
Protect databases