Microsoft Access 2013 Level 2

Master advanced Microsoft Access 2013 techniques to enhance your database skills and prepare for certification with our specialized course designed for aspiring database professionals.

Course Thumbnail

Essential Skills Gained

Checkmark

Normalize a database using fundamental database concepts.

Checkmark

Join tables in queries and use calculated fields for dynamic data manipulation.

Checkmark

Utilize advanced form controls to increase user interactivity.

Checkmark

Design and generate comprehensive reports with embedded charts.

Format

  • Instructor-led
  • 1 days with lectures and hands-on labs.

Audience

  • Database professionals
  • Microsoft Access users
  • Certification candidates
  • IT support staff

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, subforms and subreports, navigation forms, and calculated fields.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Unit 1: Relational databases

  1. Database normalization

  2. Table relationships

  3. Referential integrity

Unit 2: Related tables

  1. Creating lookup fields

  2. Modifying lookup fields

  3. Subdatasheets

Unit 3: Complex queries

  1. Joining tables in queries

  2. Using calculated fields

  3. Summarizing and grouping values

Unit 4: Advanced form design

  1. Adding unbound controls

  2. Graphics

  3. Adding calculated values

  4. Adding combo boxes

  5. Advanced form types

Unit 5: Reports and printing

  1. Report formatting

  2. Calculated values and subreports

  3. Printing

  4. Label printing

Unit 6: Charts

  1. Charts in forms

  2. Charts in reports

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.