Access Tips

Back to Hints and Tips Index                                             Back to Main Index

Quickly Select New Record

Finding the New Record row entry in Datasheet view can take some effort, especially if the table contains a lot of records.

1. Press Ctrl + (the Control key and the plus key).
   
   Pressing this keystroke combination selects the New Record row at the bottom of the datasheet.

Use the Record Number Control to select a Record

When working in Datasheet view, you can select the Record Number control and enter a number to select that particular record.

1. Open the table in Datasheet view.

2. Press F5.
   
   The record number is highlighted.
   
    

3. Type the record number required.

4. Press Enter.
   
   It moves to the record  in the row of the number entered.

Importing Excel data into an Access table

When importing Excel data into an Access table, you may frequently find that data is missing. You know the worksheet cells contain data, but the data has not been imported in the import process. If you are trying to import formulas instead of the resulting value of the formula, Access will import those worksheet cells as blank data cells.

1. Save the Excel worksheet in a new workbook.

2. Select the range you want to import and press Ctrl C.

3. From the Edit menu select Paste Special.

4. Select the Values option.

5. Click OK.

6. Import the sheet into your Access Table.

Back to Hints and Tips Index                                             Back to Main Index