To display a subset of records based on certain criteria, use which of the following?

To display a subset of records based on certain criteria, use which of the following?

Question : (TCO 1) A collection of customer information and purchase transactions that might be stored in both Access and Excel would be called a_____

Student Answer: Field

Record

Table

Database

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

Design

Form

Report

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 called

Student Answer: server setup.

presentation task.

client browsing.

systems application.

7. Question : (TCO 2) How many data types does Access recognize?

Student Answer: 5

7

9

10

8. Question : (TCO 1) To display a subset of records based on certain criteria, use which of the following?

Student Answer: Filter

Form

Report

Table

1. Question : (TCO 2) To create a relationship between two tables, you need at least a

Student Answer: data type.

query.

hyperlink.

primary key.

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.

Required.

Validation.

Validation Rule.

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

Last name

Social Security Number

Student ID

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.

field type.

Sarbanes-Oxley Act.

validation rule.

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

Field Size

Input Mask

Validation Rule

1. Question : (TCO 2) Which of the following is an example of an entity in a business?

Student Answer: Company

Business owner

CEO

Employees

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
generated.

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

Currency

Money

Number

9. Question : (TCO 4) You can reserve space for a field using the

Student Answer: PNPI regulations.

Sarbanes-Oxley Act.

field size property.

validation rule.

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.

files.

records.

tables.

2. Question : (TCO 2) All of the following are Access data types EXCEPT

Student Answer: autonumber.

date/time.

number.

string.

3. Question : (TCO 2) In Access, query results are displayed in which view?

Student Answer: datasheet.

form.

recordset.

report.

4. Question : (TCO 2) Which of the following is a naming convention for field names?

Student Answer: autonumber

camelcase

primary key

PPNI

5. Question : (TCO 2) The command language used with relational databases is

Student Answer: PNPI.

RDBMS.

SQL.

tuple.

6. Question : (TCO 2) Another term for an expression is

Student Answer: formula.

function.

parameter.

query.

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.

input mask.

primary key.

validation rule.

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.

field.

list.

table.

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.

form design.

form layout.

form wizard.

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

Report

Report Design

Report Wizard

2. Question : (TCO 1) All of the following are report sections EXCEPT

Student Answer: detail.

group footer.

page footer.

summary.

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.

spreadsheet.

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.

group labels.

report labels.

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.

filter field.

row 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.

discrete data.

percentages of a whole.

vertically stacked data.

10. Question : (TCO 7) All of the following are Aggregate Functions EXCEPT

Student Answer: average.

count.

select.

sum.


Price: £ 45

100% Plagiarism Free & Custom Written, Tailored to your instructions

Leave your Comments


Can't read the image? click here to refresh