Computers

Courses > Computers

Microsoft Access Office 365, 2016 / 2019 – Intermediate Level

Course Aim:

The aim of this training course is to provide clients with the necessary skills required to maintain an existing database. This advances users that are already familiar with the basics of Access, to use the application more efficiently, building and modifying tables, forms, using back up and restore data tools, importing data etc.

Client Profile:

It is important that each client has previous experience and a basic working knowledge of Microsoft Access.

Ideally each client would have access to a computer system where Microsoft Access is available to maximise learning post training.

Basic Working knowledge – Able to create a basic table, query, form and report.

Course Outline:

  • Introduction
  • Database fundamentals
  • Understanding Tables, Queries,
  • Understanding Forms and Reports
  • Creating tables
  • Data Types
  • Field Size and Formats
  • Setting Validation Rules
  • Setting Validation Text
  • Sorting and Filtering Records
  • Table Relationships
  • Referential Integrity
  • Building Queries
  • Understanding query types
  • Update, summary, append and deletion of queries
  • Creating a Form
  • Inputting data using a Form
  • The form Wizard
  • The from toolbox
  • Reports
  • The Report Wizard
  • Grouping and sorting
  • Creating summaries
  • Sub-reports
  • Basing Reports on queries

Course Location:

Killarney, Kerry | Macroom | Cork City | Online

Course Available as Daytime Training | Night Classes | One-to-One | Online

Course Duration:

1 Full Day.  Please contact Island Computers & Training for more details.

Island-Training-Partners-_0000_ECDL-Logo

There is no course currently scheduled.