Chapter 5: Working with Access Tables


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.

Get Access 2013 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.