Access Boot Camp

Course Description

Access Boot Camp Training in Denver & Phoenix

icon_access

Class Price: $1,620

What’s included – a $3,800 value with:

  • Face-to-face, live interactive class
  • Retake – allows you to retake the entire class if you need a refresher within 6 months
  • Lunch & Learn session – choose from different topics to learn something new in the future
  • Hard copy training manual – to take notes and take with you for future reference
  • Just Tips Newsletter subscription – for ongoing monthly tips to help you learn even more!

Do you need to master building and managing databases in a hurry?  Our Boot Camp is an intensive crash course in Access. You will start with the basics, such as navigation and basic forms, and work your way through to the advanced features of the application, such as macros and writing statements in SQL.  You will even finish with a workshop, where you can get instructor feedback on your individual projects.  There will be ample of hands-on activities that allow you to be sure you have mastered each lesson, and our experienced educators will be there to lead you to a thorough understanding of the material. This intensive five-day Access training in Denver & Phoenix will take you from beginner to master of this powerful database application, all in the comfort of one of our state of the art training facilities in Denver and Phoenix.

Training Class Goal

Students who complete this Access Boot Camp will learn to navigate, build, and manage databases.  They will learn to work with forms, fields, records, and queries.  Students will be able to generate reports of their data, and give it visual impact with PivotTables and Charts.  They will understand how to use macros and to write statements in SQL, as well as to integrate internet applications into their databases.  Student will then have workshop time to work on their individual projects with instructor input

PreRequisites

Students should enter this Microsoft Access Boot Camp possessing intermediate computer skills, and have some experience with Microsoft Excel and other Microsoft Office programs.

Topics Covered

  • Design versus Datasheet View
  • Database wizard
  • Creating blank databases
  • Creating tables

Working with Fields

  • Adding fields
  • Identifying primary key fields
  • Adding records
  • Changing table designs
  • Modifying field names
  • Deleting and inserting fields

Records

  • Finding and editing records
  • Sorting and filtering records
  • Setting field properties
  • Input Masks
  • Validation Rules
  • Indexes

Queries

  • Creating Queries
  • Filtering Queries
  • Modifying query results
  • Operations in Queries
  • Using Calculators
  • Average and Count functions
  • Creating forms to enter data
  • Formatting and customizing forms
  • Using forms to find, sort, and filter records
  • Creating reports through the report wizard
  • Field properties

Relational databases

  • Database normalization
  • Table Relationships
  • Referential integrity

Related Tables

  • Creating lookup fields
  • Modifying lookup fields
  • Sub-datasheets

Complex queries

  • Joining tables in a query
  • Using calculated fields
  • Summarizing and grouping values

Advanced form design

  • Adding unbound controls
  • Graphics
  • Adding combo boxes

Reports and printing

  • Customized headers and footers
  • Calculated values
  • Labels
  • Charts in forms and reports
  • Pivot Tables and Pivot Charts

Querying with SQL

  • SQL and Access
  • Writing SQL statements
  • Attaching SQL queries to controls

Advanced Queries

  • Creating parameter queries
  • Using Action queries

Macros

  • Creating, running, and modifying macros
  • Attaching macros to the events of database objects

Advanced Macros

  • Creating macros to provide user interaction
  • Creating macros that require user input
  • Creating the AutoKeys and AutoExec macros
  • Creating macros for data transfer

Importing, Exporting, and Linking

  • Importing objects
  • Exporting objects
  • Interacting with XML documents
  • Linking Access objects
  • Working with Windows SharePoint Services

Database Management

  • Optimizing resources
  • Protecting databases
  • Setting options and properties

Internet Integration

  • Hyperlink fields
  • Working with Outlook
  • Navigation Forms
  • Tabbed Forms
  • Switchboards
  • Splash Screens
  • Read-Only Forms
  • Workshop – Instructor led assistance on individual student databases

Get a database crash course with our Microsoft Access Boot Camp and go from novice to master in just five knowledge-packed days!

Upcoming Classes

SharePoint Boot Camp
Aug 26 - Aug 30 8:00 am - 4:00 pm SharePoint Boot Camp Westminster SharePoint Boot Camp SharePoint Boot Camp Training in Denver & Phoenix Class Price: $2,025 What’s included – a $4,200 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 26-08-2019T08:00 26-08-2019T16:00 Active
26-08-2019 Active 2,025.00 26-08-2019
Register Now
Access Boot Camp
Oct 1 - Oct 4 8:00 am - 4:00 pm Access Boot Camp Phoenix Access Boot Camp Access Boot Camp Training in Denver & Phoenix Class Price: $1,620 What’s included – a $3,800 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 01-10-2019T08:00 01-10-2019T16:00 Active
01-10-2019 Active 1,620.00 01-10-2019
Register Now
Excel Boot Camp
Oct 8 - Oct 10 8:00 am - 4:00 pm Excel Boot Camp Phoenix Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3,130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 08-10-2019T08:00 08-10-2019T16:00 Active
08-10-2019 Active 1,215.00 08-10-2019
Register Now
Access Boot Camp
Oct 14 - Oct 17 8:00 am - 4:00 pm Access Boot Camp Tech Center Access Boot Camp Access Boot Camp Training in Denver & Phoenix Class Price: $1,620 What’s included – a $3,800 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 14-10-2019T08:00 14-10-2019T16:00 Active
14-10-2019 Active 1,620.00 14-10-2019
Register Now
Excel Boot Camp
Nov 11 - Nov 13 8:00 am - 4:00 pm Excel Boot Camp Tech Center Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 11-11-2019T08:00 11-11-2019T16:00 Active
11-11-2019 Active 1,215.00 11-11-2019
Register Now
SharePoint Boot Camp
Jan 13 - Jan 17 8:00 am - 4:00 pm SharePoint Boot Camp Tech Center SharePoint Boot Camp SharePoint Boot Camp Training in Denver & Phoenix Class Price: $2,025 What’s included – a $4,200 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 13-01-2020T08:00 13-01-2020T16:00 Active
13-01-2020 Active 2,025.00 13-01-2020
Register Now
Excel Boot Camp
Feb 10 - Feb 12 8:00 am - 4:00 pm Excel Boot Camp Westminster Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3,130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 10-02-2020T08:00 10-02-2020T16:00 Active
10-02-2020 Active 1,215.00 10-02-2020
Register Now
Access Boot Camp
Mar 9 - Mar 12 8:00 am - 4:00 pm Access Boot Camp Westminster Access Boot Camp Access Boot Camp Training in Denver & Phoenix Class Price: $1,620 What’s included – a $3,800 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 09-03-2020T08:00 09-03-2020T16:00 Active
09-03-2020 Active 1,620.00 09-03-2020
Register Now
Excel Boot Camp
May 4 - May 6 8:00 am - 4:00 pm Excel Boot Camp Tech Center Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 04-05-2020T08:00 04-05-2020T16:00 Active
04-05-2020 Active 1,215.00 04-05-2020
Register Now
SharePoint Boot Camp
Jul 13 - Jul 17 8:00 am - 4:00 pm SharePoint Boot Camp Westminster SharePoint Boot Camp SharePoint Boot Camp Training in Denver & Phoenix Class Price: $2,025 What’s included – a $4,200 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 13-07-2020T08:00 13-07-2020T16:00 Active
13-07-2020 Active 2,025.00 13-07-2020
Register Now
Excel Boot Camp
Aug 11 - Aug 13 8:00 am - 4:00 pm Excel Boot Camp Westminster Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3,130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 11-08-2020T08:00 11-08-2020T16:00 Active
11-08-2020 Active 1,215.00 11-08-2020
Register Now
Access Boot Camp
Sep 21 - Sep 24 8:00 am - 4:00 pm Access Boot Camp Tech Center Access Boot Camp Access Boot Camp Training in Denver & Phoenix Class Price: $1,620 What’s included – a $3,800 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 21-09-2020T08:00 21-09-2020T16:00 Active
21-09-2020 Active 1,620.00 21-09-2020
Register Now
Excel Boot Camp
Nov 16 - Nov 18 8:00 am - 4:00 pm Excel Boot Camp Tech Center Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 16-11-2020T08:00 16-11-2020T16:00 Active
16-11-2020 Active 1,215.00 16-11-2020
Register Now
SharePoint Boot Camp
Nov 30 - Dec 4 8:00 am - 4:00 pm SharePoint Boot Camp Tech Center SharePoint Boot Camp SharePoint Boot Camp Training in Denver & Phoenix Class Price: $2,025 What’s included – a $4,200 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 30-11-2020T08:00 30-11-2020T16:00 Active
30-11-2020 Active 2,025.00 30-11-2020
Register Now
Access Boot Camp Phoenix Oct 1 - Oct 4  8:00 am - 4:00 pm

1,620.00

Attendee 1