Home •  Training  •  Databases  •  Contact Us  •  Site map

 

Onsite Microsoft Access Training - Basic

Microsoft Access is used by small businesses and within departments of large organisations to create customized systems for storing, processing and reporting information. Microsoft Access enables a relatively quick development because all tables, queries, forms, and reports are stored in the one database.  From Novice to expert, Microsoft Access allows system development to be within the reach of the user.

Our training Allows you to capitalise on this extremely useful and mostly under utilized resource.  Our standard Basic course is outlined below but we can discuss bespoke courses and also collaborative development of any database you wish to create.

Microsoft Access Basic Training Course

Getting started with MS Access
Database concepts
Exploring the Microsoft Access environment
Getting help
Closing a database and Access

Databases and tables
Planning and designing an Access databases
Exploring Database tables
Creating Database tables

Fields and records
Changing the design of a database table
Finding and editing Database records
Organizing Database records

Data entry rules
Setting database field properties
Working with input masks
Setting validation rules
Using indexes

Simple database queries
Creating and using queries
Modifying query results and queries
Performing operations in queries

Using MS Access forms
Creating forms
Using the Form Wizard
Using Design view
Finding, sorting, and filtering records

Working with MS Access reports
Creating reports
Modifying and printing reports