Microsoft Partner

Microsoft Office Access 2007 Advanced

Audience: This course is designed for existing Access 2007 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 2007 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 & Retake

Option 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


View Scheduled Public Courses



reaining course


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 forms using Mainform – Subform
  • Create a Switchboard
  • Run Macros


  • Course Content

    print this page
    Module 1: Creating Forms
    • Working in Form design view
    • Applying Form controls
    • Adding Combo Boxes to the Form
    • Creating forms using Main Form – SubForm
    • Split forms
    • Using Conditional formatting
    • Additional Form topics
    Module 2: Advanced Reports
    • Using the Report Wizard
    • Working with Report properties
    • Grouping Reports
    • Applying calculations in Reports
    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 & Exporting Access Data
    • Importing a spreadsheet from Excel
    • Linking data tables to an Access database
    • Export a table in other formats
    Module 5: Using Access Macros
    • What is a Macro?
    • Creating your first Macro
    • Running a macro
    • Attaching a macro to a command button
    • Running a macro from field properties
    • Creating conditional macros
    • Using sub macros
    Module 6: Creating and Using a Switchboard
    • Creating a Switchboard
    • Using a Switchboard
    Module 7: Customising Access databases
    • Database tools and Utilities
    • Compacting a database
    • Hiding database objects
    • Start-up optionsMicrosoft

Call us now for further information Tel:08001601666