Microsoft 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 corrections, 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.
A typical course lasts for a day, usually between 9:30 AM and 4:30 PM, but some clients like to add more days, particularly when they are building their own databases.
Some clients opting for more than a day like a gap between days so that they can apply what they have learnt.
Completion of our Basic Introduction course or practical experience of applying the skills covered in that course to the creation of your own database.