Working with Databases
Project 3: Tables & Queries

Title: Jan's Illustrated Computer Literacy 101
Did you want: Working with Databases: Access 2007, 2010, 2013, 2016

Project Objectives


  • Design tables
  • Set Format for a table field
  • Apply & use an input mask for a table field
  • Understand the purpose of indexes
  • Use data validation for a table field and for a record
  • Document a table - Relationships, Documenter report, Object Dependencies


  • Create a Select query in Query Design View
  • Use AND and OR criteria in a query
  • Use the Like operator
  • Use totals in a query
  • Concatenate text fields
  • Calculate values
  • Create a parameter query
  • Create a Make-Table query
  • Create an Append query
  • Create a Delete query
  • Create an Update query
  • Create a Crosstab query
  • Document a query - Documenter report, Object Dependencies
  • Compact and repair a database

Where you are:
JegsWorks > Lessons > Databases

Before you start...

Project 1: Intro

Project 2: Access Basics

Project 3: Tables & Queries Arrow: subtopic open
    Designing TablesTo subtopics
    Designing QueriesTo subtopics
    ExercisesTo subtopics

Project 4: Forms & Reports


In this project you will learn more about the properties available for your tables and about the different types of queries. You will also document your tables and queries.

Examples in this project are primarily from LanguageArtsClasses.mdb.