Microsoft Access 2013 Training

One of the most efficient and powerful ways of managing large amount of data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools.

Hands-on Instructor Led Training

A hands-on training provides understanding of the database concepts, creating and modifying databases, creating and working with Access tables, relationships, queries, forms, and reports and their various objects using the Microsoft® Office Access™ 2013 relational database application. You will also learn to maintain data consistency, how to customize database components, and how to share Access data with other applications.

Topic:

Day 1

  • Identify the Elements of the Access Interface
  • Identify the Components of a Database
  • Examine the Relational Database Design Process
  • Create a New Database
  • Create a Table Using the Design View
  • Manage Tables
  • Establish Table Relationships
  • Modify Table Data
  • Sort and Filter Records
  • Work with Subdatasheets
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping
  • Create a Form
  • Modify the Design of a Form
  • View and Edit Data Using an Access Form
  • Create a Report
  • Add a Control to a Report
  • Format the Controls in a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print

Day 2

  • Constrain Data Entry Using Field Properties
  • Establish Data Entry Formats for Entering Field Values
  • Create a List of Values for a Field
  • Create Query Joins
  • Join Tables with No Common Fields
  • Relate Data Within a Table
  • Set the Select Query Properties
  • Retrieve Records Based on Input Criteria
  • Create Action Queries
  • Restrict Data Entry in Forms
  • Organize Information with Tab Pages
  • Add a Command Button to a Form
  • Create a Subform
  • Display a Summary of Data in a Form
  • Change the Display of Data Conditionally
  • Organize Report Information
  • Format Reports
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

Day 3

  • Restructure the Data in a Table
  • Create a Junction Table
  • Improve the Table Structure
  • Create SubQueries
  • Create Unmatched and Duplicate Queries
  • Group and Summarize Records Using Criteria
  • Summarize Data Using a Crosstab Query
  • Create a PivotTable and a PivotChart
  • Create a Macro
  • Attach a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Include a Chart in a Report
  • Print Data in Columns
  • Cancel Printing of a Blank Report
  • Publish Reports as PDF
  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

Target Audience
This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

Click here to view the schedule


Online Database Classes

Introduction to Database Development
ed2go
An experienced professional guides you through a structured approach to database design and development.
Learn more »

Introduction to
Oracle

ed2go
Learn how to use the Oracle database management system to plan, organize, and manage your data.
Learn more »

Intermediate
Oracle

ed2go
Learn how write powerful and flexible PL/SQL programs.
Learn more »

Introduction to Microsoft Access 2007
ed2go
Learn how Microsoft’s powerful database can help you store and manage information you’ve collected about your business, home, or community.
Learn more »

Intermediate Microsoft Access 200
ed2go
Expand your Microsoft Access 2007 skills to build better, more user-friendly Access databases.
Learn more »

Introduction to PHP and MySQL
ed2go
Learn how to create dynamic, interactive Web sites using PHP and a MySQL database server.
Learn more »

Intermediate PHP and MySQL
ed2go
Learn how to create a dynamic, interactive online store using advanced PHP techniques and a MySQL database server.
Learn more »

Introduction to
SQL

ed2go
Gain a solid working knowledge of the most powerful and widely used database programming language.
Learn more »

Intermediate
SQL

ed2go
Expand your knowledge of Structured Query Language (SQL), the industry standard database programming language.
Learn more »

Introduction to Crystal Reports 10
ed2go
Make the points you want to make by converting raw database or accounting information into impressive and meaningful reports.
Learn more »

mos The Microsoft Office Specialist (MOS) certifications is worldwide, performance-based certification program that validates the skills individual with respect to Microsoft Office(Word, Excel, PowerPoint, OutLook, Access) and Windows Vista. For more information on Microsoft Office Specialist (MOS) Certification, click here (Frequently Asked Questions). Call 714-505-3475 to schedule for a test or schedule online at http://www.nrclc.com/

For more information, call (714) 505-3475.

Introduction to Access 2010/2013