Microsoft Access 2013 Level 2

You will apply database optimization concepts to a simple database, enforce referential integrity, create look-up fields, insert sub datasheets, join tables in queries, use controls to calculate values, insert advanced controls into forms, format and print a report, and insert charts into forms and reports.

Upon successful completion of this course, students will be able to:

  • Normalize a database using basic database concepts

  • Create lookup fields and produce simple subdatasheets

  • Join tables in queries and calculate values via a calculated field

  • Use advanced controls in forms to support user interactivity

  • Design, create, and print an Access 2013 report

  • Include charts in forms and reports

Course Outline

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


Audience

This course is designed for persons who are able to create and modify basic tables, forms, and reports in Microsoft Access 2013, but need to know how to create or modify documents using advanced tools and efficiency procedures. It also aims to assist persons preparing for the Microsoft Office Specialist exams for Microsoft Access 2013.