1. (TCO 1) To delete the filter shown below
(Points : 5)
click Filter in the Sort & Filter group and select Clear Filter.
click Remove Filter
... [Show More] in the Sort & Filter group.
right click on any number in the Quantity column and select Clear filter from Quantity. right click on any record in the table and select Clear filter from Quantity.
2. (TCO 1) In what situation would Access be a better choice than Excel? (Points : 5) You have a limited amount of data.
You have an extensive amount of data.
You need to conduct extensive statistical analyses on your data. You require a flat file view of your data.
3. (TCO 1) All of the following are Report Wizard Layout types EXCEPT (Points : 5) block.
outline. stepped. summary.
4. (TCO 1) Which of the following is NOT a Report Section? (Points : 5) Detail
Group Footer
Page Footer Summary
5. (TCO 1) A report creation tool that will automatically pull in the fields from a table or query is the (Points : 5)
report tool. report design. report wizard. blank report.
6. (TCO 2) Which of the following is not a database system? (Points : 5) Hierarchical
Network Relational SQL
7. (TCO 2) SQL is a fourth-generation language that is (Points : 5) flat-file oriented and nonprocedural.
oriented toward static data. procedural and record oriented. table oriented and nonprocedural.
8. (TCO 3) A property that provides a "user friendly" name to a column in Datasheet View is a (Points : 5)
caption. default value. input mask. rule.
9. (TCO 3) All of the following summarize characteristics of a PivotChart EXCEPT (Points : 5) a PivotChart is created automatically each time a PivotTable is created.
changes made to a PivotTable will be made automatically to the PivotChart. some chart types are bar, line, column, pie, scatter, doughnut, and radar. PivotChart elements are modified in the Design View.
10. (TCO 3) Which of the following does NOT apply to the following relationship image?
http://takeexam.next.ecollege.com/CurrentCourse/Graphics/Final%204.jpg
(Points : 5)
A one-to-many relationship is applied.
The display is showing the Design View of relationships.
One table is not joined to the other two tables. A join exists on two primary keys.
11. (TCO 4) Which of the following does NOT describe the following one-to-one relationship?
http://takeexam.next.ecollege.com/CurrentCourse/Graphics/Final%205.jpg
(Points : 5)
The tables must have exactly the same fields.
The Employees and NewEmployees tables use the same primary key.
More tables can be joined to either table.
It may be used for security reasons to protect data availability.
PAGE 2
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
2. (TCO 5) Clicking on the form tool will open a(n) (Points : 5) existing form.
new form in design view.
new form in layout view.
wizard to design a form.
3. (TCO 6) Which of the following statements is NOT correct about a query? (Points : 5)
Changing data values in a query will not change data values in a table. Data is not saved within a query.
Instructions on which data to display are saved within a query.
Instructions on the format to display data are saved within a query.
4. (TCO 6) Which of the following expressions is NOT correct? (Points : 5) Cost: [Price] * [Qty]
DiscountAmt = [Price] * [Qty] * [Discount]
PrPerSqFt: [SalePr] / [SqFt]
Sales: [GP] * [Qty]
5. (TCO 7) To display data as percentages of a whole, use the following chart. (Points : 5) Bar
Line
Pie
Scatter Plot
6. (TCO 7) Continuous data (Points : 5) are measured in integer values.
cannot be subdivided into meaningful information. could be subdivided into smaller and smaller units. describe classifications or categories.
7. (TCO 8) The Switchboard Manager is an Access utility that is used (Points : 5) by all database users.
to create and manage the menu items for a switchboard.
to make certain objects unavailable to some users and available to others.
to manage and optimize the database.
8. (TCO 9) An encrypted file is (Points : 5) created by scrambling the content. protected by a password.
saved with a specific file extension.
unreadable if it is opened through a tampering tool or another program.
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.
10. (TCO 10) After creating an ACCDE file, you (Points : 5) can convert it back to its source format.
will see a "file already in use" message that continues to display to all other users. will be able to modify forms and reports but not tables.
will need to go back to the original file if an underlying object requires a change.
11. (TCO 4) Which statement below is NOT true of the one-to-many relationships? http://takeexam.next.ecollege.com/CurrentCourse/Graphics/Final%206.jpg
(Points : 5)
It is the least used type of relationship.
OrderID is a unique identification number that would be used in the Orders table and Order Details table.
Each record in the Orders table may match one, more than one, or no records in the Order Details table.
Each record in a Orders table matches only one record in the Customers table.
PAGE 3:
1. (TCO 1) Explain why databases are critical to organizations.
Databases form the basis to organisational decision because the statistics form a critical aspect in the decision making
2. (TCO 2) Explain the terms entity, relationship, and attributes. Describe how they are used in a database
3. Describe the insert problem caused by a de-normalized design
4. Describe what the term "data redundancy" means database design. Explain if it is bad and if a normalized database design is always the best design. Discuss the pros and cons of a normalized database. [Show Less]