Skip Ribbon Commands
Skip to main content
Microsoft Office Access 2013 Series
Course Number:(ALTO-091004,5,6)
Course Length:3 Day
Course Price:$1,395
Or Register by Phone 1-888-600-ALTO (2586)

 Upcoming Classes

TBA

 Course Description

Part 1 - A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access 2013 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data. Part 2 - Your training and experience using Microsoft® Access® 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users. Part 3 - You have covered many of the basic functions of Microsoft® Office Access® and now you are ready to learn advanced Access features such as, database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. The training today added to that which you have gained from the previous two days round out your Access education and provide you with marketable job skills. You can use all of these courses to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.

 Course Outline

Part 1

Target Student:

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2013, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Prerequisites:

To ensure success, students should be familiar with using personal computers, and should have experience using a keyboard and mouse. Students should be comfortable in the Windows® 8 environment, and be able to use Windows 8 to manage information on their computers. Specific tasks the students should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders. To meet this prerequisite, you can take any one or more of the following Logical Operations courses:

  • Using Microsoft® Windows® 8
  • Microsoft® Windows® 8 Transition from Windows 7

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help in Microsoft Access

Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

Topic C: Create Lookups

Lesson 3: Querying a Database

Topic A: Join Data from Different Tables in a Query

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries

Topic B: Create Action Queries

Topic C: Create Unmatched and Duplicate Queries

Topic D: Summarize Data

Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Lesson 6: Customizing the Access Environment

Topic A: The Access Options Dialog Box

Part 2

Target Student:

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

Prerequisites:

To ensure your success, it is recommended you have completed Microsoft® Office Access® 2013: Part 1, or possess equivalent knowledge.

Lesson 1: Designing a Relational Database

Topic A: Relational Database Design

Topic B: Create a Table

Topic C: Create Table Relationships

Lesson 2: Joining Tables

Topic A: Create Query Joins

Topic B: Join Tables That Have No Common Fields

Topic C: Relate Data within a Table

Topic D: Work with Subdatasheets

Topic E: Create Subqueries

Lesson 3: Organizing a Database for Efficiency

Topic A: Data Normalization

Topic B: Create a Junction Table

Topic C: Improve Table Structure

Lesson 4: Sharing Data Across Applications

Topic A: Import Data into Access

Topic B: Export Data to Text File Formats

Topic C: Export Access Data to Excel

Topic D: Create a Mail Merge

Lesson 5: Advanced Reporting

Topic A: Organize Report Information

Topic B: Format Reports

Topic C: Include Control Formatting in a Report

Topic D: Add a Calculated Field to a Report

Topic E: Add a Subreport to an Existing Report

Appendix A: Additional Reporting Options

Part 3

Target Student:

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2013 and need to learn advanced skills.

This course is also for students who seek the Microsoft Office Specialist (MOS) certification and who want to prepare for Exam 77-885, Microsoft Office 2013.

Prerequisites:

To ensure your success in your course you should have experience working with Microsoft Access 2013, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:

  • Microsoft® Office Access® 2013: Part 1
  • Microsoft® Office Access® 2013: Part 2

    Lesson 1: Implementing Advanced Form Design

    Topic A: Add Controls to Forms

    Topic B: Create Subforms

    Topic C: Organize Information with Tab Pages

    Topic D: Enhance Navigation of Forms

    Topic E: Apply Conditional Formatting

    Lesson 2: Using Data Validation

    Topic A: Field and Record Validation

    Topic B: Form Validation

    Lesson 3: Using Macros to Improve User Interface Design

    Topic A: Create a Macro

    Topic B: Restrict Records Using a Condition

    Topic C: Validate Data Using a Macro

    Topic D: Automate Data Entry Using a Macro

    Topic E: Convert a Macro to VBA

    Lesson 4: Using Advanced Database Management

    Topic A: Link Tables to External Data Sources

    Topic B: Manage a Database

    Topic C: Determine Object Dependency

    Topic D: Document a Database

    Topic E: Analyze the Performance of a Database

    Lesson 5: Distributing and Securing a Database

    Topic A: Splitting a Database for Multiple User Access

    Topic B: Implement Security

    Topic C: Set Passwords

    Topic D: Convert an Access Database to an ACCDE File

    Topic E: Package a Database with a Digital Signature

    Lesson 6: Managing Switchboards

    Topic A: Create a Database Switchboard

    Topic B: Modify a Database Switchboard

    Topic C: Set Startup Options

    ​​​