Let Me Try 5-3: Indexing a Field and Adding Data

In this task, you’ll add an index to a field and add data in the Access database.

Steps Instructions Results / Comments
1.

Download and open the database titled LMT 5-3.accdb from the Student Files / Module 5 folder and save it to your personal folder.

Note: Double-click the tbltrip table in the event that you see a blank screen.

The database opens in Datasheet View.

LMT6-2-2
2. Click Design View.

The Design View is seen.

LMT6-2-3
3.

Take a look at the Primary Key to the left of the record.

LMT6-2-03
4.

Note that in Field Properties, for the Indexed property, the option is set to Yes (No Duplicates).

Let Me Try 6-3: Indexing a Field and Adding Data
5. Click Datasheet View again.

The Datasheet View of the database is seen.

LMT6-2-5
6.

Click Click to Add and select Short Text.

LMT6-2-06

A column gets added with the title Field1.

LMT6-2-6
7.

Type TripName and click the next cell.

The TripName field is added.

LMT6-2-7
8.

Switch back to Design View.

The database opens in Design View.

LMT6-2-8
9.

Click the Description box of the TripName and type Short name for this trip in the highlighted cell.

m6-new100

The text appears under the Description column.

m6-new101
10.

Highlight the TripName field by selecting the row.

LMT6-2-09

The field is highlighted and field properties are displayed.

LMT6-2-09
11.

Click the Required drop-down arrow in Field Properties and select Yes from the drop-down list.

The Required property is set.

Let Me Try 6-3: Indexing a Field and Adding Data
12.

Click the Allow Zero Length drop-down arrow and set it to No.

The Allow Zero Length property is set.

Let Me Try 6-3: Indexing a Field and Adding Data
13.

Check if Indexed is set to No. If not, set the property.

The Indexed property is set.

Let Me Try 6-3: Indexing a Field and Adding Data
14.

Click the Datasheet View button on the Status Bar.

A dialog box for saving the table appears.

Let Me Try 6-3: Indexing a Field and Adding Data
15. Click Yes to save the table.

The Datasheet View opens.
16.

Note the star symbol next to the (New) record. Click the Code field cell and type LEX.

Let Me Try 6-3: Indexing a Field and Adding Data

The pen icon appears to the left of the record to indicate the record is being worked on.

Let Me Try 6-3: Indexing a Field and Adding Data
17.

Click the TripName cell and type Louisiana Explorer.

The text appears in the TripName field.

Note: It is likely that your ID number will be 1 as this is a new table.

Let Me Try 6-3: Indexing a Field and Adding Data
18.

Adjust the column width by dragging the column pointer to the right to accommodate all the text.

The full name is displayed in the cell.

Let Me Try 6-3: Indexing a Field and Adding Data
19. Save the database and close Access. The database closes.