Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back

Microsoft Access Advanced - Two Day

Course overview

Develop databases with complex structures and automated interface.  

Course duration

2 days

Delivery method

Flexible (Online/Classroom)


Open participant course: £390 per person - maximum 10 people

Closed company course: £2,000 per course - maximum 10 people

Suitable for

Those who need to develop databases that have complex structures or require an easy to use interface for a team or organisation to use.

Learning outcomes

By the end of the course, you will be able to develop databases that include automated features such as macros and command buttons and utilise complex queries, forms and reports using grouping tools and including calculations.

Course content

Normalisation and Relationships:

  • Understanding normalisation.
  • Relationship join types.

Advanced Query Features:

  • Changing the join type in a query.
  • Find unmatched queries.
  • Find duplicates query.
  • Crosstab queries.

Advanced Report Features:

  • Multiple table reporting.
  • Sorting and grouping report data.
  • Performing calculations on reports.
  • Creating custom report pages.

Advanced Form Features:

  • Bound and unbound controls.
  • Creating a calculated control.
  • Toggle buttons, options and checkboxes.
  • Option groups.
  • List boxes and combo boxes.
  • Page tabs

Creating and Modifying Charts:

  • Forms and reports using the chart wizard.
  • Creating a global chart.
  • Creating a record bound chart.
  • Formatting charts.
  • Using pivot chart view.

Macros and Database Automation:

  • Creating a macro.
  • Running a macro.
  • Macro examples.
  • AutoExec macros.
  • Designing and creating navigation forms.
  • Designing application menus.
  • Start-up options and defaults.

Multi-user Databases:

  • Storing databases on a network.
  • Shared databases.
  • Setting database passwords.

Database Management Tools:

  • Backing up a database.
  • Compacting and repairing a database.
  • Front end and back end databases.
  • Database documenter.

Course requirements

This course can be delivered remotely or in a classroom environment, to suit your requirements.

Delegates must have the following equipment to attend this training remotely:

  • PC or laptop with a microphone and speakers (webcam is preferred but not essential).
  • Access to the internet and web browser application (e.g. Google Chrome).
  • An email account for file sharing.

Attendees should be able to confidently design and develop multiple table Access databases. Attendees will require a good understanding of relationships and the four core elements of Microsoft Access, i.e. tables, queries, forms and reports.

For more information about this course please contact us.

Queens Court Regent Street Barnsley South Yorkshire S70 2EG
Tel: 01226 216760 | Email: |

These course details were downloaded on 20/04/2024

Enquire Now