Sale!

$35.00 $25.00

Categories: , , Tags: , , , ,

Description

1. (TCO 1) Which object would you use to enter, delete, or modify data? (Points : 5)

Criteria
Form
Query
Table

Question 2. 2. (TCO 1) In a table the _____ view is where you add, edit, and delete records. (Points : 5)

Design
Datasheet
SQL
Layout

Question 3. 3. (TCO 1) When creating a report in Access what report tool best outlines the following description: This report tool asks a series of questions and helps the designer create a report most suitable based on the answers the designer has given. (Points : 5)

Label Tool
Tabular Layout Report
Blank Report Tool
Report Wizard

Question 4. 4. (TCO 1) All of the following filters work EXCEPT (Points : 5)

filter by selection with an equal condition.
filter by selection with a comparison operator.
filter by selection with an edit operator.
filter by form with a comparison operator.

Question 5. 5. (TCO 1) A Report section that is used to summarize grouped field data is (Points : 5)
detail.

detail.
group header.
group footer.
report footer.

Question 6. 6. (TCO 2) For the following image, which of the following is TRUE?

Image Description: An OrderDetail Table with Primary keys of OrderID and ProductID and fields of UnitPrice, Quantity and Discount is related to an Orders Table that has an infinity symbol on the Order Details Table and a number 1 on the Orders Table. The Orders Table has a Primary key of OrderID with additional table fields: CustomerID, EmployeeID, OrderDate, REquiredDate, ShipperDate, ShipVia, Freight, ShipName, ShipAddress, Ship City, ShipRegion, ShipPostalCode, ShipCountry. (Points : 5)

The OrderID field will be unique within both the Orders and Order Details Tables.
Within the Orders Table, the OrderID field will contain more than one of the same value.
Within the Order Details Table, the OrderID field will contain more than one of the same value.
Within the Orders Details Table, the ProductID field will contain unique values only.

Question 7. 7. (TCO 2) A single Crow’s Foot at the left-most end of a relationship line would indicate (Points : 5)

a many-to-many relationship.
a one-to-many relationship.
a one-to-one relationship.
no relationship.

Question 8. 8. (TCO 3) Which of the following should be considered when designing a database? (Points : 5)

How calculated fields are used
Store data in its smallest parts
The relationship between attribute keys
The relationships between records

Question 9. 9. (TCO 3) A functional dependency is (Points : 5)

a logical relationship between attributes of a table.
a logical primary key.
a composite key.
a unique identifier.

Question 10. 10. (TCO 3) Which of the following is NOT true of a property? (Points : 5)

A property is an object’s characteristic or attribute.
Tables, forms, queries, and reports have a set of properties.
A property sheet is used to make changes.
Design properties are displayed in Datasheet view.

Question 11. 11. (TCO 4) In terms of data types and their uses, which one of the following is NOT correct? (Points : 5)

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.

1. (TCO 5) Which form type displays records in a tabular format similar to a Datasheet view but has more editing options, such as adding graphics? (Points : 5)

Datasheet Form
Multiple Items Form
Split Form
Subform

Question 2. 2. (TCO 5) The following are form creation tools EXCEPT (Points : 5)

blank form.
form design.
form layout.
Form Wizard.

Question 3. 3. (TCO 6) Queries are objects in a database based on one or more underlying (Points : 5)

forms.
modules.
tables.
macros.

Question 4. 4. (TCO 6) The benefit of a relationship is to (Points : 5)

efficiently combine data from related tables.
facilitate how Access will manage the relationship.
determine which fields to include in each table.
minimize data redundancy.

Question 5. 5. (TCO 9) A deletion anomaly is (Points : 5)

deleting facts about one entity successfully.
deleting a table.
deleting facts about one entity and deleting facts about another entity.
deleting only one fact from a column.

Question 6. 6. (TCO 2) Which of the following statements best describes data mining? (Points : 5)

It is the determining of future volume of sales.
It is the predicting of future customer buying behavior.
It is identifying patterns or relationships through a process of analyzing large quantities of data.
It is tracking customer purchasing behavior.

Question 7. 7. (TCO 8) All of the following describe a Navigation Form EXCEPT (Points : 5)

click the Create tab and then Navigation in the Forms group to create a Navigation form.
is another term for a Switchboard Manager.
helps users open forms and reports.
has the look and feel of a web form.

Question 8. 8. (TCO 9) A good password should have (Points : 5)

a combination of five letters.
a combination of six to eight letters in uppercase and lowercase, numbers, and symbols.
a word or name that is easy to remember by the user, such as the name of their children.
part of your account name.

Question 9. 9. (TCO 9) All of the following describe a certification authority EXCEPT (Points : 5)

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.

Question 10. 10. (TCO 10) ACCDE files (Points : 5)

deny users permission to create and change forms and reports within a database.
deny users permission to create forms and reports but will allow them to modify forms and reports.
give users permission to create and change forms and reports within a database.
give users permission to fully access a database.

Question 11. 11. (TCO 4) Which of the following is NOT true of a ship date field? (Points : 5)

A ship date is considered a constant.
A ship date would be defined as a date/time field.
A ship date would be defined as a calculated field.
Date arithmetic can be applied to a ship date field.

4. (TCO 4) What is a relational database management system and how does it relate to a database administrator? (Points : 40)

2. (TCO 2) Explain business logic and describe how it relates to a relational database. (Points : 40)

3. (TCO 4) Explain the terms entity and attribute. Describe an example of an entity and then list two attributes. Using your examples, explain the data types that would be used to capture the attributes. (Points : 40)

1. (TCO 1) What role do databases play in today’s business world and why are they important? Provide two specific examples of how a database might be used by a business. (Points : 40)

1. Question: (TCO 1) The easiest way to create a report is to use the following report tool.

Student Answer:
Blank Report
Report Layout
Report Design
Report Wizard

Question 2. Question: (TCO 1) A report footer

student Answer:
is used to print page numbers on the report.
prints group statistics at the end of the report.
prints grand totals at the end of the report.
All of the above

Question 3. Question: (TCO 1) Which report section would be used to summarize grouped field data?

Student Answer:
Detail
Group Header
Group Footer
Report Footer

Question 4. Question: (TCO 1) To preview the report, which view(s) work best?

Student Answer:
Report view or Design view.
Layout view or Print view.
Design view.
Print view.

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

Question 6. Question: (TCO 1) Modifications to a report can be done in

Student Answer:

Detail view.
Layout view.
Print view.
All of the above

Question 7. Question: (TCO 7) To use the report Wizard, do the following steps first:

Student Answer:

Click create and click report Wizard.
Click report wizard and select the correct table.
select the correct fields.
All of the above

Question 8. Question: (TCO 7) A good use of a report is to

Student Answer:

create a telephone directory or a financial statement.
ask the database a question.
create a table or query.
create detailed charts.

Question 9. Question: (TCO 7) Which is not a report view?

Student Answer:

Print preview
Datasheet view
Report view
Layout view

Question 10. Question: (TCO 7) When modifying a report, the arrange option does the following.

Student Answer:

To move fields up or down
To insert space above or below your position
To change the layout of the report
All of the above

1. Question: (TCO 2) A required field that is used in entering data is a field that

Student Answer:

appears with a specific value.
can be left blank.
cannot be left blank.
is selected from a list of values.

Question 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.
Instructor Explanation: See Chapter 5: Grauer section of book.

Question 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.
Instructor Explanation: See Chapter 5: Grauer section of book.

Question 4. Question: (TCO 2) Which of the following will create a lookup field, populate the values in the field, and establish relationships between tables?

Student Answer:

Design View
Fields Group
Lookup List
Lookup Wizard

Question 5. Question: (TCO 2) An input mask that will NOT accept a letter (A to Z) in a field value is

Student Answer:

?.
A.
L.
#.

Question 6. Question: (TCO 5) To edit a form, use the

Student Answer:

design view.
datasheet view.
layout view.
layout view or design view.

Question 7. Question: (TCO 5) A form type that displays records in a tabular format, but has more editing options is a(n)

Student Answer:

datasheet form.
multiple items form.
split form.
subform.

Question 8. Question: (TCO 5) If you click on the form tool, you will open a(n)

Student Answer:

existing form.
new form in design view.
new form in layout view.
wizard to design a form.

Question 9. Question: (TCO 5) The title for a form should be placed in the

Student Answer:

details area.
form header.
textbox in the details area.
textbox in the form header.

Question 10. Question: (TCO 5) All of the following are aggregate functions EXCEPT

Student Answer:

average.
count.
minimum.
subtract.

1. Question: (TCO 1) When designing a database, you should

Student Answer:

determine the input and then design the tables.
determine the output and then design the tables.
develop the forms and then input the data.
input the data and then design the reports.

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

Student Answer:

autonumber.
date/time.
number.
string.

Question 3. Question: (TCO 2) Which wizard is NOT available from the Query Wizard?

Student Answer:

Crosstab Query Wizard
Find Duplicates Query Wizard
Simple Query Wizard
Summarize Query Wizard

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

Student Answer:

autonumber
camelcase
primary key
PPNI

Question 5. Question: (TCO 2) A long text field

Student Answer:

is a link to text information in another file.
holds important information that needs to be flagged.
is used to store descriptive information and has more than 255 characters.
is used to store text information up to 255 characters.

Question 6. Question: (TCO 2) Which of the following statements is true about queries?

Student Answer:

Forms and queries are actually the same thing.
Queries can only be based on one table
Query results are not saved after the query is executed.
The instructions to create a query are not stored in the database.

Question 7. Question: (TCO 2) When building a calculated field, formulas can be created using the

Student Answer:

Form Wizard.
Expression Builder.
Report Builder.
Table Wizard.

Question 8. Question: (TCO 2) In Access, the bottom portion of Query Design View that displays the fields and criteria is known as the

Student Answer:

query design grid.
Show Tables dialog.
Simple Query Wizard.
query datasheet.

Question 9. Question: (TCO 6) Which of the following does NOT describe data redundancy?

Student Answer:

The same data exists in multiple tables.
The data is always in linked tables.
Data updating must be done in multiple table locations.
Data redundancy can result in data anomalies.

Question 10. Question: (TCO 6) Which of the following is true about a crosstab query?

Student Answer:

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.

1. Question: (TCO 2) In a relational database, entities are

Student Answer:

events.
persons.
things.
All of the above

Question 2. Question: (TCO 2) Which of the following is NOT a step in the Database Life Cycle?

Student Answer:

Database Design
Maintenance and Redevelopment
Performance
Testing

Question 3. Question: (TCO 3) Database design refers to

Student Answer:

developing a database model that will support company operations.
focusing on understanding the business and its functional areas or business processes.
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.
Instructor Explanation: See the Week 3 Lesson.

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

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

Question 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

Question 7. Question: (TCO 3) What does not define a composite key?

Student Answer:

Using two or more fields as a primary key
Using three fields as a primary key
Using two fields as a primary key
Using one field as a primary key

Question 8. Question: (TCO 4) Which statement below is NOT true of one-to-many relationships?

Student Answer:

It is the least-used type of relationship.
The table with the primary key must only have one occurrence of each value for the primary key.
The foreign key in the related table may have repeating values for the foreign key.
An example is that one employee may take multiple orders.

Question 9. Question: (TCO 4) Which is NOT true of a calculated field?

Student Answer:

It cannot be added to queries or reports.
The value of a calculated field is produced from an expression.
A calculated field references other fields.
The result is useful at the moment the calculation is made.

Question 10. Question: (TCO 4) Which of the following is a special-definition setting used on a field containing an employee’s date of hire?

Student Answer:

Date arithmetic
Constant
Date/time field
Calculated field

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

Student Answer:

data type.
query.
hyperlink.
primary key.

Question 2. Question: (TCO 2) In an ER diagram, a crow’s foot is used

Student Answer: as a symbol for an entity.
to establish tuples.
to model attributes.
to point toward a child table.

Question 3. Question: (TCO 2) Columns in an Access table are called

Student Answer: fields.
records.
relation.
tuples.

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

Question 5. Question: (TCO 3) In Access, a query result that contained the date November 12, 2011 could have had which of the following query criteria?

Student Answer:
11/12/2011
12/11/2011
#12/11/2011#
Between #10/01/2011# And #11/12/2011#

Question 6. Question: (TCO 3) The field property that ensures that the field is not empty is

Student Answer:
Format.
Required.
Validation.
Validation Rule.

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

Question 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

Question 9. Question: (TCO 4) Which of the following is NOT an Access data type?

Student Answer:
Text
Currency
Name
Date/Time

Question 10. Question: (TCO 2) In Access, which item below is NOT considered a logical operator?

Student Answer:
Equal
And
Not
Or

1. Question: (TCO 1) A database management system (DBMS) is a collection of programs that

Student Answer:
store data.
manage data.
use collections of data.
All of the above

Question 2. Question: (TCO 1) You should use Access over Excel when

Student Answer:
you have a large amount of data.
you need to create complex charts.
you have only one worksheet to handle all of your data.
you have extensive subtotals and totals in your worksheet.

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

Question 4. Question:(TCO 1) The view in Access which looks similar to an Excel spreadsheet is

Student Answer:
Datasheet.
Design.
Form.
Report.

Question 5. Question: (TCO 1) Which view best describes the image below?

Student Answer:
Datasheet
Design
Form
Report

Question 6. Question: (TCO 2) To add, delete, and edit a record, use

Student Answer:
Datasheet view of a table.
Design view of a table.
Design view of a query.
Report view.

Question 7. Question: (TCO 2) Types of relationships between tables do NOT include

Student Answer:
one-to-one.
many-to-many.
primary-to-foreign.
many-to-one.

Question 8. Question: (TCO 1) Excel should be used instead of Access when

Student Answer:
you have a small amount of data.
your data needs to be regrouped in various views.
your data needs connectivity to external databases.
your data requires a relational database.