Working with Databases
Project 3: Tables & Queries

 Title: Jan's Illustrated Computer Literacy 101

Lesson Objectives

Tables:

  • 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

Queries:

  • 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
    Summary
    Quiz
    ExercisesTo subtopics

Project 4: Forms & Reports

Search  
Glossary  
Appendix

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.