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
9/23/20249/23/2024
10/14/202410/14/2024
11/4/202411/4/2024
11/25/202411/25/2024
12/16/202412/16/2024
1/6/20251/6/2025
1/27/20251/27/2025
2/17/20252/17/2025
3/10/20253/10/2025
3/31/20253/31/2025
4/21/20254/21/2025
5/12/20255/12/2025
6/2/20256/2/2025
6/23/20256/23/2025
7/14/20257/14/2025
8/4/20258/4/2025
8/25/20258/25/2025
9/15/20259/15/2025
10/6/202510/6/2025
10/27/202510/27/2025
11/17/202511/17/2025
12/8/202512/8/2025
12/29/202512/29/2025
1/19/20261/19/2026

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