Live Webinar - ITIL 4 Overview - What’s New from ITIL v3 to ITIL 4

closeClose

Microsoft Access 2010 Level 2 - Advanced Database Design

Course Details
Code: 8255
Tuition (USD): $275.00 $247.50 • Classroom (1 day)

In this clinic with hands-on labs, you will gain the knowledge and skills to work with intermediate features and functionality relating to Microsoft Access 2010 databases.

Skills Gained

  • Understand the databases that will be used during the course
  • Enhance tables by creating lookups
  • Create various types of advanced queries
  • Create advanced forms by adding controls, subforms, calculations, and graphic images
  • Create advanced reports by adding controls, grouping, subforms, calculations, graphic images, and charts
  • Work with and create web-based objects

Who Can Benefit

Those who are familiar with Microsoft Access 2010

Course Details

1. Database Overview

  • Database Basics
  • Review Exercise

2. Enhancing Tables

  • Copying a Database Object
  • Lookup Fields
  • Creating a Lookup
  • Review Exercise

3. Advanced Queries

  • Query Overview
  • The Query Wizard
  • Nested Queries
  • Query Joins
  • Make Table Queries
  • Append Queries
  • Summary Queries
  • Crosstab Queries
  • Review Exercise

4. Advanced Forms

  • Form Design
  • Controls
  • Form Properties
  • Subforms
  • Advanced Calculations
  • Customizing Forms
  • Review Exercise

5. Advanced Reports

  • Designing Reports
  • Sorting and Grouping
  • Layout Properties
  • Calculations
  • Subreports
  • Graphic Reports
  • Chart Wizard
  • Review Exercise

6. Supplemental Topics: Working with Web Tools

  • Working with Web Pages
  • Hyperlinks