T: 01473 414414

select courses

we have a wide range of courses proven to be effective
select
courses

We have a wide range of diverse courses proven to be effective

explore
create your own
courses

Partnering with you to develop your solutions

explore
public sector
courses

We have a wide range of courses to suit you. Explore our full range here

explore

Free Download

Please complete this form to instantly receive your FREE PDF by email


Access - Advanced

1 Day

Introduction

Designed for experienced users who wish to extend their knowledge further and for those who are responsible for maintaining databases for other users

Pre-requisites

Participants should have attended the introductory course or have been using the software for at least three months and have an understanding of tables, queries and reports before attending this course to fully benefit.

Benefits

Time efficient manipulation and creation of data to support business decisions.

Programme Objectives

Participants will be able to design a relational database, write complex queries and create advanced forms and reports.  In addition they will be able to develop more sophisticated database models for use in a multi-user environment.

Programme Content

  • A Review of the Basics
  • Indexes
  • Hyperlinks
  • Macros – Creating, Events, Grouping, Conditional
  • Setting up Menu Systems
  • Creating Custom Menus
  • Creating Option Buttons, Combo and List Boxes
  • Startup
  • Switchboard Manager
  • The Need for Security
  • Activating Log On Procedure
  • Setting up User/Group Accounts
  • Determining who has access to the data and assigning permissions

 

Exact content will vary depending on version