Question 1

Which of the following is not an Access table property?

• Allow Zero Length

• Format

• Hyperlink

• Unicode Compression.

Question 2

In an ER diagram, a crow's foot is used

• as a symbol for an entity.

• to establish tuples.

• to model attributes.

• to point toward a child table.

Question 3

SQL is

• nonprocedural and record oriented.

• nonprocedural and table oriented.

• procedural and object oriented.

• procedural and record oriented.

Question 4

Queries can do all of the following except

• display specific records from tables and other queries.

• perform calculations.

• provide parameters at run time.

• run from a table datasheet view.

Question 5

Relational table and relationship have different meanings; the difference is

• relationships focus on query filters, whereas relational tables focus on filters only.

• that there really is no difference.

• a relational table defines a logical association between two relationships.

• relational table is a two-dimensional structure, whereas the relationship defines an association between the tables.

Question 6

A text data type has a maximum character size of

• 50.

• 200.

• 255.

• Limited only by memory

Question 7

All of the following are true about a property except

• a datasheet view is used to display properties.

• referenced as an attribute.

• changes can be made with a property sheet.

• tables, forms, queries, and reports can have properties.

Question 8

All of the following make good candidates for a field on an employee table except

• Employee ID.

• Hire date.

• Last name.

• Name.

Question 9

To ensure that a value of 15 or greater was entered into a field, you would use a

• field size.

• field type.

• Sarbanes-Oxley Act.

• validation rule.

Question 10

What is the special character called to represent one or more characters in the criteria area of a query?

• Delimiter

• Operand

• Wildcard

• Operator