Access: Working with Tables

Front

What are the four types of database objects in Access?

Back

Tables, forms, queries, and reports.

Front

Why are tables important in Access?

Back

Tables are where all data is stored, making them the heart of any database.

Front

How do you open an existing table in Access?

Back

Open your database, locate the Navigation pane, find the table, and double-click it.

Front

What are rows and columns called in Access tables?

Back

Rows are called records and columns are called fields.

Front

What is a field in Access?

Back

A field is a way of organizing information by type, with each field containing one type of data.

Front

What is a record in Access?

Back

A record is a unit of data that includes every piece of information in a given row.

Front

How can you navigate through records in a table?

Back

Use the up and down arrow keys, scroll, or use the Record Navigation bar.

Front

How do you add a new record to a table?

Back

Use the New command in the Records group, click the New record button, or type in the row below the last record.

Front

What happens if you enter invalid data into a record?

Back

A window will pop up indicating the data is invalid due to a validation rule.

Front

How do you save a record in Access?

Back

Access saves records automatically, but you can manually save by selecting a different record or closing the object.