• CATALOG
  • MILITARY
  • LOGIN
      Forget your password?
  • Open Search Dialog
McDowell Technical 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

  1. Quick Overview of the Access User Interface
    1. Access Ribbon
    2. Quick Access Toolbar
    3. Object Navigation Pane
    4. Access Work Surface
    5. Access Options Dialog Box
    6. Object Overview
    7. Process Overview
  2. Fundamentals
    1. Approaches to Database Design
    2. Gather Information
    3. A Few Words about Naming Conventions
    4. Exercise: Gathering Information
    5. Normalization
    6. Table Relationships
  3. Tables and Their Views
    1. Definition and Purpose
    2. Datasheet View
    3. Design View
  4. Tables
    1. Creating an Access Database
    2. Data Types
    3. Create a Table in Design View
  5. Queries
    1. Queries
    2. Select Queries
    3. Select Queries with Criteria
    4. Logical Operations
  6. Forms
    1. Forms
    2. One-Click Forms
    3. Form Wizard
  7. Reports
    1. Reports
    2. One-Click Report
    3. Report Wizard
  8. Optional: Databases and Access Terms
    1. "Database" Defined
    2. Databases vs Spreadsheets
    3. Questions to Ask When Deciding Whether to Use a Spreadsheet or a Database
    4. Access vs Excel
    5. Discussion Questions
    6. "Relational Database" Defined
    7. Terminology
    8. Observations
    9. "Relational Database Management System" (RDBMS) Defined
    10. Access Is an RDBMS
    11. Benefits and Limitations of Access
    12. Discussion Questions
  9. Relationships
    1. Review
    2. Referential Integrity
    3. Relationships
    4. A Few Words about Naming Conventions
  10. Queries
    1. Query Design View
    2. Review of Select Queries
    3. Review of Select Queries with Criteria
    4. Logical Operations
    5. Parameter Queries
    6. Action Queries
  11. Table Functions
    1. Importing Data
    2. Exporting Data
  12. Forms
    1. Design View
    2. Formatting
    3. Tab Order
  13. Reports/Design View
    1. Report Sections
    2. Adding a Report Header/Footer
    3. Adding a Logo to the Report Header
    4. Adding a Title to the Report Header
    5. Adding Fields to a Report
    6. Arranging Fields on a Report
    7. Resizing the Detail Section
    8. Eliminating Repeating Headings
    9. Grouping and Sorting
    10. Setting Properties on a Report
    11. Adding Record Counts
    12. Special Report Fields
    13. Controls
    14. Printing a Report
  14. Macros
    1. Macro Basics
    2. Running a Macro
  15. Completing the Desktop Application
    1. The Navigation Form
    2. Running Macros from a Navigation Form
    3. Setting the Navigation Form as the Default Form
    4. Splitting the Database
    5. Distributing the Front-end Database

REQUIREMENTS

PREREQUISITES

INSTRUCTOR

FAQS

McDowell Technical Community College
Continuing Education
54 College Drive
Marion, NC 28752 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.