How to use Microsoft Access - Entering Data - part 4 of 13 in this educational video from dizzo95.
Tags:Microsoft Access - Entering Data - part 4 of 13,dizzo 95,dizzo95,dr dan izzo,education,entering data,microsoft access,part 4 of 13,software
Grab video code:
We've created our accounts receivable database and our costumers table. Now we’re ready to enter data, the current record indicators tells us which record is selected and the blinking insertion point is in the current field in this case customer ID.
The record is empty so we begin by typing in a customer ID number and when we do the current record indicator changes from a triangle to a pencil. That’s indicating that this selected record is now being edited. Also a new empty record marked with an asterisk is automatically added to the end of the table. We tab to the next field last name and type this costumer’s last name.
Then we tab to the first name field to make our work even easier, access provides a feature called autocorrect, it will automatically correct common misspellings and even some typing errors. Watch what happens when I mistakenly capitalized the first two letters of this name. I tab to the next field and autocorrect fixes the error. In the phone number field we type that in and notice that the sample field that we chose for the phone number is formatted to display the parenthesis and dashes. To move to the empty record we press tab. The pencil icon disappears. This indicates that a record we've added or changed has been saved on disk.
We call this posting the record, access always saves or post modifications to a record automatically. As soon as we move to a different record, now I will type in a few more records and in the next topic were going to show you ways to work with tables.