ACCESS CERTIFICATION EXAM
QUESTIONS WITH 100% CORRECT
ANSWERS!!
1 of 47
Term
It is important to include all fields in a form to ensure the data entry
user can decide for themselves what data to enter.
Give this one a try later!
True AND
Create False
, Don't know?
2 of 47
Term
Which of the following design considerations is a question to
consider when designing a form in Access?
Give this one a try later!
How many records contain salary amounts greater than 70000 or less than
40000 or are just equal to 30000?
Primary key and foreign key
All of these options are correct:
How will the form be used?
Where should the information be placed on the form?
Is the form's purpose clear?
Does the form's appearance and design match the database?
[CourseTitle]
Don't know?
3 of 47
, Term
The lookup wizard allows the user to choose from existing values in a
table/query OR create new values.
Give this one a try later!
AND True
Create False
Don't know?
4 of 47
Term
using the Criteria field in the query design grid, which of the
following syntax is the correct way to add a wildcard to a
parameter?
Give this one a try later!
[Enter LastName] Like [Enter Salary]
All of these options are correct. [CourseTitle]
Don't know?
QUESTIONS WITH 100% CORRECT
ANSWERS!!
1 of 47
Term
It is important to include all fields in a form to ensure the data entry
user can decide for themselves what data to enter.
Give this one a try later!
True AND
Create False
, Don't know?
2 of 47
Term
Which of the following design considerations is a question to
consider when designing a form in Access?
Give this one a try later!
How many records contain salary amounts greater than 70000 or less than
40000 or are just equal to 30000?
Primary key and foreign key
All of these options are correct:
How will the form be used?
Where should the information be placed on the form?
Is the form's purpose clear?
Does the form's appearance and design match the database?
[CourseTitle]
Don't know?
3 of 47
, Term
The lookup wizard allows the user to choose from existing values in a
table/query OR create new values.
Give this one a try later!
AND True
Create False
Don't know?
4 of 47
Term
using the Criteria field in the query design grid, which of the
following syntax is the correct way to add a wildcard to a
parameter?
Give this one a try later!
[Enter LastName] Like [Enter Salary]
All of these options are correct. [CourseTitle]
Don't know?
