• Skip to main content
  • Skip to primary sidebar

Tux Tech

Leading IT Tutorials Platform

Entering and Editing the Data in Tables in MS Access 2007

MS Access 2007 databases holds all the actual data records inside the tables. You can easily add, edit and delete all the records from these tables. In this tutorial you will learn how can you add new records aand edit the existing records by using commands like copy and paste. You can also learn about Applying the Styles and Themes in MS Word 2007.

Adding and Editing the Data in Tables:

Adding Records to Tables:

When you enter the records into your table you are actually populating the database. In MS Access 2007 you can perform this in very different ways.

Adding Records in the New Record Row:

  • 1st of all click the record row with the asterisk that appears at the bottom of the table.
  • Now type the data into the appropriate fields.
  • Now hit the Enter or the Tab key to move to the next field.

Adding Records with the New Record Navigation Button:

  • Click on the New Record button in the navigation bar.
  • The navigation bar is located in the bottom left corner of the open pbject pane.
  • Now you are required to type the data into the appropriate fields.
  • Now you need to press Enter or the Tab key to move to the next field.

Adding Records with the New Record Command:

  • 1st of all you are required to click on New Record command in the Records group in the Ribbon.
  • Now type in the data into the appropriate fields.
  • Now you need to press the Enter button or the Tab key in order to move to the next field.

Editing Records in Tables

Editing the Record Directly:

  • 1st of all you need to scroll through the records or use the navigation buttons on the navigation bar to find the record to edit.
  • Now click the cell containing the information that must be edited.
  • A Pencil icon appears to indicate edit mode.
  • Now you need to type in the new information into the field.
  • Now click the outside of the record row to apply the change.

Editing the Record using Find and Replace command:

  • 1st of all click the Find command in the Find group on the Ribbon.
  • The Find and Replace dialog box opens.
  • Now tell Access what to find by typing it into the Find What: area.
  • Now type the replace term in the Replace With: area.
  • Now tell Access where to look with the Look In: drop down list. The first choice in the drop-down list is the field you were the last in within the table.
  • Now tell Access what to Match: Any part of the field, whole field or just the start of the field.
  • In the next step tell Access how to Search: Up finds records above the cursor, All searches all records.
  • Now click one of the action options Find Next, Replace or Cancel.

Copy and Paste a Record:

  • 1st of all select the record which you want to copy.
  • Right click and then select Copy.
  • Now select the New record row.
  • Right click and select Paste.

Primary Sidebar

  • How To Guides
  • Privacy Policy
  • Terms of Service

Recent Posts

  • Working with Pictures in MS Publisher 2010
  • Working with Shapes and Objects in Publisher 2010
  • Text Basics in MS PowerPoint 2013
  • Worksheet Basics in MS Excel 2013
  • Entering and Editing the Data in Tables in MS Access 2007
  • Applying the Styles and Themes in MS Word 2007
  • Exploring Charts in MS Excel 2007

© Copyright 2017 All Rights Reserved ·