Microsoft Access 2010 Advanced Training Course

Course details

In this course, participants will learn to write SQL statements, record and run macros, use the Query Wizard and Design view to create joins, make data validation, data entry, user-input macros and much more!

This training course is now available in Singapore.

This Microsoft Access 2010 Advanced training course can be delivered at your premises anywhere in Singapore by one of our expert local or international trainers.

Outcomes

• Write SQL statements
• Create aliases for fields
• Attach a SQL query to a control in a form
• View a crosstab query and use the Crosstab Query Wizard
• Create single-criterion & multiple-criteria parameter queries
• Use action queries to append, delete & modify records
• Create and run macros
• Attach macros to events and command buttons in forms
• Create data validation, data entry, & user-input macros
• Use the Query Wizard & Design view to create joins
• Export & import XML documents
• Link database objects
• Analyze database performance
• Split a database
• Compact, repair & backup a database
• Assign & remove passwords & encryption
• Open a database in exclusive mode
• Configure Access options
• Populate database file properties

Foreword:

• The final component of the three-part training series of Microsoft Access 2010, this Advanced training course teaches you how to use some of the more advanced features of the software. Those who completed this course will then be considered as experts on Access 2010 and are prepared to take the certification exam for the Microsoft Office Specialist.
• This Access 2010 Advanced training course running in Singapore wide, is rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2010: Intermediate.
• Participants will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.
• This course will help participants prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, participants should complete the Introduction, Intermediate, and Advanced courses for Access 2010.

Prerequisites:

• Access 2010: Intermediate or equivalent experience.

MODULES

Lesson 1 
Querying with SQL

• SQL and Access
• Writing SQL statements
• Attaching SQL queries to controls

Lesson 2 
Advanced queries

• Creating crosstab queries
• Creating parameter queries
• Using action queries

Lesson 3 \
Macros

• Creating, running, and modifying macros
• Attaching macros to the events of database objects

Lesson 4 
Advanced macros

• Creating macros to provide user input
• Creating macros that require user input
• Creating the AutoKeys and AutoExec macros
• Creating macros for data transfer

Lesson 5 
Importing, exporting, and linking objects

• Importing objects
• Exporting objects
• Working with the XML documents
• Linking Access objects
• Using hyperlink fields

Lesson 6 
Database management

• Optimizing resources
• Protecting databases
• Setting options and properties