top of page
Top

Microsoft Access Classes

Microsoft Access: Creating Related and Unrelated Tables

3 Hours

  • Understanding databases, tables, fields and records

  • Navigating the database window

  • Moving around a table

  • Editing data

  • Adding records

  • Changing column widths

  • Saving design changes

  • Displaying design view and datasheet view

  • Creating field names

  • Setting data types

  • Entering field descriptions

  • Setting field properties

    • Field size

    • Format

    • Input mask

    • Caption

    • Default value

    • Validation rule

    • Validation text

    • Required

    • Allow zero length

    • Indexed

  • Creating relationships between tables

    • Creating Joins

    • Enforcing referential integrity

Top

Microsoft Access: Fundamentals of Querying Databases

3 Hours

It is highly recommended but not required that you take Microsoft Access: Creating Related and Unrelated Tables, Fields and Their Properties first.

  • Creating queries

    • Working with field lists

    • Placing fields in the grid

    • Removing fields from the grid

    • Sorting in a query

    • Changing display order in a dataset

    • Using the Show row

    • Defining criteria

  • Saving queries

  • Modifying a saved query

  • Creating And queries

  • Creating Or queries

  • Using comparison operators

  • Using keyword operators

  • Using wildcards

  • Showing only top values

  • Using numeric summaries

  • Creating expressions

  • Printing datasets

Top

Microsoft Access: Advanced Querying Techniques and Importing, Exporting, and Linking Data

3 Hours

It is highly recommended you first take Microsoft Access: Fundamentals of Querying Databases.

 

  • Creating parameter queries

  • Finding duplicate records

  • Finding unmatched records

  • Creating crosstab queries

  • Using a form to provide criteria for a query

  • Using Action queries

    • Creating make table queries

    • Creating delete queries

    • Creating append queries

    • Creating update queries

  • Creating union queries

  • Creating Self Joins

  • Importing, Exporting, and Linking Data

Top

Microsoft Access: Creating Forms and Reports

3 Hours

It is recommended but not required that you take Microsoft Access: Creating Related and Unrelated Tables, Fields and their Properties and Microsoft Access: Fundamentals of Querying Databases first.

 

  • Creating forms that display a single record

  • Creating forms and reports in Design View

  • Creating blank forms and reports

  • Creating forms and reports using a wizard

  • Using report sections 

  • Adding fields and controls to forms and reports

  • Aligning and resizing fields and objects 

  • Manipulating controls on a form or report 

  • Concatenating fields and text on forms and reports

  • Sorting and filtering on a form

  • Sorting and grouping on a report 

  • Changing an object’s properties

  • Changing the properties of a form or report

  • Changing the tab order on a form

  • Printing a report definition 

Top

Microsoft Access: Advanced Techniques in Form Creation and Report Writing

3 Hours

It is HIGHLY recommended that you first take Microsoft Access: Creating Forms and Reports.

 

  • Creating a relationship between tables

  • Creating subforms and subreports to display information from related tables 

  • Creating expressions in subforms

  • Displaying expressions from subforms on main forms

  • Adding option buttons, check boxes, and toggle buttons

  • Creating option groups 

  • Creating combo boxes and list boxes

  • Creating tab controls

  • Creating labels

  • Creating a form to generate reports using inputs from users

  • Inserting a chart on a report using classic and modern charts

  • Creating navigation forms

  • Creating multiple item, datasheets, split forms and modal forms

  • Working with subdatasheets

  • Creating switchboards

  • Creating macros

Top

Microsoft Access: Fundamentals of Querying Databases
Microsoft Access: Advanced Querying Techniques
Microsoft Access: Creating Forms and Reports
Microsoft Access: Advanced Techniques in Form Creation and Report Writing
Microsoft Access Outlines Top
bottom of page