Friday, 5 July 2013

Add and Delete Records in Access



Add and Delete Records in Access

From time to time you need to update the information stored in a database. Remember, while entering data, be careful to enter data specific to the data type of each field, i.e., in a number field, you can't enter text and in a date/time field, you must enter the date in the valid mm/dd/yy format.
Contents
  1. Add records to a blank database
  2. Delete Records
  3. Add a Record to an existing database

Add records to a blank database

  1. Open your database
  2. Make sure you're in Datasheet view. If not, cllick the view button in the toolbar to switch to datasheet view.
  3. Place insertion point in the first cell.
  4. Enter your information, press tab to go to the next field.
  5. Continue inputting your information in the appropriate fields.

Delete Records

  1. Select a record. Note : Place your pointer to the left of the recod and click the mouse. The recod selector will appear and the record will be highlighted.
  2. From the Edit menu, choose Delete Record.

Add a Record to an existing database

  1. Place your cursor in the first cell of the row with an * or Click the new record icon in the status bar.

0 comments:

Post a Comment