taking database development to the next stage

Access 2010, 2013 and 2016 Intermediate Training Courses

DMW's Intermediate Microsoft Access courses are for anyone who has already set up a database using Access and now wants to fill in gaps in their basic skills and to explore Access's potential to the next stage.

Also, the courses should serve anyone who has inherited a database from someone else and now has responsibility for its smooth running, which may mean making improvements or additions.


Course Duration

This course takes one day on-site, normally between 9:30am and 4:30pm.


Course Prerequisites

Completion of our Basic Introduction course or practical experience of applying the skills covered in that course to the creation of your own database.


Course Content

Tables Further work on table design; validation; input masks.

Attaching tables Linking to data outside a database.

Importing Importing data from other sources, including Excel.

Query parameters Making queries respond to user input.

Query expressions Performing calculations and data manipulation from within a query.

Append queries Using an action query to add data to a table.

Update queries Using an action query to change data in a table.

Delete queries Using an action query to remove unwanted records from a table.

Queries and forms Using a form to apply query criteria.

Form design Further work on designing; main forms and sub-forms.

Form controls List boxes, combo boxes, command buttons.

Form expressions Calculations and data manipulation within a form.

Pop-up forms Forms for database navigation and data selection.

Reports More on report design; reports and sub-reports; adding sections; techniques for filtering data.