Lesson 5: Working with Tables Introduction

Questions and Answers

To navigate between fields, you can use the left and right arrow keys or scroll ______ and right.

left

Entering data into tables in Access is similar to entering data in ______.

Excel

Even when you're using forms, queries, and reports, you're still working with ______ because that's where all of your data is stored.

tables

Access is designed to save records ______.

automatically Signup and view all the answers

Tables are at the heart of any database, so it's important to understand how to use ______.

them Signup and view all the answers

Sometimes when you enter information into a record, a window will pop up to tell you that the information you've entered is ______.

invalid Signup and view all the answers

In this lesson, you will learn how to open ______, create and edit records, and modify the appearance of your table to make it easier to view and work with.

tables Signup and view all the answers

To add a new record: There are three ways to add a new record to a table: ______.

manually Signup and view all the answers

All tables are composed of horizontal rows and vertical columns, with small rectangles called cells in the places where rows and columns ______.

intersect Signup and view all the answers

The Replace All option is powerful, but it may actually change some things you don't want to ______.

change Signup and view all the answers

In Access, rows and columns are referred to as ______ and fields.

records Signup and view all the answers

A field is a way of organizing information by ______.

type Signup and view all the answers

Study Notes

Use the left and right arrow keys or scroll left and right to navigate between fields.
Entering data into tables in Access is similar to entering data in Excel.

Understanding Tables

Tables are at the heart of any database, storing all data, and it's essential to understand how to use them properly.
Access is designed to save records in tables.

Adding Records to Tables

There are three ways to add a new record to a table: (Not specified in the text, but common methods include clicking on the "New" button, clicking on the last row of the table, or using the "Data Entry" form)

Structure of Tables

Tables consist of horizontal rows and vertical columns, with small rectangles called cells at their intersections.
In Access, rows and columns are referred to as records and fields, respectively.
A field is a way of organizing information by categorizing it into distinct categories.

Editing Tables

The Replace All option is powerful, but it may change unintended data, so use with caution.
When entering information, a window may pop up to tell you that the information you've entered is invalid.
In this lesson, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with.