Microsoft Access – Introduction

by Elliott Training UK Claim Listing

On successful completion of the course, delegates will be able to design tables, setup relationships, produce complex queries and create forms and reports using the Wizards.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Elliott Training UK Logo

img Duration

2 Days

Course Details

Overview

On successful completion of the course, delegates will be able to design tables, setup relationships, produce complex queries and create forms and reports using the Wizards.

 

Prerequisites

Prior experience of Windows

 

Course Content

Introduction to Databases

  • Examine Database Concepts?

  • Understanding the main concepts of a Database e.g. Records, Fields

  • The advantages of a Relational Database

The Access Environment

  • Explore the User Interface

  • Explore the Ribbon

  • Navigation Pane

  • Customize the Access Environment

  • Obtain Help

  • Access Terminology

  • Table, Form, Report, Query, Dynaset, Objects

Creating a database

  • Creating a database

  • Creating objects

  • Opening and closing the database window

Tables

  • Designing the structure of a table

  • Creating a table

  • Adding and deleting fields

  • Designate primary fields

  • Saving and modifying the table

Field properties

  • Setting display formats

  • Setting default values

  • Validation checks

  • Indexing

Relationships

  • Creating 1:many and 1:1 relationships

Datasheets

  • Adding records

  • Navigating within the datasheet

  • Modifying and deleting records

  • Customising

  • Sorting

  • Freezing Columns

Finding Records

  • Finding records

  • Using Filters

  • Different Filter Types

Query Basics

  • Introduction to queries

  • Creating a query

  • Adding fields to a query

  • Moving between the query window and its dynaset

  • Saving, closing and opening a query

  • Selecting all fields for a query

  • Moving, inserting and deleting fields

  • Changing data in a query’s dynaset

  • Forms for queries

Advanced Queries

  • Overview of basic Queries

  • Specifying criteria

  • Joining fields

  • Queries with multiple tables

  • Calculations within Queries

  • Creating a Parameter field

Designing and Enhancing Forms

  • Why create a form?

  • Creating forms using the Form Wizard

  • New WYSIWYG forms design interface

  • Customising forms further

  • Overview of creating forms manually and using the Wizard

  • Adding labels and fields

  • Adding Combo boxes and List boxes

  • Adding Option boxes

  • Modifying the layout using lines, rectangles and colour

  • Inserting calculated fields

  • Looking up a value from another table – Dlookup

  • Adding macro buttons

Printed Reports

  • Why design a report

  • Using the Report Wizard

  • The Report Designer

  • Overview of creating a report

  • Calculated controls and statistical fields

  • Sorting and grouping data

  • Improved Grouping Pane

  • Including graphs in reports

  • Organising reports

  • Creating a mail shot from a report

  • Printing tables and forms

  • Modifying the print setup

  • Interactive Report Browse

  • Gloucester Branch

    Pure Offices Kestrel Court, Waterwells Drive, Gloucester

Check out more MS Access courses in UK

Kirklees College Logo

Microsoft Office Specialist (Word)

Microsoft Office Specialist certification is a prestigious credential chosen by individuals seeking to validate their skills using the Microsoft packages or build on already existing skills for improved employability and career progression.

by Kirklees College [Claim Listing ]
Elliott Training UK Logo

Microsoft Excel – Advanced

Our Microsoft Excel Advanced course is a highly practical and interactive tutor-led session delivered by highly experienced Microsoft Certified Trainers. Delegate numbers are kept low to ensure individual support can be given to each participant.

by Elliott Training UK [Claim Listing ]
Glide Training Logo

Microsoft Office Training

We design and deliver bespoke Microsoft Office training courses tailored to your requirements. We can cover any version from Office 2010 to the latest 2019 release (including Office 365), depending on which is used in your organisation.

by Glide Training [Claim Listing ]
Excellence IT Logo

Microsoft Visio Course

Enhance your diagramming skills with our Microsoft Visio training. Suitable for all experience levels, our expert-led courses will teach you how to create professional flowcharts, diagrams, and organisational charts. Empower your team to visualise data and processes clearly and efficiently.

by Excellence IT [Claim Listing ]
Kaplan UK Logo

Introduction To Excel Functionality

Microsoft Excel is one of the most important business tools any of us will use. It’s the tool of choice for presenting and analysing data. However, even though Excel is so widely used, much of the workforce don’t know how to apply all of the fantastic tools which are available.

by Kaplan UK [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy