Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Entering the Data
Chapter 3: Entering the Data
In This Chapter
Entering data on a datasheet
Changing the look of a datasheet
Creating a form for entering data
Finding records in a field or database table
Finding and replacing your data
At last — you can start entering the data. If you set up your database
tables, named the fields, and established relationships between the
tables, you’re ready to go. This short chapter explains how to enter the
data in a database table. It shows you how to enter data on a datasheet or
enter data by way of a form. This chapter also describes how to find missing
records in case one goes astray.
There’s no getting around it: Entering data is truly a tedious activity. But
if you set up the fields well and take advantage of input masks and other
field properties, it isn’t so bad. It’s better than stepping on a shovel blade,
anyway.
The Two Ways to Enter Data
When it comes to entering data in a database table, you can take your pick
between Datasheet view and a form. Figure 3-1 compares and contrasts the
two. Here are the advantages of entering data in Datasheet view:
Many records appear simultaneously.
You can compare data easily between records.
You can sort by column with the commands in the Sort and Filter group
on the Home tab (as discussed in Chapter 4 of this mini-book).
You can scroll up or down to locate records.
Search JabSto ::




Custom Search