About this lesson
Enter a new record into a table and move between fields.
Download this lesson’s related exercise files.Services_02_START.accdb
568 KB Services_02_END.accdb
Enter Data into Tables
A number that gets new values automatically, chosen in the Data Type. AutoNumbers get new values automatically and are numbers normally hidden from users. They are excellent choices to use for Primary Keys.
A column of information in a table. A field has a name, data type, size, and other properties.
A way of looking at data in rows and columns, like a spreadsheet.
An area that enables you to view and manage the objects in your database. Double-click on an object name to open it.
A field (or combination of fields) in a table that has a unique value for every record and is designated as such.
Box to the left of a record where you can click to select a record of information.
Enter New Record to a Table
- To enter a new record to a table, go to the bottom of the table.
Copy Value from Previous Record
- When adding or changing information in a field, to copy the value from above, press (Ctrl-').
Move to Next Field
- Press to move to the next field.
Move to Previous Field
·Press to move back a field
Lesson notes are only available for subscribers.