Ch 9 Access Study Guide

Examview

Define the following
  • RDBMS
  • Navigation Pane
  • data redundancy
  • database schema
  • fields
  • records
  • entry
  • AutoNumber
  • Primary Key
  • Table
  • Form

Be able to identify parts of a database table in datasheet view

What should be kept in mind when naming fields?

Be able to identify field types. Examples--text, number, memo, etc.  What is each used for?

Where is data stored?

In which two places (views) can data be entered?

Identify views of a table, views of a form

Identify 3 kinds of forms