Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Access 2013 Level 1 - Database Design

Learn the intermediate features and functionality of Microsoft Access 2013.

GK# 7783

Course Overview

TOP

This course with hands on labs provides you with the knowledge and skills to become familiar with introductory features and functionality relating to entering data, and managing queries and reports using Microsoft Access 2013.

This course includes access to our exclusive Microsoft Office Online Support Program, enabling you to build your skills and expertise after class. The program provides 24x7 access for 60 days to online mentoring via chat from Microsoft Office experts.

Certification:

This course is one of four recommended to help you prepare for Microsoft Exam 77-424: Access 2013, which is required for the Microsoft Office Specialist (MOS): Microsoft Office Access 2013 certification.

What You'll Learn

TOP
  • Identify the components of a database, and work with those components
  • Open a table, find information stored there, and enter data
  • Create and customize a table design
  • Enter data into tables, and ensure its accuracy by using input masks and input validation formulas
  • Create relationships between tables to ensure data accuracy and to deploy referential integrity
  • Create forms for entering data into tables, and change the design elements that have been placed on those forms
  • Create several query types, edit and run queries, and use action and calculation queries
  • Create several report types, enhance reports and print preview reports
  • Import and export data to and from various sources, including text files and Excel
  • Preview and print database objects, and change the page setup options

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. The Basics

  • Database Concepts
  • Getting Started
  • Creating a Database
  • Converting Access 2013 Files
  • Working with Objects
  • Using Access Help

2. Table Data

  • Table Concepts
  • Viewing Data in a Table
  • Changing the Datasheet Appearance
  • Entering and Editing Data
  • Applying Filters

3. Table Design

  • Creating a Table
  • Changing the Table Design

4. Data Entry

  • Data Entry Concepts
  • Data Formats
  • Input Masks
  • Input Validation
  • Adding Records

5. Relationships

  • Relationships Between Tables
  • Creating a Relationship
  • Referential Integrity
  • Removing a Relationship
  • Printing Relationships

6. Creating and Using Forms

  • Creating a Form Using AutoForm
  • Creating a Form Using the Form Wizard
  • Creating a Form in Design View
  • Opening a Form
  • Changing a Form Design
  • Adding Controls
  • Placing Controls
  • Multiple-Choice Controls
  • Error Checking

7. Queries

  • Using the Query Wizard
  • Creating a Query in Design View
  • Selecting and Sorting in a Query
  • Calculations
  • Action Queries
  • Parameter Queries

8. Reports

  • Creating Reports
  • Using the Report Wizard
  • Previewing Reports
  • Creating Reports in Design View
  • Changing Report Design
  • Control Operations
  • Control Attributes

9. Importing and Exporting Data

  • Importing and Exporting
  • Importing a Text File
  • Importing Data from an Access Database
  • Exporting Data
  • Troubleshooting Importing and Exporting Problems

10. Printing

  • Printing Objects
  • Print Preview

Who Should Attend

TOP

This course is intended for participants who are new to Microsoft Access 2013

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Request this course in a different delivery format.
Enroll