Get Adobe Flash player

 

Telephone Contact

617-699-8260

Microsoft Access

 

 

Getting Started

  • Why use a database?
  • What does a database consist of?
  • Starting Access
  • Opening and closing a database
  • Opening and closing a table
  • Viewing a table
  • Editing and deleting data in a record
  • Adding data in a table
  • Deleting a record from a table
  • Finding data

Basic Query

  • What is a query?
  • Opening and closing a query
  • Designing a query
  • Switching between design and datasheet
  • Creating a query
  • Adding and removing a table from a query
  • Adding or deleting a field in a query
  • Saving a query

Sorting in a Query

  • Sorting data with visible fields
  • Moving the fields in a query
  • Adding all fields in a query
  • Deleting all fields in a query
  • Sorting data with hidden columns
  • Quick sort

Query with Single Criteria

  • Selecting the records in a query
  • What is a value?
  • Clearing a single criteria
  • Using logical criteria
  • Using wildcards in criteria
  • Searching for no value
  • Using criteria with hidden columns
  • Quick filter

Reports

  • Creating a report using a wizard
  • Identifying sections and controls
  • The toolbox/toolbar
  • Selecting controls/sections
  • Changing font/alignment
  • Sizing a control /section

Forms

  • Creating a form using a wizard
  • Identifying sections and controls
  • The toolbox/toolbar
  • Selecting controls/sections
  • Changing font/alignment
  • Using Forms to enter data and filter