O'Reilly logo

Access™ 2007 Bible by Gavin Powell, Joseph C. Stockman, Jennifer Reardon, Michael R. Groh, Michael R. Irwin, Cary N. Prague

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. Working with Datasheet View

IN THIS CHAPTER

  • Displaying a datasheet

  • Moving within a datasheet

  • Opening a new datasheet

  • Using special data-entry techniques

  • Finding and replacing values

  • Hiding, freezing, and rearranging datasheet columns

  • Sorting or filtering records in a datasheet

  • Saving and printing datasheets

In Chapter 2, you created a database named My Access Auto Auctions 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 2007 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 a the common 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 machine 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 because it displays data as a series of rows and columns. Figure 6-1 shows a typical Datasheet View of data. 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; ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required