Microsoft Access 2016 Level 2

Details

Description

 

  • You will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts; and create specialized objects such as lookup fields, sub forms and sub reports, navigation forms, and calculated fields.

What's Included

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

Training Solutions

Training Solutions

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

Schedule

1 Day

Curriculum

Curriculum

  • Unit 1: Relational databases

    • Topic A: Database normalization
    • Topic B: Table relationships
    • Topic C: Referential integrity

    Unit 2: Related tables

    • Topic A: Creating lookup fields
    • Topic B: Modifying lookup fields
    • Topic C: Subdatasheets

    Unit 3: Complex queries

    • Topic A: Joining tables in queries
    • Topic B: Using calculated fields
    • Topic C: Summarizing and grouping values

    Unit 4: Advanced form design

    • Topic A: Adding unbound controls
    • Topic B: Graphics
    • Topic C: Adding calculated values
    • Topic D: Adding combo boxes
    • Topic E: Advanced form types

    Unit 5: Reports and printing

    • Topic A: Report formatting
    • Topic B: Calculated values and subreports
    • Topic C: Printing
    • Topic D: Label printing

    Unit 6: Charts

    • Topic A: Charts in forms
    • Topic B: Charts in reports