catraining

 

Microsoft Partner

Microsoft Access 2010 Advanced

Audience: This course is designed for existing Access 2010 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 2010 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:
  • Apply Form controls
  • Use the Date Picker control
  • Add Combo, List and Check Boxes to the Form
  • Create forms using Mainform – Subform
  • Use Conditional formatting
  • Create Pivot Tables

 

 


Course Content

print this page
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
  • Split forms
  • Using Conditional formatting
  • Additional Form topics
  • Creating Pivot Tables
Module 2: Advanced Reports
  • 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 to an Access database
  • Export a table to Excel and text files
  • Exporting reports
  • Export to HTML format
Module 5: Using Access Macros
  • Uses of a Macro
  • Creating you first macro
  • Running a macro
  • Autokeys
  • 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