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

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

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

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.

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.

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.

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.