Enter a New Record or Field Into Your Access Database

There are two ways to enter new records into your Access training database. The best way is to enter data using the ready-made form labeled "...Training Record", which is located on the left side of your screen on the navigation pane. Data entered into your form is automatically updated in your tables and queries, so your form is where all of the data entry and editing of data takes place. The other way to enter new records is to go into the table holding the primary key for the data and enter it there. A table with a primary key will have a "key" icon next to the first field in the table. See the video below to enter data directly into a table. Users with little or no experience should not attempt to alter data via a table, but should enter and edit data using the ready-made form provided in the database and follow the instructions provided on this site.

Also see the video below to learn how to add a new field (column) to your database. Once you start using the databases downloaded from this site, you may decide that you need more criteria for entering data.