Microsoft Access

Microsoft Access Training

At a basic level, you can use Access to develop simple, personal database-management systems. Some people accululate everything from their wine collections to their home finances.

Companies use Access to develop Customer Databases, Asset Databases and many more. Access makes it easier to not only store information but also to create user forms to suit the user run queries on the stored data and run reports.

Good database design will make a difference for the end user and the amount of effort required in finding the necessary information.

With the help of our excellent trainers, you can learn how to design database that will suit your requirements. From small, one table database design to big databases with multiple tables linked together and automated actions created in Visual Basics, we will be happy to assist with all aspects of database creation.

Please select the version that you’re interested from below:

Please select the level that you’re interested in

Microsoft Access 2016 Introduction

Course Overview

Audience:

This course is designed for new or self-taught Microsoft Access users. It covers all aspects of database design and objects.

Prerequisite:

No Prior experience or knowledge of databases is required to attend this course. You must have good basic Microsoft Windows, keyboard and mouse skills.

Duration:

This is a 2 day MS Access Introduction course. The course starts at 09:30 and runs until 16:30 Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Location:

Our Microsoft Access Introduction course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.

Access 2016 Introduction Course Outline

ACCESS BASICS

Familiarity with access screen

Ribbon and toolbar explanations

Prebuilt database template access and creation

Database Terms Planning

An explanation of databases in general, database objects within access and terminology

Plan your Database (Tables, Queries, Forms, Reports, Macros, Pages and Modules)

Plan a database structure (tables) (normalisation techniques)

Create a new database file

WORKING WITH TABLES

Design a table, conventions for entering naming objects and fields (Design View)

Create a table in datasheet view and edit field names

Select data types and enter field descriptions

Set a Primary Key

Remove a Primary Key

Define field properties (Default values, Input masks, Validation rules and format options)

Insert, Delete, Move and Rename Fields (design view and datasheet view)

Create a table with a wizard

Using the ribbon to set field properties Entering and Editing Data

Accessing objects through the navigation pane

Switch between object Tabs

Switch Views in Access (design, layout and data entry)

Entering and Editing Data (Records & Fields)

Navigating the datasheet

Working in Data Entry Mode

Sorting Data, Finding & Replacing Data

Hiding and Unhiding Fields

Create multiple tables to normalise data Relationships

RELATIONSHIPS EXPLAINED

Different types of relationships

Conditions needed for setting up a relationship

Ensuring Referential Integrity

Printing Relationships in a Report

Insert Sub Datasheets into a table

Change or remove Sub Datasheets from a table

Expand and Contract Sub Datasheets

Enter data in related tables

QUERIES & FILTERS

Create a filter by selection

Create a filter by form

Use AND/ OR options

Save a filter as a select query

Run a Select Query

Build a query from the create ribbon

Creating a query using a wizard

Build a query using the Query Design Window
Adding fields to a query, choose which fields to showRemoving fields from a query

Sort data in a select query

Enter Text, numeric, date, and logic criteria

Enter sub string searches using wild Card Characters

Use the BETWEEN, AND, OR, NOT, NULL criteria in your query

Calculate a field

Concatenate text

Save and name a query

Rename, edit or delete a query Multi Table Queries

Build a query across more than one table

Joining Tables for a query (more relationships)

Setting Join Properties – Inner and Outer Joins

Find Unmatched records Query Wizard

Find Duplicate records Query Wizard

CREATING FORMS

Create a Form using the Auto Form tool Tabular/Datasheet/Pivot Form wizard

Create a Form using the Form Wizard

Create a form in design view

Create a form in layout view

Understand the views and switch between them

Setting data source for a form

Setting the data source using SQL source code

The Field List

Resizing Forms

Control types

Adding controls

Resize and Move Controls

Changing control properties

Selecting Controls

Formatting Controls

Use the Format Painter and AutoFormat

Set basic form properties

Data Entry in Forms

Navigation in data entry view

Add, edit, delete a record in form view

REPORTS

Standard Reports using Wizard

Insert, Move, Size and delete controls

Editing record source

Page setup

Print your report

Show more
One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say

Extras

This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.