Microsoft Access Training Courses

Enliten IT’s Microsoft Access training courses start with good database design principles through to data manipulation using tables, queries, reports and VBA.  Whichever training course you choose you will find lots of useful tips and tricks for getting the most out of MS Access so that you'll be more productive at work.

We have Microsoft Access trainers in London, Essex, Cambridgeshire, Hertfordshire and throughout the UK so most of our clients take advantage of our, cost effective, tailored onsite training options (we come to you).  Alternatively, you can come to one of our training centres.

We train on ALL versions of MS Access, please call for older version course outlines.

Microsoft Access Training Courses
Home > Training > Microsoft Access Training Courses > Access 2016 Introduction course

Access 2016 Introduction course

2 days

This Microsoft Access 2016 Introduction course provides delegates to the necessary skills to create straightforward databases from scratch.  Starting with an understanding of database design principles, through to hands-on work in creating databases that you can easily be managed through basic tasks such as entering and editing data through to finding, sorting, retrieving, reporting and analysing data.

Download PDF

What will you learn?

At the end of this Microsoft Access 2016 Introduction course, delegates will be able to:
  • Design and create a database
  • Create tables and set the primary key
  • Enter/edit data
  • Find data in tables
  • Create Queries and Table relationships
  • Design and create Forms and Reports
  • Print reports
  • Prerequisites

Audience?

Those new to database concepts who need to organise and report on their data, or those who are self taught and need to ‘fill in the missing bits’.

Course Contents


Introduction

  • Overview of Database concepts
  • Database Design tips & Planning
  • Screen layout, Ribbons
  • Backstage view
  • Database Objects
  • Object Types

On-Line Help

  • Wizard & Index

Field Properties Explained

  • Properties: Field Size, Format, Decimal places, Caption, Default Value, Required, Indexed
  • Validation Rules
  • Input Mask

Create and Find

  • Create and Edit records
  • Select/Save/Delete records
  • Navigating records
  • Sorting records
  • Find & Replace

Filters

  • By Selection/Form
  • Using AND/OR
  • Save as a Select Query

Tables

  • Creating a New Database
  • Designing Tables
  • Design and Datasheet View
  • Field Names and Data Types
  • Primary Key
  • Fields in Tables

Editing Tables

  • Adding / Editing / Deleting records
  • Analysing a Table
  • Relationship in Splits
  • Modifying Tables
  • Lookup and Hyperlink Column

Relationships

  • Create a Relationship
  • Referential Integrity
  • Many-to-Many Relationships
  • Lookup fields

Queries & Operators

  • Queries and RecordSets
  • Simple Query Wizard
  • Add Tables to a Query
  • Join Tables in a Query
  • Use Operators
  • Calculated Fields & Concatenate
  • Using Parameters
  • Action Queries
  • AND/OR/BETWEEN/NOT/NULL
  • Wildcards

Advanced Queries

  • Top Values in Query
  • Calculated Field
  • Function Query
  • Parameter Query
  • Concatenation Query
  • Multiple Tables in Query
  • Inner & Outer Joins

Query Modification

  • Sort Query
  • Add Criteria/Record
  • Hide Fields
  • Print Query
  • Analysis Table
  • Relationships in Splits
  • Table Analyser

Forms

  • Using Forms Wizard
  • Design & Layout view to create/edit forms
  • Viewing, Editing and Printing
  • Control types and Control properties
  • Selecting & Formatting controls
  • AutoForm

Reports

  • Create AutoReports
  • Use and Format Reports
  • The Reports Wizard
  • Print Reports (inc. headers & footers)

Printing

  • Table Data
  • Page Setup and Selected Records
  • Print to PDF

Course Materials

Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable. These may be either paper based or in Adobe pdf format or a combination thereof.

“Informative although very in-depth, enjoyable nonetheless. Very well presented, trainer also has a good sense of humour.  Diane, J.F. Hunt Group”Very well presented, trainer also has a good sense of humour

Prerequisites

No prior MS Access knowledge is assumed however a familiarity with database concepts is advantageous.


Additional Information

Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.

The suggested course duration is a guideline. Course topics and duration on this Microsoft Access 2016 Introduction course may be modified by the instructor based upon the knowledge and skill level of the course participants.