IN THIS CHAPTER
Looking at the datasheet window
Opening a datasheet
Entering new data
Changing values in a datasheet
Using the undo feature
Copying and pasting values in a datasheet
Replacing values in a datasheet
Adding records in datasheet
Deleting records in datasheet
Displaying records in a datasheet
Sorting and filtering records
Focusing on special features of datasheets
In 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 chapter, you'll work with
tblProducts to add, change, and delete data, as well as learn about different features available in Datasheet view.
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.
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 columns. Figure 6.1 shows a typical Datasheet view of a table. Each row represents a single ...