Try the Access Course for Free!

Add Records to a Table in Datasheet View in Access- Tutorial

/ / Access 2013, Access 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
Add Records to a Table in Datasheet View in Access- Tutorial: A picture of a user adding a new record in datasheet view in Access 2016.

Add Records to a Table in Datasheet View in Access: Overview

            This tutorial shows you how to add records to a table in datasheet view in Access. In datasheet view in Microsoft Access, there is a blank row at the bottom of the table. This row also contains an asterisk (*) in the row selector box at its left end. This is the “New Record” row. When you add records to a table in datasheet view in Access, each new record is added to the bottom of the table in the “New Record” row.

            To add records to a table in datasheet view in Access, click into this row and enter the new record. The asterisk will then change to a picture of a “pencil” as you do this. That lets you know which record you are currently editing. Another new “New Record” row also appears below the row where you are entering data.

            After opening a table in datasheet view, you can quickly move to the “New Record” row. To do this, click the “New Record” button at the right end of the “Record Navigation” button group in the lower left corner of the datasheet view. It is the button with the [►*] face. Your cursor will then automatically enter into that row. You can then enter the new record’s data to add records to a table in datasheet view in Access.

Add Records to a Table in Datasheet View in Access- Tutorial: A picture of a user adding a new record in datasheet view in Access 2016.

Add Records to a Table in Datasheet View in Access- Tutorial: A picture of a user adding a new record in datasheet view in Access 2016.

Add Records to a Table in Datasheet View in Access: Instructions

  1. To add records to a table in datasheet view, open the desired table in datasheet view.
  2. Click the “New Record” button at the right end of the record navigation button group. It is located in the lower left corner of the datasheet view. It is the button with the arrow and asterisk [►*] on its face.
  3. Then enter the information into the fields in the “New Record” row. It is the bottommost row in the datasheet view that displays the asterisk [*] at the left end of the row.
  4. When you have finished entering the new record, you can move down to enter the next new record into the new row that has appeared.
  5. Close the table when you are finished adding records.

Add Records to a Table in Datasheet View in Access: Video Lesson

            The following video lesson, titled “Adding Records in Datasheet View,” shows how to add records to a table in datasheet view in Access. This video is from our complete Access training, titled “Mastering Access Made Easy v.2016-2013.”

TOP
Sale! $49 All-Access 0 Days 4 Hours 46 Minutes 45 Seconds      $199 $49 Entire Library!
See Deal