215
CHAPTER
Working with
Datasheet View
IN THIS CHAPTER
Understanding datasheetsLooking at the datasheet
windowOpening a datasheetEntering new dataNavigating recordsChanging values in a datasheetUsing the undo featureCopying and pasting values in
a datasheetReplacing values in a datasheetAdding records in datasheetDeleting records in datasheetDisplaying records in a
datasheetSorting and filtering recordsFocusing on special features of
datasheetsPrinting recordsI
n Chapter 2, you created a database named
MyCollectableMiniCars.accdb to hold the tables, queries, forms,
reports, and macros you’ll create as you learn Access. You also created a
table named tblContacts using the Access table designer.
In this chapter, you’ll use a datasheet to enter data into an Access table and
display the data many different ways. Using Datasheet view allows you to see
many records at once, in the familiar spreadsheet-style format. In this chap-
ter, you’ll work with tblContacts and tblProducts to add, change,
and delete data, as well as learn about different features available in
Datasheet view.
On the CD-ROM
This chapter uses the database named Chapter06.accdb. If you haven’t
already copied it onto your computer from the CD, you’ll need to do so now.
Understanding Datasheets
Using a datasheet is just one of the ways to view data in Access. A datasheet
is similar to a spreadsheet in that it displays data as a series of rows and col-
umns. Figure 6.1 shows a typical Datasheet view of a table. Each row repre-
sents a single record, and each column represents a single field in the table.
Scroll up or down in the datasheet to see the rows (records) that don’t fit on
the screen; scroll left or right to see the columns (fields) that don’t fit.