MOS: Access 2013 Level 3 for Windows

Description

In this course, you will cover the more advanced functions of working with Microsoft Access 2013, such as,
writing SQL statements and attaching the SQL queries to Access controls; creating and using crosstab and
parameter queries, creating, running and modifying macros, working with advanced macros that require user
input and for data transfer, importing, exporting and linking objects, and finally key database management
concepts.

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

Curriculum

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

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

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

Advanced Macros
• Creating macros to provide user interaction
• Creating macros that require user input
• Creating AutoKeys and AutoExec macros
• Creating macros for data transfer

Importing, exporting, and linking objects
• Importing objects
• Exporting objects
• Working with XML documents
• Linking Access objects
• Using hyperlink fields

Database management
• Optimizing resources
• Protecting databases
• Setting options and properties

Enrolled