Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back

Microsoft Access Intermediate - One Day

Course overview

Use a range of query criteria to extract exact data in professional outputs and automate your database with action buttons.

Course duration

1 day

Delivery method

Flexible (Online/Classroom)


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

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

Suitable for

Those who already work with Microsoft Access, who need to develop more complex, relational databases by using more sophisticated querying tools and creating multi-table forms and reports.

Learning outcomes

By the end of the course, you will be able to utilise functions such as action and summary queries and create calculations in queries, forms and reports. You will also be able to apply basic automation through the use of command buttons.

Course content

Importing, Exporting and Linking Data:

  • Exploring successful table design.
  • Creating and using a hyperlink field.
  • Multiple-field primary key.
  • Exploring field properties.
  • Creating input masks and validation rules.
  • Import and export access data.
  • Import and export data from other sources.
  • Link Access data.

More on Queries:

  • Parameter queries.
  • Creating a calculated field in a query.
  • Use the expression builder to create a calculation.
  • Summarise data in a query.
  • Creating and running action queries. 

Transforming Forms and Reports:

  • Working with form and report sections.
  • Working with bound and unbound controls.
  • Creating a calculated control.
  • Exploring the form design work surface.
  • Multi-table forms:
    • Creating main forms and subforms.
    • Creating linked forms.
  • Understanding control properties.
  • Changing control properties.
  • Applying themes to forms and reports.
  • Customising theme colours and fonts.
  • Using the command button wizard.
  • Automating forms with command buttons.

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 create a simple relational database in Microsoft Access, including creating basic relationships. They should also be able to interrogate and present data by creating simple 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