Skip to content

Microsoft Access Introduction - In-company (now with live online classes)

Live online classes, Classroom or In Company/Bespoke based course with study materials and tutor support


MS Office Training Ltd

Summary

Price
£550 inc VAT
Finance options

£550 per day of training for in company groups of 8 delegates, £400 for one-to-one...

Study method
Onsite
Duration
2 days · Part-time or full-time
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

6 students enquired about this course

Add to basket or enquire

Overview

Course Objectives

At the end of this course you will be able to:

  • Identify the common objects of an Access database
  • Design and build the structure of a database
  • Input and maintain data
  • Design user-friendly data entry forms
  • Search the database using queries
  • Generate reports from your data

1 year email support service

Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk

With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.

Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.

  • Our competitive rates start from £550.00 per day of training

Tailored training courses:

You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.

Certificates

Certificate of completion

Digital certificate - Included

Description

Introducing Microsoft Access

  • The Access interface

Database terminology

  • Access database objects
  • Fields and records
  • Properties

Designing a database

  • Planning and designing a table
  • Creating fields
  • Setting common field properties
  • Defining key fields

Working with table data

  • Entering and editing data
  • Sorting and filtering table records
  • Deleting records

Relationships

  • Why use table relationships?
  • Relationship types
  • Referential Integrity
  • Working with table subdatasheets

Querying a database

  • Creating simple Select Queries
  • Specifying query criteria
  • Sorting query results
  • Adding calculated fields

Designing Forms

  • Creating simple forms for data entry
  • Designing custom forms
  • Working with form sections
  • Creating sub forms

Designing Reports

  • Creating basic list reports
  • Working with grouping and sorting in a report
  • Adding totals to a report

Who is this course for?

This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data.

Questions and answers

Reviews

5.0
Course rating
100%
Service
100%
Content
100%
Value

FAQs