Access® 2010 Bible

Chapter 6. Working with Datasheet View

IN THIS CHAPTER

• Understanding datasheets

• Looking at the datasheet window

• Opening a datasheet

• Entering new data

• Navigating records

• 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

• Printing records

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 tblContacts and tblProducts to add, change, and delete data, as well as learn about different features available in Datasheet view.

Note

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 columns. Figure 6.1 shows a typical Datasheet view of a table. Each row represents a single ...