Computer Basics
Windows
Word
Excel

Web
PowerPoint
Access

Jan's Working with Databases

   Tables & Queries

Project Objectives

Tables:

• Design tables
• Set Format for a table field
• Apply and 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 Report, Documenter report, Object Dependencies
• Import/export data and objects
• Link tables
• Repair broken table links

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

Previous    Next