Chapter 5Working with Access Tables


  1. Understanding datasheets
  2. Looking at the Datasheet window
  3. Opening a datasheet
  4. Entering new data
  5. Navigating records
  6. Changing values in a datasheet
  7. Using the Undo feature
  8. Copying and pasting values in a datasheet
  9. Replacing values in a datasheet
  10. Adding records to a datasheet
  11. Deleting records from a datasheet
  12. Displaying records in a datasheet
  13. Sorting and filtering records
  14. Aggregating data
  15. 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.

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 ...

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

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