DMW logo
contact@consultdmw.com

Microsoft® Access 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.


Course Content

Ribbon of Microsft Access

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

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.


Course Prerequisites

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


Certificates

On completion of a training course, each attendee receives a Certificate of Attendance, which contains details of the topics covered during the training.

Taking database development to the next level