Microsoft Office Instructor-led Training and Support
Home     Classes and Prices     Course Catalog     About Our Classes     Registration     Your Instructor     Locations     Sitemap  

Microsoft Access 2013/2016 Level III - Course Content

Duration:
One day


Prerequisites:        Microsoft Office Access 2013/2016 Intermediate, or equivalent


Unit 1:           Querying with SQL
Topic A:        SQL and Access
Topic B:        Writing SQL statements
Topic C:        Attaching SQL queries to controls


Unit 2:           Advanced queries
Topic A:        Creating crosstab queries
Topic B:        Creating parameter queries
Topic C:        Using action queries


Unit 3:           Macros
Topic A:        Creating, running, and modifying macros
Topic B:        Attaching macros to the events of database objects


Unit 4:           Advanced macros
Topic A:        Creating macros to provide user interaction
Topic B:        Creating macros that require user input
Topic C:        Creating AutoKeys and AutoExec macros
Topic D:        Creating macros for data transfer


Unit 5:           Importing, exporting, and linking objects
Topic A:        Importing objects
Topic B:        Exporting objects
Topic C:        Working with XML documents
Topic D:        Linking Access objects
Topic E:        Using hyperlink fields


Unit 6:           Database management
Topic A:        Optimizing resources
Topic B:        Protecting databases
Topic C:        Setting options and properties