1. (TCO 1) Which object would you use to enter, delete, or modify data? (Points : 5)
Question 2. 2. (TCO 1) In a table the _____ view is where you add, edit, and delete records. (Points : 5)
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)
Tabular Layout Report
Blank Report Tool
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)
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.
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)
Multiple Items Form
Question 2. 2. (TCO 5) The following are form creation tools EXCEPT (Points : 5)
Question 3. 3. (TCO 6) Queries are objects in a database based on one or more underlying (Points : 5)
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.
Question 2. Question: (TCO 1) A report footer
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?
Question 4. Question: (TCO 1) To preview the report, which view(s) work best?
Report view or Design view.
Layout view or Print view.
Question 5. Question: (TCO 1) Grouping data in a report will
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
All of the above
Question 7. Question: (TCO 7) To use the report Wizard, do the following steps first:
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
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?
Question 10. Question: (TCO 7) When modifying a report, the arrange option does the following.
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
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
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)
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?
Question 5. Question: (TCO 2) An input mask that will NOT accept a letter (A to Z) in a field value is
Question 6. Question: (TCO 5) To edit a form, use the
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)
multiple items form.
Question 8. Question: (TCO 5) If you click on the form tool, you will open a(n)
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
textbox in the details area.
textbox in the form header.
Question 10. Question: (TCO 5) All of the following are aggregate functions EXCEPT
1. Question: (TCO 1) When designing a database, you should
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
Question 3. Question: (TCO 2) Which wizard is NOT available from the Query Wizard?
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?
Question 5. Question: (TCO 2) A long text field
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?
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
Question 8. Question: (TCO 2) In Access, the bottom portion of Query Design View that displays the fields and criteria is known as the
query design grid.
Show Tables dialog.
Simple Query Wizard.
Question 9. Question: (TCO 6) Which of the following does NOT describe data redundancy?
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?
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
All of the above
Question 2. Question: (TCO 2) Which of the following is NOT a step in the Database Life Cycle?
Maintenance and Redevelopment
Question 3. Question: (TCO 3) Database design refers to
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
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
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
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?
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?
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?
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?
1. Question: (TCO 2) To create a relationship between two tables, you need at least a
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.
Question 4. Question: (TCO 3) A relational table includes the following conditions EXCEPT
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?
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
Question 7. Question: (TCO 3) 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. Question: (TCO 4) Which of the following is NOT an example of a primary key?
ISBN number for a textbook
Social Security Number
Question 9. Question: (TCO 4) Which of the following is NOT an Access data type?
Question 10. Question: (TCO 2) In Access, which item below is NOT considered a logical operator?
1. Question: (TCO 1) A database management system (DBMS) is a collection of programs that
use collections of data.
All of the above
Question 2. Question: (TCO 1) You should use Access over Excel when
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
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
Question 5. Question: (TCO 1) Which view best describes the image below?
Question 6. Question: (TCO 2) To add, delete, and edit a record, use
Datasheet view of a table.
Design view of a table.
Design view of a query.
Question 7. Question: (TCO 2) Types of relationships between tables do NOT include
Question 8. Question: (TCO 1) Excel should be used instead of Access when
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.