600 Maryland Avenue, S.W.,
Washington, DC 20024-2520



Or find a course by:

Microsoft Access 2010: Advanced

Home / Course Details

  • ORegistration open
  • FClass full
  • GGuaranteed to Go
  • RRemote Classroom
Multiple Registrations?
Session Schedule Location Tuition Status
Sep 27 - Sep 28, 2017
08:30 - 16:00 , Wed-Thu
Washington , DC $749 G
Displaying of 1 sessions Show All Show Less

Course overview

This course covers advanced functions of Access 2010. Students will write SQL statements and attach them to command button controls. They will also explore action queries as well as create and run sophisticated macros to automate tasks. Importing and exporting objects from Excel, XML documents, and other Access databases are covered in depth. In addition, selected applications development tasks such as creating switchboards and splash screens are examined.

Who should attend?

Microsoft Access users who seek a thorough knowledge of the advanced concepts of the access application.

Learning outcomes

  • Discuss, examine, and write SQL statements in Access
  • Attach a SQL query to a control in a form
  • Create macros and attach them to events of forms and command buttons
  • Create macros for data transfer between other applications
  • Import objects from Access databases and Excel worksheets
  • Export and import XML documents
  • Use Access data management tools such as compact and repair, splitting a database, and passwords and encryption

Chat Now