Chapter 5: Working with Access Tables
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 a datasheet
Deleting records in a datasheet
Displaying records in a datasheet
Sorting and filtering records
Aggregating data
Printing records
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.
On the Web
This chapter uses the database named Chapter05.accdb. If you haven't already downloaded it from this book's website, 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 visually similar to a spreadsheet in that it displays data as a series of rows and columns. Figure 5.1 shows a typical Datasheet view of a table. Each row represents 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.