Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)

1
When you need to create a new table from scratch in your database, you go to:
A)Design view.
B)Datasheet view.
C)Lookup view.
D)Table view.
E)Object view.
2
Which of the following must you do before adding a field between existing fields?
A)Enter a field name.
B)Enter a data type.
C)Select a primary key.
D)Insert a new row.
E)Insert a new column.
3
Which of the following is used to enter records into a table?
A)Datasheet view
B)Design view
C)Lookup view
D)Validation view
E)Object View
4
Which of the following contains a unique value for each record?
A)primary key
B)lookup field
C)input mask
D)metadata
E)cell number
5
When you enter a new field in a table, you are limited to:
A)128 characters.
B)24 characters.
C)48 characters.
D)64 characters.
E)Unlimited characters
6
Which of the following properties indicates the way a field displays in a table?
A)Format property
B)Lookup property
C)Required property
D)Caption property
E)Cell property
7
When you set field properties, the available properties vary based on the:
A)Field length.
B)Field target type.
C)Field name.
D)Field data type.
E)List properties.
8
The default size of a Short Text field is
A)255 characters.
B)64 characters.
C)Unlimited characters.
D)96 characters.
E)244 characters.
9
The property which specifies that a user much enter a value in a field is called:
A)Mandatory.
B)Complete.
C)Required.
D)Primary.
E)Limited.
10
The overall descriptions about what the different data fields represent and their formats is called:
A)Details.
B)Validation.
C)Metadata.
D)Summary.
E)Primary data.
11
When you limit entries to a certain range of values or making sure entries match a specified format, you use:
A)Field Validation rules
B)Datacheck
C)Parameters
D)Access rules
E)Navigators
12
How does Access store a "Yes" response for the Yes/No data type?
A)−2
B)−1
C)0
D)1
E)2
13
Which of the following displays the contents of a field and also allows the user to type in a value into that field?
A)Input field
B)Lookup field
C)Text box
D)Input mask
E)Combo box
14
The field in common between two tables is called the:
A)Common denominator.
B)Identifier.
C)Linking field.
D)Foreign key.
E)Memo field.
15
When importing data records from Excel, which of these must be true?
A)The Excel file must have been created by the same user.
B)The Excel file must contain the same number of fields as in the Access file.
C)The first row of the Excel file must contain the same number of fields as in the Access table.
D)The Excel fine must be delimited.
E)The first row of the Excel file must contain the field names from the Access table.





To learn more about the book this website supports, please visit its Information Center.
Copyright (c)2014 McGraw-Hill Education .
Any use is subject to the Terms of Use and Privacy Notice | Report Piracy


Nordell, 1eOnline Learning Center

Home > Access > Chapter 2 > Ch 2: Multiple Choice Quiz