• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Q&A

Q1:Would I ever want to configure a field with the AutoNumber format?
A1: Your data might require a unique sequential number for each record, such as an invoice number. Most often, however, Access uses the AutoNumber format for the key field that is added when you don't specify a key field.
Q2:Can I enter data in the Datasheet view?
A2: Certainly. As explained in this and the next hour, the Datasheet view is a handy view for entering simple data and for viewing multiple records of data from a table. The Datasheet view offers a worksheet-like view of your data in a row and column format. The Datasheet view gives you quick access to a table's data.

Remember that a Datasheet view shows only a single table's data. It does not show the entire database because a database often contains multiple tables of data.

Q3:Can a key field contain duplicates?
A3: No. If you have to locate records by field and that field is not unique, you cannot make the field a key. You must decide on another key or let Access add the key field.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint