Develop databases with complex structures and automated interface.  

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

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

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

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.

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.

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.