dmw | consultancy
tel 01732 833085
tonbridge · kent · UK

Basic Access 2010, 2013 and 2016 Training Courses

DMW’s Basic Introductory Microsoft Access course is for anyone who is new to database creation or who is self-taught and wants to fill in gaps in their basic skills.

The success of your database depends on careful planning of its structure before you hit the keyboard and on understanding how to create this structure in Microsoft Access 2010, 2013 or 2016.

Taking some training before you start is a wise move if you are to avoid getting off on the wrong foot. Nothing worse for a database developer than, after a couple of months of your users inputting records, to come to realise you’ve messed up on the tables!

Course Content

Course content is adjusted to suit the sorts of databases you intend to create. These are topicss that are core to most courses:

Why use a database Why a database and not some other program, like a spreadsheet.

Terminology Understand database terminology—Access uses the vocabulary of the database developer and therefore you need a grasp of the jargon.

Planning How to plan for a successful database—there are rules for storing data in a database that need to be followed.

Database objects Components of a relational database: the engine room that manages the data; the user interface that hides the technicalities from the user; the reporting function for outputting information.

Access database Examining how Access works as a RDBMS (relational database management system).

New database How to start a new database in Access.

Tables Understanding tables, fields and record.

Tables Working with more than one table.

Table creation How to create an Access data table.

Fields Data types; properties; primary keys; indexing; validation.

Relationships Types of relational links between tables; how to create links.

Queries Their importance in a database and where and when to use them.

Query design Creating single- and multi-table queries.

Sorting Using queries to sort data.

Filtering by query Using queries to list records that match your criteria; use of wildcards in criteria.

Calculations Using queries to perform calculations on your data.

Forms Their role in a database. When to use them.

Form design Creating a form using a Wizard; modifying the appearance and behaviour of a form.

Reports Their part in a database.

Report design Creating a report using a Wizard; modifying the appearance of a report.

Conclusion Reflection on what you have learnt and how you might apply Access to your database.

Course Duration

Two days on-site, normally between 9:30am and 4:30pm on each day.

The usual pattern is database design and table creation on the first morning with queries in the afternoon; forms and reports on the second day.

Some clients like a gap between the two days so that they can reflect on what they learn about setting up their database before moving on to find out about designing user interface screens and reports for printing.

Course Prerequisites

Competence in the use of the mouse, keyboard and windows, and ribbons. Awareness of basic computer principles like files, folders and filing.

Some thought given to why you might want to use a database in the first place.

“No matter how good you get you can always get better, and that’s the exciting part.”

Tiger Woods