Reference no: EM132301557
1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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
7. 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.
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.
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.
10. 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.
11. 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
12. 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.