Access 2016 quiz 2 1) Where can you not use calculated fields? (1 point) a. In a
ID: 3738616 • Letter: A
Question
Access 2016 quiz 2
1)
Where can you not use calculated fields? (1 point)
a. In a table
b. In a report
c. In a module
d. In a form
2)
"lastName" is an example of ________. (1 point)
a. a typing error
b. a naming convention that is not recommended because of possible compatibility issues
c. camel case
d. Pascal case
3)
What field property forces data to follow certain rules of data entry? (1 point)
a. Format
b. Required
c. Validation Text
d. Validation Rule
4)
What is not true about the hyperlink data type? (1 point)
a. It can store the URL for a web page
b. It lists the hyperlink, but you must press the Ctrl key while you click the hyperlink for it to work
c. It can store the path to a folder
d. It can store the path to a file
5)
When you run a query, it displays in what view? (1 point)
a. Print Preview
b. Datasheet
c. Design
d. Layout
6)
When you purchase from a store several times this
would be an example of what kind of table relationship? (1 point)
a. One-to-many (one customer - many purchases)
b. Many-to-many (many items purchased - many times)
c. Many-to-one (many purchases - one customer)
d. One-to-one (one customer - one store)
7)
What field property makes up for the limitation of the field naming rules or common practices? (1 point)
a. Input Mask
b. Caption
c. Validation Rule
d. Format
8)
Which of the following is not a way to create a multitable query? (1 point)
a. Creating a query from scratch
b. Adding a table in the Relationships window
c. Modifying an existing query
d. Using the Query Wizard
9)
What is not critical when you are first designing a database? (1 point)
a. What fields you will need
b. What the field names will be
c. What tables you will need
d. What type of data will be stored in each field
10)
When you import data, where can you not store it? (1 point)
a. New form
b. Linked table
c. New table
d. Existing table
Explanation / Answer
Solution:
1)
c
In a module
2)
camel case
Explanation:
camelCase should have its first char as lower case letter.
3)
Validation rule.
4)
b is false
5)
b Datasheet
6)
a
One to many
since you are one and store is being used many times.
7)
Format
8)
c. Modifying an existing query
9)
b. What the field names will be
10)
d. Existing table
I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)