Chapter 5Working 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 to a datasheet
- Deleting records from 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.
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.