- Introduction
- Creating a Custom Database Template
- Planning Tables
- Creating Tables in a Database
- Creating a Table by Entering Data
- Creating a Table Using a Template
- Importing Data into Tables
- Linking to Data in Tables
- Working with Table Records
- Working with a Table in Design View
- Specifying a Primary Key in Design View
- Planning Table Relationships
- Defining Table Relationships
- Creating and Printing a Table Relationship Report
- Ensuring Referential Integrity
- Identifying Object Dependencies
- Modifying Object Dependencies
This chapter is from the book
This chapter is from the book
This chapter is from the book
Working with Table Records
)
AC07S-1.3.1, AC07S-3.1 AC07S-3.2
A database is made up of groups of fields organized into tables. A field is a specific category of information, such as a name or a product. Related fields are grouped in tables. You usually enter data into fields one entity at a time (one customer at a time, one product at a time, and so on). Access stores all the data for a single entity in a record. You can view a table in Datasheet or Design view. Design view allows you to work with your table’s fields. Datasheet view shows a grid of fields and records. The fields appear as columns and the records as rows. The first field in a table is often an AutoNumber field, which Access uses to assign a unique number to each record. You can’t select or change this value. You can use Record buttons at the bottom of the table in Datasheet view to quickly move around and search for data in a table.
Enter a New Record and Move Around in a Table
)
In the Navigation pane, double-click the table you want to open.
Click the New Record button.
Press Tab to accept the AutoNumber entry.
Enter the data. If you make a typing mistake, press Backspace.
Press Tab to move to the next field or Shift+Tab to move to the previous field.
When you reach the end of the record, click one of the Record buttons:
- First Record button.
- Previous Record button.
- Specific Record box. Enter a record number in the box, and then press Enter.
- Next Record button.
- Last Record button.
Search for Records
)
In the Navigation pane, double-click the table you want to open.
If you want, click in the table field where you want to start the search.
Click in the Search box.
Type the text you want to find in the table.
Press Enter to find the first instance of the text you want to find.
Press Enter again to find the next instance of the text you want to find.
When you’re done, delete the text in the Search box.
Delete a Record from a Table
)
In the Navigation pane, double-click the table you want to open.
Right-click the row selector with the record you want to delete.
Click Delete Record, and then click Yes to confirm.