A 1 day Introduction Course, aimed at the new user, this course aims to give users the confidence and knowledge to create and use Access databases. By the end of the course, users will be able to create and amend database structures, manipulate data and produce forms and reports.

Flat and Relational Databases

Gain an understanding of the differences between the two different types of database structures.

Getting started with Access Databases

Introduces you to the key features of Access before creating an amending your own databases.

• Understanding Database terminology
• The specification
• The Access screen tour
• The Access objects
• Creating a database
• Amending an existing database

Tables

Shows you how to add/edit the Tables that are used to hold all the data used within the database.

• Field properties
• Data entry
• Design mode and working mode
• Primary and foreign keys
• Naming conventions
• Modifying an Access table
• Saving a table
• Filtering information
• Sorting information

Queries

Manipulate the data and find specific records.

• Running queries
• Creating queries
• Amending existing queries
• Working with different views
• Finding information

Forms

Create and edit user friendly forms for you users to complete.

• Creating forms using Wizards
• Creating forms using Design View
• Edit existing form properties

Reports

Presentable ways of printing your data.

• Reporting wizards
• Printing Report Labels
• Creating custom reports

Problem solving

Throughout the two days you will be shown a variety of common errors and solutions to these problems.

A 2 Day Intermediate Course, aimed at users that have been on the previous stages or an experienced user. This course aims to give users further knowledge and tools to create Access databases. By the end of the 2 days, users will be able use the Access Action queries, produce enhanced forms and reports and create relationships.

Refresh on Previous Stages

Quick refresh over key features of Access.

• Flat File Databases
• Database specifications

Designing Tables

Creating and modifying the Tables with more advanced properties.

• Naming Conventions
• Data Types
• Data Validation
• Combo Boxes
• Linking Tables
• Primary and Foreign Keys

Creating and Modifying Forms

Create/ Edit User friendly input forms.

• Modifying Form Properties
• Sub Forms
• Tab Controllers
• Search Forms
• Relational Forms
• Welcome Forms
• Query Based Forms

Queries

Manipulate the data and find specific records.

• Select Queries
• Parameter Queries

Quick refresh over key features of Access.

• Flat File Databases
• Database specifications
• Temporary Fields
• Cross Tab Quires
• Update Queries
• Delete Queries

Reports

Presentable way of printing your data.

• Printing Custom Reports
• Creating Query Based Reports
• Custom Report Creators
• Sub Reports

Macros

A brief introduction to macros.

A 2 Day Database Programming Course, aimed at users that have been on the previous stages; this course aims to give users further knowledge and tools to create and manipulate Access databases. By the end of the two days, users will be able to create user-friendly forms using macros and code. The databases created, will be easy enough for someone to use with no Access experience, however, the developer will have a difficult task creating these user-friendly databases.

Quick Refresh on previous stages

Macros:

• Refresh
• Requery
• Max
• Min
• Setvalue
• Open
• Runcommand

Macro names

Macro group files

SQL Programming

Referring to a macro in a group file

Conditional macros – If Statements

Event Driven Programming – making forms come to life

Understanding common control events and triggers

Understanding form events

Creating common form events

A workshop – problem solving

Differences between a macro and Visual Basic code ( VBA )

Advanced queries and reports

Saving MDE format

Search forms

Security

AJ Training Access Developers advanced tips and tricks

A 2 day VBA Programming Course aimed at advanced Access Users. This course aims to give users an introduction to Visual Basic Programming within the Access Application and the Microsoft Office Suite. Also the Users will have a greater understanding to Visual Basic, unlocking the door to the most popular used programming language in the world.

Visual Basic environment introduction

Visual Basic controls – events, properties, text, methods, forms, focus

Visual Basic definitions – general, event, function, sub procedures and modules

The Basic language – syntax, instructions, conditions and loops

Using variables

Text handling – property, functions, strings and variants

Choices – option buttons, scroll bars, check boxes, list boxes, combo boxes

Displaying and printing - message boxes

Dialog boxes – creating a dialog box, using a dialog box and dialog control

Differences with macros and VB

Update and edit records by using VB code

Word Links

• Automatically linking data to Word
• Controlling Word through Access
• Generate Word documents automatically through Access

Excel Links

• Automatically linking data to Excel
• Update spreadsheets through Access
• Generate Excel documents automatically through Access

Outlook Links

• Automatically linking data to Outlook
• Emails automatically from Access

Error handling

Debugging