• CATALOG
  • FINANCIAL ASSISTANCE
  • MILITARY
  • LOGIN
Iowa Western Community College
Home > Training Programs > Microsoft > Microsoft Access 2013 Certification Training
CALL
NOW

855.520.6806

Fill out the form below

By continuing you are agreeing to have ed2go contact you.
Close Window

Thank you for your interest in this program. We should be contacting you shortly.

Close Window

Microsoft Access 2013 Certification Training

microsoft-2013-access-certification
$595.00 (USD)

DETAILS

OUTLINE

I.    Quick Overview of the Access User Interface
    A. Access Ribbon
    B. Quick Access Toolbar
    C. Object Navigation Pane
    D. Access Work Surface
    E. Access Options Dialog Box
    F. Object Overview
    G. Process Overview

II.    Fundamentals
    A. Approaches to Database Design
    B. Gather Information
    C. A Few Words about Naming Conventions
    D. Exercise:  Gathering Information
    E. Normalization
    F. Table Relationships

III.    Tables and Their Views
    A. Definition and Purpose
    B. Datasheet View
    C. Design View

IV.    Tables
    A. Creating an Access Database
    B. Data Types
    C. Create a Table in Design View

V.    Queries
    A. Queries
    B. Select Queries
    C. Select Queries with Criteria
    D. Logical Operations

VI.    Forms
    A. Forms
    B. One-Click Forms
    C. Form Wizard

VII.    Reports
    A. Reports
    B. One-Click Report
    C. Report Wizard

VIII.    Optional:  Databases and Access Terms
    A. "Database" Defined
    B. Databases vs Spreadsheets
    C. Questions to Ask When Deciding Whether to Use a Spreadsheet or a Database
    D. Access vs Excel
    E. Discussion Questions
    F. "Relational Database" Defined
    G. Terminology
    H. Observations
    I. "Relational Database Management System" (RDBMS) Defined
    J. Access Is an RDBMS
    K. Benefits and Limitations of Access
    L. Discussion Questions

IX.    Relationships
    A. Review
    B. Referential Integrity
    C. Relationships
    D. A Few Words about Naming Conventions

X.    Queries
    A. Query Design View
    B. Review of Select Queries
    C. Review of Select Queries with Criteria
    D. Logical Operations
    E. Parameter Queries
    F. Action Queries

XI.    Table Functions
    A. Importing Data
    B. Exporting Data

XII.    Forms
    A. Design View
    B. Formatting
    C. Tab Order

XIII.    Reports/Design View
    A. Report Sections
    B. Adding a Report Header/Footer
    C. Adding a Logo to the Report Header
    D. Adding a Title to the Report Header
    E. Adding Fields to a Report
    F. Arranging Fields on a Report
    G. Resizing the Detail Section
    H. Eliminating Repeating Headings
    I. Grouping and Sorting
    J. Setting Properties on a Report
    K. Adding Record Counts
    L. Special Report Fields
    M. Controls
    N. Printing a Report

XIV.    Macros
    A. Macro Basics
    B. Running a Macro

XV.    Completing the Desktop Application
    A. The Navigation Form
    B. Running Macros from a Navigation Form
    C. Setting the Navigation Form as the Default Form
    D. Splitting the Database
    E. Distributing the Front-end Database

REQUIREMENTS

PREREQUISITES

INSTRUCTOR

FAQS

Iowa Western Community College

Continuing Education
2700 College Road
Council Bluffs, IA 51503 US
MAIN CONTENT

Copyright © Education To Go. All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Education To Go. Education To Go and ed2go are registered trademarks of Education To Go, a part of Cengage Learning.