Entering Data in Access 2003
- Opening and Closing a Table in Datasheet View
- Entering Data in a Table
- Displaying Records
- Creating a New Record
- Selecting an Entry
- Selecting Records and Columns
- Freezing and Unfreezing Columns
- Hiding and Unhiding Columns
- Resizing Columns
- Rearranging Columns
- Editing a Record
- Deleting a Record
- Copying an Entry
- Copying an Entire Record
- Sorting Records in Datasheet View
- Finding Data
- Replacing Data
- Formatting the Datasheet
- Changing the Font
- Checking Spelling
- Previewing and Printing a Table
This chapter is from the book
This chapter is from the book
This chapter is from the book
You create a database and database tables so that you can store your information in a usable format. You might store information about contacts, products, inventory, events, members, invoices, orders, customers, or any other collection of related data. You can set up multiple tables in your database.
In Access, a table is divided into fields, and each field contains one piece of information such as a last name or a price. One completed set of fields is a record. For instance, in a contact database, the name, address, phone, and other entries for one contact is one record.
This part covers how to enter data into a database table, creating the records for your database table. You also learn how to work with the records, edit data, sort records, print data, and so on.
)
Opening and Closing a Table in Datasheet View
)
-
After you've opened the database that contains the table you want to open, click the Tables option in the Objects bar to display the available tables in that database. -
Click the table you want to open. -
Click the Open button in the database window's toolbar. -
The table opens in Datasheet view. If you have entered records in the table, they are visible; if not, the table is blank. -
To close the table window, click its Close button.
)