1 . When creating a new table, Access creates the first field and names it _____
ID: 3801395 • Letter: 1
Question
1. When creating a new table, Access creates the first field and names it ________ which Access assigns a unique sequential number.
A) ID
B) OBJECT
C) ITEM
D) VALUE
2. When considering to use the Currency data type, a user should understand that they can store data with one to ________ decimal places. A) two B) four C) six D) ten
3. Database designers typically do not add spaces in field names (LName), but can add details in the ________ field of the field properties to provide additional context to the field that is not displayed (Last Name).
A) caption
B) details
C) format
D) index
Explanation / Answer
Answers...
(1). When creating a new table, Access creates the first field and names it ID which Access assigns a unique sequential number.
When you are in design view of the software Microsoft® Access, the first entry of the column or you can say a field is generated as ID, and its datatype assigned is AUTONUMBER so that it increases in the sequential number.
(2). When considering to use the Currency data type, a user should understand that they can store data with one to 4 decimal places.
The format allowed you can remember as 15.4 which means 15 digits as a whole number and along with that 4 digits after the decimal places.
(3). Database designers typically do not add spaces in field names (LName), but can add details in the caption field of the field properties to provide additional context to the field that is not displayed (Last Name).
You generally do not add the space in the field name, you also have description option along with field name and data type which specifies what this field is for but if you want to specify something more for the field name , when you click on a particular field. in the bottom left side of the design view, you get a window saying Field Properties. This question is about this portion. In these properties, there is an option called caption which lets you specify the additional information about that field.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.