Introduction to Microsoft Access 2013

Introduction to Microsoft Access 2013

This Introduction to Microsoft Access 2013 training class starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports.
12 Months Access / 21 Course Hrs
  • Details
  • Syllabus
  • Requirements

Details

This Introduction to Microsoft Access 2013 training class starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports.

Enrollment Options:
Self-Paced
12 Months Access Course Code: T7685
No Instructor, Start Anytime
$149.85 USD

Syllabus

  • Quick Overview of the Access User Interface
    1. Access Ribbon
      1. FILE
      2. HOME
      3. CREATE
      4. EXTERNAL DATA
      5. DATABASE TOOLS
      6. Contextual Tabs
    2. Quick Access Toolbar
    3. Object Navigation Pane
    4. Access Work Surface
    5. Access Options Dialog Box
    6. Object Overview
      1. Tables
      2. Queries
      3. Forms
      4. Reports
      5. Macros and Modules
    7. Process Overview
  • Fundamentals
    1. Questions to Ask Before You Start
      1. What Is the Purpose of the Database?
      2. Who Will Use the Database?
      3. What Kind of Output Is Needed from the Database?
      4. What Process Is the Database Replacing or Improving?
    2. Approaches to Database Design
      1. Top-Down Database Design
      2. Bottom-Up Database Design
      3. Reality
    3. Gather Information
      1. Data Mapping
      2. Sample Data Map
    4. A Few Words about Naming Conventions
    5. Exercise : Gathering Information
    6. Normalization
      1. First Normal Form
      2. Second Normal Form
      3. Third Normal Form
    7. Table Relationships
      1. Relationship Types
  • Tables and Their Views
    1. Definition and Purpose
    2. Datasheet View
      1. Selection Tools
      2. Table Layout Tools
      3. Sorting and Filtering Tools
      4. Record Navigation
      5. Working in Datasheet View
    3. Design View
      1. Open a Table in Design View
      2. Design View Layout
  • Tables
    1. Creating an Access Database
    2. Data Types
    3. Create a Table in Design View
  • Queries
    1. Queries
      1. Definition and Purpose
      2. Types
      3. Views
    2. Select Queries
    3. Select Queries with Criteria
    4. Logical Operators
  • Forms
    1. Forms
      1. Definition and Purpose
      2. Views
    2. One-Click Forms
      1. Basic Data Entry Form
      2. Basic Multi-Record Form
      3. Datasheet Form
      4. Split Form
    3. Form Wizard
      1. Create a Form with the Form Wizard
  • Reports
    1. Reports
      1. Definition and Purpose
      2. Views
    2. One-Click Report
    3. Report Wizard
      1. Create a Report Using the Report Wizard
  • 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

Requirements

Operating System Options

  • Windows XP Service Pack 2
  • Windows Vista
  • Windows 7
  • Mac OS X

Browsers for Windows

You need both of the following browsers.

  • Mozilla Firefox 2.0 or greater
  • Internet Explorer 6 or greater

Browsers for Mac OS X

You need both of the following browsers.

  • Mozilla Firefox 2.0 or greater
  • Safari 3.0 or greater