In Access tables are arguably the most important object. Use tables in Access to store all of your data to run queries and reports.
Entering data into tables in Access is similar to entering data in Excel. To work with records, you'll have to enter data into cells. If you need help entering data into records, you may want to review our Cell Basics lesson from our Excel 2010 tutorial.
There are three ways to add a new record to a table:
Occasionally when you enter information into a record, a window will pop up to tell you the information you've entered is invalid. This means the field you're working with has a validation rule, which is a rule about the type of data that can appear in that field. Click OK, then follow the instructions in the pop-up window to re-enter your data.
Be sure to save any unsaved records before closing a table. Access will not prompt you to save them when you close the table.