Question : (TCO 1) A collection of customer information and purchase
transactions that might be stored in both Access and Excel would be
Student Answer: Field
2. Question : (TCO1) Which statement is NOT true?
Student Answer: A relationship is a connection between two tables using a common field.
A primary key is used to identify uniquely each field in a table.
Multiple users on different computers can work on a database simultaneously.
Access speed measures the time it takes for a storage device to make the file content available for use.
3. Question : (TCO 1) To create a filtered list on a particular field in a record
Student Answer: click on the Home tab, Advanced Filter, and then Filter By Form.
click on the Home tab, Filter, and then the Find option.
click on the Home tab, Selection, and then pick your criteria.
right click on an item in your Field column and then click Sort.
4. Question : (TCO 1) To locate the tool to compact an Access database, click on the
Student Answer: File tab, Options, Current Database, and select Compact and Repair Database Tools.
Home tab, Advanced, and select Compact and Repair Database Tools.
Database Tools tab, and select Compact and Repair Database Tools.
External Data tab, and select Compact and Repair Database Tools.
5. Question : (TCO 1) Field names can be created or modified in which view?
Student Answer: Datasheet
6. Question : (TCO 2) In using a web search engine, typing the web
site address in the proper place in the brower and then hitting enter is
Student Answer: server setup.
7. Question : (TCO 2) How many data types does Access recognize?
Student Answer: 5
8. Question : (TCO 1) To display a subset of records based on certain criteria, use which of the following?
Student Answer: Filter
1. Question : (TCO 2) To create a relationship between two tables, you need at least a
Student Answer: data type.
2. Question : (TCO 2) Which of the following does NOT describe a many-to-many relationship?
Student Answer: There must be at least two tables.
Many matching records exist in each direction between the tables.
A junction table is used.
You can connect to tables in other databases such as Oracle.
3. Question : (TCO 2) Primary keys can be created
Student Answer: as computer-generated fields.
from an existing single field.
from several existing fields.
All of the above
4. Question : (TCO 3) A relational table includes the following conditions EXCEPT
Student Answer: column entries and attributes must be the same data type.
rows must be in order.
cells contain a single data value.
columns or attributes have a well defined range of values.
5. Question : (TCO 3) Which of the following is true regarding the use of delimiters in a field criterion in Access?
Student Answer: Date/Time data types need no delimiters.
Date/Time data types need to be enclosed in single quotes.
Number data types require no delimiters.
Text data types require pound signs.
6. Question : (TCO 3) The field property that ensures that the field is not empty is
Student Answer: Format.
7. Question : (TCO 3) All of the following are true about a property EXCEPT
Student Answer: 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.
8. Question : (TCO 4) Which of the following is NOT an example of a primary key?
Student Answer: ISBN number for a textbook
Social Security Number
9. Question : (TCO 4) To ensure that a value of 15 or greater was entered into a field, you would use a
Student Answer: field size.
10. Question : (TCO 2) Which of the following is a property that
determines how much physical storage the field requires in the database?
Student Answer: Caption
1. Question : (TCO 2) Which of the following is an example of an entity in a business?
Student Answer: Company
2. Question : (TCO 2) Physical design refers to
Student Answer: developing a database model that will support company operations.
purchasing your hardware components.
selecting the specific hardware characteristics based on data storage and data access requirements.
the process of converting your ERD into tables and defining your rows and columns based your entities and attributes.
3. Question : (TCO 3) All of the following explain index usage EXCEPT
Student Answer: a primary field uses an index.
adding an index to a table might decrease overall database performance slightly.
an index can reduce the amount of time it takes for Access to run queries and reports.
indexes are created using the Index property type.
4. Question : (TCO 2) A crow’s foot
Student Answer: is a Boolean field.
is used to describe attributes.
points to the child table.
points to the parent table.
5. Question : (TCO 2) The term cardinality refers to
Student Answer: 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.
6. Question : (TCO 2) A primary key
Student Answer: can be computer
consists of one field only that uniquely identifies each record in a table.
is a relationship between two or more tables.
All of the above.
7. Question : (TCO 3) Which does NOT apply to the following relationship image?
Student Answer: A one-to-many relationship is shown between Orders and Order Details.
The display is showing the Design View of relationships.
Order Details has a composite primary key.
Within the Orders Details table, the ProductID field will contain unique values only.
8. Question : (TCO 4) What Access data type would you use to store $23.58?
Student Answer: Calculated
9. Question : (TCO 4) You can reserve space for a field using the
Student Answer: PNPI regulations.
field size property.
10. Question : (TCO 4) Which question is part of a requirements analysis?
Student Answer: What is the organization’s structure and core business?
What are the existing problems with the current database?
Will the database interface with other systems?
All of the above.
1. Question : (TCO 1) Entity attributes are represented as
Student Answer: fields.
2. Question : (TCO 2) All of the following are Access data types EXCEPT
Student Answer: autonumber.
3. Question : (TCO 2) In Access, query results are displayed in which view?
Student Answer: datasheet.
4. Question : (TCO 2) Which of the following is a naming convention for field names?
Student Answer: autonumber
5. Question : (TCO 2) The command language used with relational databases is
Student Answer: PNPI.
6. Question : (TCO 2) Another term for an expression is
Student Answer: formula.
7. Question : (TCO 2) Validation text
Student Answer: 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.
8. Question : (TCO 2) Which of the following is NOT true of a birth date field?
Student Answer: A process date is considered a constant.
A process date would be defined as a date/time field.
A process date would be defined as a calculated field.
Date arithmetic can be applied to a process date field.
9. Question : (TCO 6) An action query is
Student Answer: 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.
10. Question : (TCO 6) All of the following are true about a delete query EXCEPT
Student Answer: A delete query is an action query.
Access will display a warning message before running the delete query.
It can be created by clicking the Create tab, Query Wizard, and then select Delete Query.
It selects records from a table and then removes them from the table.
1. Question : (TCO 2) The process of checking the reliability of data is called
Student Answer: data validation.
2. Question : (TCO 2) Validation text is
Student Answer: an error message that provides instruction on what to fix when an incorrect value is entered into a field.
a list of predefined values that can be entered in a field.
a comparison of values entered in two fields.
a field that requires a value of characters or text only.
3. Question : (TCO 2) A logical data validation method is a(n)
Student Answer: birth date field that cannot exceed a hire date.
entered number less than 100 will not display.
field left blank will display with a default of zero.
social security number entered as 111223333 is displayed as 111-22-3333.
4. Question : (TCO 2) To reduce problems that may occur in generating queries and reports, you could place lookup values into a
Student Answer: data type.
5. Question : (TCO 2) An input mask placed on a form will apply to
Student Answer: all forms based on that table.
all forms in the database.
all forms based on that table and the table itself.
that specific form only.
6. Question : (TCO 5) All of the following are performed in the design view of a form EXCEPT
Student Answer: adding pictures, lines, calculations, and controls.
changing the size of the form sections.
entering a data value.
modifying the properties of a form.
7. Question : (TCO 5) A bound control
Student Answer: is a textbox that is connected to a field in a query or a table.
contains a formula that displays the result.
is used to display aggregate information.
uses a macro to process field information.
8. Question : (TCO 5) All of the following are form creation tools EXCEPT
Student Answer: blank form.
9. Question : (TCO 5) Aggregate reports
Student Answer: are most effective when run again on one table.
are useful for detecting data entry errors.
can performing complex “what if” analyses.
require a macro in order to be effective.
10. Question : (TCO 5) A data macro
Student Answer: executes a series of actions when a table event occurs or whenever a named macro is executed.
identifies fields to compare.
is a switchboard.
is a table event.
1. Question : (TCO 1) The easiest way to create a rep
ort is to use the following report tool.
Student Answer: Blank Report
2. Question : (TCO 1) All of the following are report sections EXCEPT
Student Answer: detail.
3. Question : (TCO 1) A detail line
Student Answer: prints more detailed information on one record only.
provides additional field information on a record.
repeats for each record in the record source.
All of the above
4. Question : (TCO 1) A tabular layout resembles a
Student Answer: form that you fill out.
group of index cards.
All of the above
5. Question : (TCO 1) Grouping data in a report will
Student Answer: provide grand totals for your report.
let you organize and summarize your data.
make a report more attractive.
allow you to edit data in a record.
6. Question : (TCO 1) Column headings in a report are based on
Student Answer: the captions used in the source table or query.
the text controls you place in a report.
7. Question : (TCO 7) In addition to the detail field, the primary drop zone in a PivotTable design grid is the
Student Answer: column field.
All of the above
8. Question : (TCO 7) Data mining refers to
Student Answer: analyzing volumes of data to identify trends and patterns.
conducting what if analyses.
analyzing minute differences in field data.
the least squares regression technique to forecast data trends.
9. Question : (TCO 7) A scatter chart is used to display
Student Answer: continuous data.
percentages of a whole.
vertically stacked data.
10. Question : (TCO 7) All of the following are Aggregate Functions EXCEPT
Student Answer: average.