- Introduction
- Creating a Custom Database Template
- Using a Custom Database Template
- Planning Tables
- Creating Tables in a Database
- Creating a Table by Entering Data
- Creating an Application Part 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
Working with Table Records
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.
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 a Table
- In the Navigation pane, double-click the table you want to open.
- If you want, click in the 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.
- Press Enter again to find the next instance of the text.
- 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.
- Click the row selectors you want.
- Click the Home tab.
- Click the Delete button, and then click Yes to confirm.