Access Boot Camp

Course Description

Microsoft Access Crash Course

icon_accessThis class covers all concepts in Microsoft Access and teaches foundational skills for building a database through advanced techniques for editing and maintaining a robust database.

Class Price: $1,650

Training Class Goal

Students will come from this class feeling confident in designing an Access database, and making changes to an existing one while using all of the database components including tables, queries, forms and reports.

PreRequisites

Intermediate computer skills and experience with Microsoft Excel and other Microsoft Office programs.

Topics Covered

  • Design vs. 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

 

Upcoming Classes

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
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
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
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

Bookings are closed for this class.

Live & In-Person

All of the classes on this page are taught by live instructors who are present in the classroom.