MS Access 2010: Introduction

Introduction

In this course, you will become familiar with the basics of using the Microsoft Access program. You will learn how to use and design tables and create various types of queries over them for purposes of an effective information retrieval.

Lessons

  • Introduction to databases
  • The Microsoft Access environment
  • Table creation in datasheet view
  • Table design view
  • Special field types
  • Work within extensive tables
  • Looking up and editing data
  • Data sorting and filtering
  • Designing databases
  • Field selection and data sorting via queries
  • Work with criteria for select queries
  • Calculated items
  • Analysis of table relations
  • Relationships and referential integrity
  • Linked tables in queries
  • Relation features
  • Lookup column
  • Queries with parameters
  • Functions and formula creator