CHAPTER 17

Adding, Finding, and Querying Data

Add Records to a Table

You build a database by adding records to each table in the database. You add records to a table in Datasheet view, and each new record that you add appears at the end of the table. As your table grows longer, you can use the navigation keys on your keyboard to navigate it. You can press Tab to move from cell to cell, or you can press the keyboard arrow keys. To move backward to a previous cell, press Shift + Tab.

After you enter a record in a database table, you can edit it if necessary. You edit records in a table in Datasheet view.

Add Records to a Table

Snapshot of add records to a table.

001.eps In the Navigation pane, double-click the table to which you want to add a record.

dga.eps Access opens the table, placing the cell pointer in the first cell of the first row.

dgb.eps By default, ...

Get Teach Yourself VISUALLY Microsoft 365 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.