MOS: Access 2013 Level 3 for Windows

Description

Duration: 1 day

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 the 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

StartFinishPublic PricePublic Enroll Private PricePrivate Enroll
01/18/202101/18/2021
02/08/202102/08/2021
03/01/202103/01/2021
03/22/202103/22/2021
04/12/202104/12/2021
05/03/202105/03/2021
05/24/202105/24/2021
06/14/202106/14/2021
07/05/202107/05/2021
07/26/202107/26/2021
08/16/202108/16/2021
09/06/202109/06/2021
09/27/202109/27/2021
10/18/202110/18/2021
11/08/202111/08/2021
11/29/202111/29/2021
12/20/202112/20/2021

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