Computers

Courses > Computers

Microsoft Access Office 365, 2013 & 2019 – Advanced Level

Course Aim:

This training course is designed to give existing users of Access a more in-depth look into some of the more advanced features of Microsoft Access allowing the candidates to get the most from this application.

Client Profile:

It is important that each client has previous experience and a good working knowledge of Microsoft Access. Ideally each client would have access to a computer system where Microsoft Access available to maximise learning post training.

Good Working knowledge – Experience of working with Microsoft Access and creating tables, queries, forms and reports.

Course Outline:

  • Update, summary, append and deletion queries
  • Creating a Form, The form Wizards, The form toolbox
  • Customising the appearance of forms
  • Objects and properties, Managing different types of events
  • Automating a form
  • User navigation
  • Restricting user input
  • Referential integrity
  • Sub-forms
  • Controlling multiple forms
  • List and combo boxes
  • Reports
  • Grouping and sorting
  • Creating summaries
  • Sub-reports
  • Basing reports on queries
  • Macros
  • Auto exec macro
  • Specifying conditions
  • Review of the basics
  • Database design
  • Building & modifying forms
  • Advanced queries
  • Queries using calculations
  • Action queries
  • Creating Macros & producing reports
  • Using calculations in reports

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.