Employee and Organizational Development

Access 2010 Courses

Please be sure that you choose the course that coresponds with the software version you would like to learn. Office 365 software users will not get the most up to date information on new or different features included in the Windows 10/Office 365 update by taking 2010 courses.

 

Access 2010: Overview & Design

4-hour class - Cost: $80
AFE # for DOT- 7796

Prerequisites: Basic computer skills.

Description: Get started with Access! Manage data in existing Access databases and learn the foundations of creating your own.

Objectives:
  • Enter, edit, and delete information in existing data bases
  • Create a database and customize it to meet specific needs
  • Learn how to find, filter, and sort information
Date
Time
City
Location
September 18, 2018
8 am- 12 noon Pierre
December 4, 2018
8 am- 12 noon
Pierre

Register by sending an email to BHR Training Registration with the course title, date, time, location and employee number.

***Pierre Trainings: You will now need to enter Becker Hansen through the main entrance on Broadway for training. You will need to check in at the reception desk before proceeding to the training rooms.

Main Entrance on Broadway Ave: After entering, check in the receptionist's desk, take a right past the receptionist's desk and go through two sets of double doors. The elevator and stairwell are on the right. Go to the basement and take a right.
Room B15: Training Room I
Room B16: Computer Lab
Room B17: Training Room II

 

 

 

Access 2010: Tables

3-hour class - Cost: $80
AFE # for DOT- 7796

Prerequisites: Access 2010: Basic or a basic Microsoft Access skill set.

Description:
Once you have the basics, you're ready to enter your data and sort it!

Objectives:
  • Understand and create tables
  • Create table relationships
  • Print and delete relationships
Date
Time
City
Location
September 18, 2018
1 pm - 5 pm
Pierre
December 4, 2018
1 pm - 5 pm
Pierre

Register by sending an email to BHR Training Registration with the course title, date, time, location and employee number.

 

 

 

Access 2010: Queries 1

3-hour class - Cost: $60
AFE # for DOT- 7797

Prerequisites: Access 2010: Basic or a advanced Microsoft Access skill set.

Description:
You ask for them, you got them. Queries! Get the information you what you want from large databases.

Objectives:
  • Understand different types of queries
  • Create a multiple table query
  • Work with expressions
Date
Time
City
Location
September 19, 2018
9 am -12 noon
Pierre
December 5, 2018
9 am -12 noon
Pierre

Register by sending an email to BHR Training Registration with the course title, date, time, location and employee number.

 

 

 

Access 2010: Queries 2

3-hour class - Cost: $60
AFE # for DOT- 7797

Prerequisites: Access 2010: Queries 1

Description:
You've got the foundations of queries, now learn the magic of making advanced queries.

Objectives:
  • Create crosstab queries
  • Find duplicate and unmatched records
  • Make table queries
Date
Time
City
Location
September 19, 2018
1 pm - 4 pm
Pierre
December 5, 2018
1 pm - 4 pm
Pierre

Register by sending an email to BHR Training Registration with the course title, date, time, location and employee number

 

 

 

Access 2010: Forms

3-hour class - Cost: $60
AFE # for DOT- 7797

Prerequisites: Access 2010: Basic and Tables, or an intermediate Microsoft Access skill set.

Description:
Don't enter forms manually! Work smarter by creating forms that directly connect to your database.

Objectives:
  • Create and use Access forms
  • Form design and layout
  • Work with form properties
  • Create subforms
Date
Time
City
Location
December 11, 2018
9 am to Noon
Pierre

Register by sending an email to BHR Training Registration with the course title, date, time, location and employee number.

 

 

 

Access 2010: Reports

3-hour class - Cost: $60
AFE # for DOT- 7797

Prerequisites: Access 2010: Basic and Tables, or an intermediate Microsoft Access skill set.

Description:
Make custom reports to share your data or put it to use.

Objectives:
  • Create reports
  • Group and sort data
  • Work in layout view
  • Format reports and add graphic elements
Date
Time
City
Location
December 11, 2018
1 pm to 4 pm
Pierre

Register by sending an email to BHR Training Registration with the course title, date, time, location and employee number.