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.
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.
Course Duration and Prerequisites
This course takes one day on-site, normally between 9:30am and 4:30pm.
You’ll need experience of the topics cover in DMW’s Basic Introduction or practical experience of gaine from creation of your own databases.