Microsoft Access 2013 is a software that allows you to store unlimited amounts of data using a multi-table relational database system.  It not only provides a great place to store many types of data but also offers easy ways to modify the data using forms and request specific data using queries and reports.  It is an important software to understand for many BJC jobs that need to store many types of data and report on it on a timely manner.

We offer a full-day Foundations class called Access 2013 Basic Skills that will get you started understanding the basics of building tables, entering data with one or more tables and how to run queries and reports using Access.

When you understand the basics of it’s four main objects: Tables, Queries, Forms and Reports, then attend our 3 half-day Focus classes that focus on specific features.

To sign up for a class, simply logon to the Online Learning Center and type Access Foundation or Access Focus in the Search box.

 microsoft_access_2013_logo-svg

 

CLASS NAME Description Class Manual and File –
click to download file

BILD Access 2013 Foundation:
Basic Skills

Explore the relational database environment including four basic objects that control data: Tables, Queries, Forms and Reports.   Practice building tables and running queries to extract specific data.  Review ways to import data from Excel and export data to Excel. Access 2013 Basic Skills Manual

BILD Access 2013 Focus:
Relationships and Data Properties

Learn about the basics of creating and editing table relationships and how to use the Relationship window feature to see how all tables in your database relate.  Use Data Properties to control data entry and how the data is displayed in a table.

BILD Access 2013 Focus:
Expressions and Queries

Build a type of calculation called Expressions within the different objects in your database including tables, queries, forms and reports.  Explore why and how to use other types of queries such as Make Table, Append, Update, Delete and Parameter Queries.

BILD Access 2013 Focus:
Forms and Macros

Create a variety of forms to make it easier to enter data across multiple tables.  Add descriptive text and graphics to make them more interesting.  Explore how to build macros within forms to perform specific actions such as running query or deleting a record,