Question

CO 4) In terms of data types and their uses, which one of the following is NOT correct?

The TEXT data type can be used for Last Name.

The Date/Time data type can be used for 10/31/2012.

The Currency data type can be used for Account balance.

The AutoNumber data type can be used for Customer Name.

Flag this Question

Question 125 pts

(CO 5) All of the following describe form usage except

a form user should have less input errors than a table user.

a form can show data from only one table.

forms restrict data entry to one record at a time.

you can create Access forms to match paper forms.

Flag this Question

Question 135 pts

(CO 5) Clicking on the form tool will open a(n)

existing form.

new form in design view.

new form in layout view.

wizard to design a form.

Flag this Question

Question 145 pts

(CO 6) Which of the following describes a poor design consideration for a form?

Arrange controls closely together or in a sequence that is easy to read by the user with consistent formatting.

Each form should have a different theme.

Make labels descriptive and clear.

Right-align labels followed by a colon and left-align bound controls.

Flag this Question

Question 155 pts

(CO 6) Data aggregate functions

are used to perform calculations on individual records in a table or query.

cannot be used on a row.

perform calculations on entire columns of data.

return multiple values.

Flag this Question

Question 165 pts

(CO 9) First normal form can be identified by

a row of a table holds data that pertains to one and only one instance.

all the entries in a column must be the same data type.

the order of rows does not matter.

All of the above

Flag this Question

Question 175 pts

(CO 2) When entering data into a field, which of the following would be the best recommendation?

Entries can be made by multiple people, in whatever way they want.

Entries should be consistent and uniform.

Entries should not be consistent.

Entries can vary.

Flag this Question

Question 185 pts

(CO 8) All of the following describe how a Navigation Form is used except

click the create tab and then navigation in the forms group to create a navigation form.

is another term for a specific report.

helps users open forms and reports.

has the look and feel of a web form.

Flag this Question

Question 195 pts

(CO 9) To secure an Access database, all of the following should be done except

digitally sign a database and open it in a trusted location.

require a password to open a database.

run the table analyzing wizard and performance analyzer.

save a database with the .accde file extension.

Flag this Question

Question 205 pts

(CO 9) All of the following describe a digital signature certification authority except

a certification authority company provides a digital signature when a high level of security is needed to protect the contents of a database.

a certification authority is a commercial company that is highly regulated in most countries.

a fee is charged for the service of issuing and validating identities using a digital signature.

certification authority companies establish their own rules and regulations that users must follow.

Flag this Question

Question 215 pts

(CO 10) The table analyzer tool does this for your database.

Will not improve the database

Make suggestions to create another report

Make suggestions to minimize duplication of data

Make suggestions to create another query

Flag this Question

Question 225 pts

(CO 4) The term cascading refers to

data changes travel from one table to another.

data is put in sequential order.

queries can retrieve data at a faster rate.

records are arranged in order.

Answer 1

As per the expert guidelines we have to answer only the first question.

1) Correct answer is option d)The Auto Number data type can be used for Customer Name.

Auto number is a data function used to generate automatically incremented numeric counter and in terms of data types and their uses the auto number is not correct. Customer name contains alphabets, while auto number is for numeric value