Working with Microsoft Access Tables

Leave a Comment
Working with Microsoft Access Tables
After you create an Access table, you can modify it, enter data into it manually or import data from somewhere else, such as Excel. This lesson teaches you how to modify a table and enter data.

Enter Records

After you have created a table, you can enter data into it.

To enter data into an AutoNumber field:


·               Press the Tab key. When you make an entry into another field in the record, Access will automatically make an entry into the AutoNumber field.
To enter data into fields that have a lookup list:

1.   Click the down-arrow that appears when you click in the field.
2.   Click to select the entry you want.
3.   Press the Tab key.

To enter data into a Yes/No field:

·     Click the checkbox for Yes; leave the checkbox unchecked for No.
If You Enjoyed This, Take 5 Seconds To Share It

0 comments:

Post a Comment

Enter your comments to JoxTech