Microsoft Access 2010: Intermediate

Pre-Requisites: Microsoft Access® 2010 Basic skills.

5-stars

Key Features

  • Online live classroom available
  • Quality learning materials
  • Small Class Sizes
  • State of the Art Facility
  • Free Retakes
  • Instructor Led Classroom training
  • Certified Industry Experienced Teachers
  • 100% Job Placement assistance

This course focuses on several key topics including: finding and joining data, creating flexible and advanced queries; reports, structuring data, and maintaining a database.

This course is intended for students who want to learn the more complex features of Microsoft Access® and intermediate database development skills

Unit 1: Relational databases

  • Topic A: Database normalization
  • Topic B: Relating tables
  • Topic C: Implementing referential integrity

Unit 2: Related tables

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

Unit 3: Complex queries

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

Unit 4: Advanced form design

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

Unit 5: Reports and printing

  • Topic A: Customized headers and footers
  • Topic B: Adding calculated values
  • Topic C: Printing
  • Topic D: Labels

Unit 6: Charts

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

Unit 7: PivotTables and PivotCharts

  • Topic A: PivotTables
  • Topic B: Modifying PivotTables
  • Topic C: PivotCharts
  • Topic D: PivotTable forms

Course Number : MOUS-7-0401

Duration : 8 hours

1 Step 1

Request Information!

Who you are?

By submitting this form, you are giving your express written consent for Global Information Technology to contact you regarding our programs and services using email, telephone or text.  This consent is not required to purchase goods/services, and you may always call us directly at 1-866-464-4846.

reCaptcha v3
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right
FormCraft - WordPress form builder