Microsoft Access 2013 Advanced
Audience: This course is designed for existing Access 2013 users who want to start automating database tasks or simplify complex database sequences.
Course Duration: 1 day(1)
Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.
Course Location: This Microsoft Access 2013 Advanced training course is delivered at our training centre in London situated close to Liverpool Street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.
MOS Excel Specialist / Expert Exam Costs ( optional )
All Vouchers now include a Retake Voucher
Option 1 - Voucher & RetakeOption 2 - Voucher, Retake and Gmetrix ( Test Prep )
Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual
Discount 4 for 3 on MOS Exam Packs
After completing this course, students will be able to:
- Work in Form design view
- Apply Form controls
- Add Combo, List and Check Boxes to the Form
- Create Tabular Forms
- Create forms using Mainform – Subform
- Use Conditional formatting
- Create a user switchboard
- Automate tasks using Macros
Course Content

Module 1: Creating Forms
- Working in Form design view
- Applying Form controls
- Date Picker control
- Adding Combo, List and Check Boxes to the Form
- Creating forms using Mainform – Subform
- Tabular forms
- Pivot Tables
- Using Conditional formatting
- Additional Form topics
Module 2: Advanced Reports
- Creating a Switchboard
- Using the Report Wizard
- Working with Report properties
- Grouping Reports
- Applying calculations in Reports
- Additional topics
Module 3: Advanced Query Techniques
- Working with Join properties
- Unmatched data
- Crosstab queries
- Union queries
- Action Queries
- Find duplicates query
- Find unmatched query
Module 4: Importing and Exporting Access Data
- Importing a spreadsheet from Excel
- Linking data tables into an Access database
- Export a table to Excel and text files
- Exporting reports
Module 5: Using Access Macros
- Benefits of using a macro
- Creating your first macro
- Running a macro
- Autokeys macros
- Attaching a macro to a command button
- Running a macro from field properties
- Creating conditional macros
- Using sub macros
Module 6: Customising Access databases
- Database tools and utilities
- Compacting a database
- Hiding database objects
- Start-up options
Call us now for further information Tel:08001601666
-
Floor 7 Crystal Gate, 28 - 30 Worship Street London
EC2A 2AH