Loading Events

Microsoft Access Office 365, 2016 / 2019 – Intermediate Level

Details

Date:
July 29
Time:
8:30 am - 3:30 pm
Cost:
Free
Event Category:
Website:
www.islandtraining.ie

Venue

Online

Event Description

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.

Book Now

Details

Date:
July 29
Time:
8:30 am - 3:30 pm
Cost:
Free
Event Category:
Website:
www.islandtraining.ie

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available

July 29 @ 8:30 am - 3:30 pm

Any Questions?

If you have any questions or queries about this course,
please get in touch with us through the contact form.