Reference no: EM13773311

Question 1.1. Entity attributes are represented as
fields.
files.
records.

tables.

Question 2.2. To locate a blank field, your criterion in a query would be
blank.
empty.
null.

void.

Question 3.3. In Access, query results are displayed in which view?
datasheet.
form.
recordset.

report.

Question 4.4. Access has __________ data types.
six
eight
10

12

Question 5.5.  All of the following describe a many-to-many relationship in Access EXCEPT
a junction table is used.
many matching records are found in each direction between tables.
may be used to connect to Oracle and other databases.

there must be at least four tables.

Question 6.6. The term cardinality refers to
a count of the total records in a table.
a field which is a candidate for a primary key.
the number of records in a relationship.

the most important field in a table.

Question 7.7.  Validation the
changes the way text data is formatted.
determines the maximum length of a text field.
requires text data to be inputted correctly.

specifies the error message when a rule is violated.

Question 8.8.  You can add records through the
DataSheet View of a table.
Design View of a table.
Report View.

All of the above

Question 9.9.  An action query is
a select query used to warn users of database changes.
always initiated by a user.
an aggregate query used to summarize field data.

used to add, edit, or delete data in a database.

Question 10.10. Which of the following is true about a crosstab query?
It is an action query.
It is used to retrieve parameter data.
It summarizes a data source into rows and columns with aggregate data displayed at the intersection of the rows and columns.
It summarizes unmatched records from a data source.