Computer and Business Skills training

Sign Up
888.815.0604
Home / Access / Level 1

Microsoft Access Fundamentals Course


Course Description

This hands-on beginners course is suitable for new users of Access 2010/2013/2016.


Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run.

After this class you will have a very good working knowledge of Microsoft access, including how to design and build an efficient relational database, construct data fields and tables, run queries, design forms and build reports.

View our full range of Microsoft Access training courses, or see below for the detailed outline for Access Level 1.


2 Days | $895.00


Register button

Detailed course outline

  • Database Fundamentals
    • Understanding general database terms
    • Database management systems
    • Table Overview
    • Data types
    • Table metadata
    • Queries and SQL
    • SQL Statements
    • Relational databases
    • Flat file databases
    • NoSQL databases
    • Advantages of relational databases
    • Access interface and objects
    • New databases
    • Existing databases
    • The navigation Pane
    • Access objects: Tables, Queries, Forms and Reports
  • Database Design
    • Fundamentals of efficient design
    • Modeling
    • The logical model
    • The physical model
    • Normal forms
    • Creating and Modifying databases
    • Choosing data types: Numeric, String, Other
    • Constraints
    • Changing table structure
    • Changing data types
    • Adding and deleting fields
    • Relationships and Keys
  • Tables
    • Creating a simple table
    • Creating tables in Design View
    • Creating fields
    • Creating fields in Datasheet view
    • Creating fields in Table Design view
    • Setting a Primary Field
    • Data Validation using Field Properties
    • Setting validation rules
    • Setting table-level validation
    • Relationships and keys
    • The importance of primary keys and indexes
    • Deciding whether you need unique indexes
    • Creating relationships
  • Queries
    • Creating basic queries
    • Select queries
    • Action queries
    • Adding data sources to a query
    • Selecting query fields
    • Query criteria
    • Adding mutiple criteria conditions
    • Parameter queries
    • Total queries
    • Cross tab queries
    • Append queries
    • Update queries
    • Delete queries
    • Modifying queries
    • Sorting query results
    • Query field formatting
    • Using calculated fields
    • Creating calculated Yes/No fields
    • Calculated text fields
  • Forms
    • Creating simple forms
    • Basic form design options
    • Bound and unbound form controls
    • Using the Form Wizard
    • Form Design
    • Displaying form properties
    • Form sections
    • Form controls
    • Adding bound controls to a form
    • Adding controls form the field list
    • Types of controls
    • Test box and label controls
    • List controls
    • Adding a command button
    • Changing the layout of controls
  • Reports
    • Creating Reports
    • Report basics
    • Setting up data sources
    • Filtering and ordering reports
    • Automatic report generators
    • Using the Report Wizard
    • Report Controls
    • Calculated fields
    • Grouping and summarizing
    • Formatting Reports
    • Report Page Setup options
    • Images and other objects
    • Themes

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.

Timetable

Chicago

230 W Monroe St
#610
Chicago
IL 60606View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.

Other Cities

Request onsite training quote

Los Angeles

915 Wilshire Blvd
#1800
Los Angeles
CA 90017View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.

Related courses

Why train with us?Need Group training quotation?Fresh Starbucks brewed every dayBook two levels of Access training and save $100 FREE Class Repeat with each courseBook 3 Level of Access Training and save $150