IN THIS CHAPTER

Entering data on a datasheet

Changing the look of a datasheet

Creating a form for entering data

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 minibook).
• You can scroll up or down to locate records.

Here are the advantages of entering the data in a form:

• You don’t have to scroll left or right to see all the fields.
• Getting from field to field is easier.
• Fields are clearly labeled so that you always know what to enter.

Entering the Data in Datasheet View

Entering data in Datasheet view is like entering data in a conventional table. As with a table, a datasheet has columns and rows. Records are entered in rows, and each column represents a field. Fans of Datasheet view like being able to look at a dozen records simultaneously. For fans of Datasheet view, these pages explain how to enter data in a datasheet and change a datasheet’s appearance.

Database tables open in Datasheet view when you double-click their names in the Navigation pane. But if you happen to be gazing at a table in Design view, click the View command on the Home tab or the Datasheet View button on the status bar.

Changing the appearance of the datasheet

To make the datasheet a little less cluttered and unwieldy, try experimenting with its appearance. Access offers a few handy shortcuts for doing just that:

• Rearranging columns: To move a column to a different location, click its name at the top of the datasheet and drag it to the left or right.
• Resizing columns: Move the pointer between column names at the top of the datasheet, and when you see the double-headed arrow, click and start dragging. To make a column just large enough to fit its widest entry, move the pointer between column names and double-click when you see the double-headed arrow.
• Changing fonts: The default font for a datasheet is Calibri 11-point, but the Home tab offers commands for changing fonts and font sizes. Look for these commands in the Text Formatting group.
• Changing the look of gridlines: On the Home tab, open the drop-down list on the Gridlines button and choose options to change the number and thickness of gridlines.
• Alternate row colors: On the Home tab, open the drop-down list on the Alternate Row Color button and choose a color for alternating rows on the datasheet.

To experiment all at one time with the many options for changing a datasheet’s appearance, go to the Home tab and click the Text Formatting group button. You see the Datasheet Formatting dialog box, as shown in Figure 3-2. If you want a customized look for all the datasheets you work on, visit the File tab and select Options. Then go to the Datasheet category in the Options dialog box and go to town.

Entering the Data in a Form

Forms like the one shown in Figure 3-3 are very convenient for entering data. The labels tell you exactly what to enter. Personally, I prefer entering data in a form to entering data on a datasheet. On a form, you take it one step — make that one record — at a time. Not looking at a dozen records makes the task of entering data a little easier. These pages explain how to create a form for entering information in a database table. You also get advice for moving around with the Navigation buttons.

Finding a Missing Record

Sometimes data goes astray. You scroll through a datasheet but simply can’t find the item or record you need so badly. For times like those, Access offers the Find command. Use the command to scour a database for errant information.

Open the database table with the data that needs finding. If you know in which field the data is located, click in the field. You can save a little time that way. Then, on the Home tab, click the Find button (or press Ctrl+F). You see the Find and Replace dialog box, as shown in Figure 3-4. Fill in the dialog box as follows:

• Find What: Enter the item you’re looking for. If you’re looking for a null value, enter null in this text box. Enter “” (two double-quotation marks) to find zero-length strings. Table 3-2 describes the wildcard characters you can use in searches.
• Look In: If you clicked in a field before choosing the Find command, Current Field is selected in this box. To search the entire database table, choose Current Document on the drop-down list.
• Match: Choose the option that describes what you know about the item. Choosing the Any Part of Field option can make for a long search. For example, a search for the letters chin finds, among others, China, Ching, and itching — any word with the consecutive letters chin.
• Search: Choose an option — All, Up, or Down — that describes which direction to start searching.
• Match Case: If you know the combination of upper- and lowercase letters you’re after and you enter the combination in the Find What text box, select this check box.
• Search Fields As Formatted: If you’re searching for a field that has been formatted a certain way, select this check box and make sure that the text or numbers you enter in the Find What text box are formatted correctly. For example, if you’re searching for a record with the date July 31, 1958, and you choose the mm/dd/yyyy format, enter the date as 07/31/1958.

Click the Find Next button to conduct the search. The item might be found in more than one location. Keep clicking Find Next (or pressing Alt+F) until you find the item or you die of thirst on the hot sands of the digital desert.

To quickly find the first value of a search term, start typing in the Search box in the form window or in Datasheet view. As soon as you start typing, the cursor moves to the first instance of the data you enter. The search box is located at the bottom of the screen.

Finding and Replacing Data

Finding and replacing data is remarkably similar to finding data. The difference is that you enter data in the Replace With text box as well as the familiar Find What text box and other option boxes. Figure 3-5 shows the Replace tab of the Find and Replace dialog box. Does it look familiar? If it doesn’t, read the preceding topic in this chapter, “Finding a Missing Record.”

To find and replace data, go to the Home tab and click the Replace button (or press Ctrl+H). You see the Replace tab of the Find and Replace dialog box. After you enter the replacement data in the Replace With text box, make sure that Whole Field is selected in the Match drop-down list. Conducting a find-and-replace operation with Any Part of Field or Start of Field selected in the Match drop-down list can have unintended consequences. For example, a search for Brook also finds Brooklyn, Middlebrook, and other words that include brook. Blindly replacing the brook text string with stream produces, for example, Streamlyn and Middlestream.

Unless you’re as confident as a gambler with four aces, don’t click the Replace All button to replace all instances of the text or numbers in the database table or field you’re searching in. Instead, click the Replace button to find and replace text or numbers one instance at a time.

By the way, you can also find and replace data with an update query. Chapter 4 of this minibook covers update queries.