CS 245 CS245 FINAL EXAM with Answers

CS 245 CS/245 CS245 FINAL EXAM

1. Access is a ____________ database management system.

a. Hierarchical

b. Helical

c. Relational

d. Rational

e. Relationship

2. When you launch Microsoft Access, you can choose a pre-built skeletal database called a _____ from a wide variety of them available online and on your local computer.

a. Form

b. Template

c. Sample database

d. Download

e. Skeleton

3. The View menu under the file tab lets you select the display of different types of objects including forms, reports, macros, _____ and code.

a. Favorites

b. Groups

c. Design

d. Tables

e. Controls

4. Only one type of object actually holds database data. That object is the database’s _____.

a. Table

b. Query

c. Database engine

d. Form

e. History

5. You can place filtering criterion into the QBE on a(n) _____.

a. Form

b. View

c. Query

d. Attribute

e. Scale

6. When you fill in two or more Criteria rows of a query’s QBE grid under the same column, it is equivalent to using a(n) _____ operator.

a. And

b. Not

c. Or

d. Filter

e. Between

7. A _____ form simultaneously displays a form in one panel and a table’s Datasheet view in the other panel.

a. Columnar

b. Tabular

c. Relationships

d. Split

e. Bifurcated

8. You should never store in a table any value that is functionally _____ two or more fields in the same record.

a. Preceding

b. Dependent on

c. Opposed to

d. Linked with

e. Engaged with

9. Assume the sales tax charged on all purchases is 6.5 percent of the Price field available in a table called tblSales. What is the correct expression to compute sales tax—the expression you would place in a field row of the query to display the tax?

a. 6.5 * [Price]

b. [Price] * 0.065

c. 0.065 * [tblSales]

d. 6.5%[Price]

e. None of the above

10. Bar code scanners are useful tools in accounting database systems because they can quite easily

a. Post journal entries to the general ledger

b. Capture a wide variety of information about each transaction

c. Prevent or detect cashier fraud

d. Identify pricing errors in the database

e. All of the above

11. The events-based approach to accounting theory

a. Classifies business in terms of their complexity

b. Requires the use of the REA model to classify entities

c. Supports the use of double-entry bookkeeping systems

d. Supports the use of relational database accounting systems

e. Overrides conventional wisdom

12. A double-entry bookkeeping systems records each transaction

a. Twice

b. As an abstraction

c. In a relational database

d. On the day it occurs

e. Thrice

13. Computerized accounting systems

a. Can be used to implement either a double-entry bookkeeping model or a database accounting model

b. Always require the installation of expensive database management software

c. Must be certified by the IRS and the AICPA before being sold

d. Record all transactions in the general journal before posting them to special journals

e. All of the above

14. Database systems store data only once. This feature

a. Allows multiple users to have simultaneous access to data

b. Facilitates cross-functional data analysis

c. Greatly reduces data inconsistencies within the system

d. Makes it easier for managers to create their own customized reports

e. Ensures referential integrity

15. A collection of tables that contain information about a database, including the database table structures and a list of all fields included in each table, is called a

a. Data dictionary

b. Master data file

c. Database index

d. Database summary

e. None of the above

16. Select and project are two fundamental data retrieval operations that you can use in a relational database. Which of the following is a true statement regarding these operations?

a. The select operation selects columns from a table.

b. The project operation selects columns from a table.

c. The project operation moves data from one table to another table.

d. You must join two tables before using either the select or project operations.

e. All of the above are true.

17. A table that does not include any transitive dependencies

a. Cannot be in any normal form; all normal forms require at least one transitive dependency.

b. Is in first normal form or higher.

c. Is in second normal form or higher.

d. Is in third normal form or higher.

e. Is in fourth normal form or higher.

18. To represent a many-to-many relationship in a relational database, the designer must

a. Create four tables, each having a one-to-one relationship with the other three tables

b. Create three tables, one for each of the entities and a third relationship table that includes the primary keys of the two entity tables

c. Combine the two entity tables that share the many-to-many relationship into a single table

d. Eliminate the many-to-many relationship; such relationships are not permitted

e. Specify the relationship is many to many in MS Access

19. In Microsoft Access, data is posted to a table the moment you

a. Type new data into the appropriate empty field

b. Type data over the existing data in a field

c. Move to another table record

d. Delete the old data and type in the new data

e. None of the above

20. The expand indicator seen when viewing a table in the datasheet view is used to

a. Open the Field properties panel.

b. Expand a field when editing so all the data is visible

c. Enlarge the current window

d. Display any records related to the current row

e. Increase the font size for near-sighted individuals

21. You remove table fields by doing what?

a. Highlighting the field in Datasheet view and pressing the delete key

b. Right-clicking the field heading and clicking Delete Field

c. Deleting the row corresponding to the data field in Design view

d. All of the above

e. None of the above

22. To link two tables, forming a relationship between them, you

a. Open the relationships window and drag one table’s primary key field to the other table’s foreign key field

b. Must always use a lookup field, because manually linking two tables otherwise is impossible.

c. Must first display both tables in design view

d. None of the above.

e. All of the above

23. This field property allows you to restrict the range of values that a user can enter into datasheet view.

a. Caption

b. Default value

c. Validation text

d. Validation rule

e. Range rule

24. Setting a particular table field property for text fields to “yes” allows users to enter a special value that indicates “yes, I know the value but there is no value for this field.” What is that field called?

a. Required

b. Indexed

c. Allow zero length

d. Caption

e. Possible

25. Taking this action in datasheet view allows you to keep selected table columns always in view when you scroll to the right in a table with many columns.

a. Tiling columns

b. Cascading columns

c. Resizing columns

d. Disabling columns

e. Freezing columns

26. This special datasheet view row can display the number of nonempty values in a column of text.

a. Column aggregate value row

b. Total row

c. Relationships row

d. Count row

e. Summary row

27. This displays the names of database objects including tables, queries, and so on.

a. Datasheet contextual tab

b. Relationships tab

c. Navigation tab

d. Navigation pane

e. Relationships view

28. In the navigation pane, you cannot view objects by

a. Tables

b. Queries

c. Reports

d. Custom groups of objects

e. None of the above

29. What are the key differences between action queries and select queries?

a. Action queries allow you to change data, whereas select queries only allow you to view data from multiple tables or queries

b. Selection queries allow you to select and change data, whereas action queries allow you to only look at data

c. Action queries allow you to retrieve and display data from multiple tables, whereas select queries allow you to select, create, and delete data.

d. All of the above

e. None of the above are differences

30. There are five views available for queries. One of them is not:

a. Design

b. SQL

c. Parameter

d. Datasheet

e. Pivot Chart

31. No relational database, including Access, can deal directly with this type of inter-table relationship.

a. One-to-one

b. One-to-many

c. Many-to-many

d. Many-to-one

e. Access and other relational databases can deal with all of the preceding relationships

32. To build a query in design view, minimally you need to do what?

a. Add the tables to be included in the query and drag the fields to be returned to the QBE

b. Enter the selection criteria

c. Open the query in datasheet view to see the results

d. Create a form

e. Do all of the above

33. What field property allows you to control what value appears in a field initially?

a. Caption

b. Default value

c. Indexed

d. Input mask

e. Validation text

34. What type of query correlates values between two or more sets of field values?

a. Crosstab

b. Parameter

c. SQL

d. Update

e. Action

35. When writing expressions to perform calculations in queries, table fields are referenced by enclosing the field names in

a. Parentheses

b. Brackets

c. Quotes

d. Pound signs

e. Curly braces

36. Using a(n) _____ will list all rows from one table and only matching rows from another table.

a. Inter join

b. Intra join

c. Outer join

d. In line join

e. Left inner join

37. What clause in the SQL statement filters rows, limiting the dynaset to those that satisfy the clause?

a. Select

b. From

c. Where

d. Order by

e. Count

38. What is the advantage of using a parameter query over conventional queries?

a. It is more versatile

b. Selection criteria are specified when the query is run

c. It provides varied results based on criteria entered.

d. All of the above.

e. None of the above

39. Which type of form requires a response before the user can continue working?

a. Continuous form

b. Subform

c. Multiple-page form

d. Modal form

e. Response form

40. The active field on a form into which you can type or press the spacebar is called

a. The hub

b. The focus

c. The domain

d. The center

e. None of the above

41. When using form wizard, clicking the >> button will

a. Move all fields from Available to Selected fields

b. Move only the highlight field from Available to Selected fields

c. Move all fields from Selected to Available fields

d. Move only the highlighted field from Selected to Available fields

e. None of the above

42. Which type of form control has no control source?

a. Bound

b. Unbound

c. Calculated

d. Processed

e. Direct

43. What view do you use to move controls on a form or subform?

a. Datasheet

b. Design

c. Form

d. Properties

e. Print Preview

44. The text that appears in a label control is its _______ property.

a. Name

b. Caption

c. Form

d. Default view

e. Text

45. This type of form has two sections: A form and a datasheet.

a. Multiple items

b. Pivot table

c. Modal dialog

d. Split

e. Bimodal

46. The _____ layout form groups controls into an arrangement similar to a paper form with labels to the left of each field. The grouping facilitates manipulation of many controls at once.

a. Tabular

b. Stacked

c. Modal

d. Columnar

e. None of the above

47. You use _____ to catch any form data entry errors and provide informative error messages.

a. Radio buttons

b. Check boxes

c. Table properties

d. Data validation

e. None of the above

48. This form provides controls to open other forms

a. Navigation

b. Default

c. Layout

d. Modal

e. Entry

49. Which section of a report is required?

a. Report header

b. Report footer

c. Summary

d. Detail

e. Sidebar

50. Reports have four views. They are Report, Print Preview, Design, and what?

a. Report Preview

b. Layout

c. Export

d. Word

e. Excel

51. If you need to move, resize, or delete one or more columns in a report, then the best view to accomplish this in is

a. Design

b. Layout

c. Print Preview

d. Report

e. Word

52. What is the name of the report band that appears at the end of each page?

a. Report footer

b. Detail footer

c. Group footer

d. Page footer

e. Summary footer

53. You apply this to a report control when it display characteristics depend on its value?

a. Formatting

b. Immediate formatting

c. Dynamic formatting

d. Dependent formatting

e. Conditional formatting

54. Report controls that display database fields are called what?

a. Bound controls

b. Calculated controls

c. Database controls

d. Unbound controls

e. Field controls

55. An example of a layout scheme that organizes report controls so that they can be moved as a group in Layout view, for example, is called what?

a. Layout columns

b. Control layout

c. Group layout

d. Controlled layout

e. Tabular layout

56. You add calculated values and expressions, to a report by including what from the available controls in Design view?

a. Label control

b. Border control

c. Option group control

d. Expression control

e. Text box control

57. If you want to add an expression to the Detail band of a report, the best way is to base the report on what?

a. A table containing an expression

b. A form containing an expression

c. Another report containing an expression

d. A query containing the expression

e. None of the above

58. The best way to send a report to another person so that it can be viewed is in what format?

a. XPS

b. Access Database

c. PDF

d. Microsoft Word

e. JPEG

59. The Access DLOOKUP function

a. Returns a value from a specified set of records

b. Returns a value from a specified set of attributes

c. Requires a table name as a criterion

d. Both a and c

e. Both b and c

60. The Access Nz function

a. Returns a value when the value is not zero

b. Returns a value when the value is null

c. Converts a zero value to null, no exceptions

d. Converts a null value to zero, no exceptions

e. None of the above

61. The Access IsNull function

a. Returns a zero when the value is null

b. Returns False when the value is null

c. Returns True when the value is null

d. Returns a one when the value is null

e. Returns null for any value

62. An acceptable form of Camel Code as taught in this class is

a. tblThisIsOkay

b. QryThisOneIsRight

c. TblThisIsOkay

d. rtpOnlyThisIsCorrect

e. mcRnonEoFthEabovE

63. A range test

a. Tests a value to see if it is the correct data type

b. Tests a value to see if it is in the correct table

c. Tests value to see if it falls within a predefined range

d. Both b and c

e. None of the above

64. The Validation Text Field Property

a. Tests the validity of text entered into a field

b. Allows the generation of a user-defined message if the value is valid

c. Allows a pre-defined message to appear if a value is not valid

d. None of the above

e. All of the above

65. An Input Mask is

a. A pattern for data to follow for a table

b. A mask that makes the data unavailable on the form

c. A mask that makes the data transparent on the form

d. A pattern for all data to follow for a particular field

e. None of the above

66. Captions

a. Help document the true meaning of fields

b. Make tables easier to read and interpret

c. Make reports more understandable

d. Improve the user experience

e. All of the above

67. Composite Primary Keys

a. Are used in many RDBMSs, but not MS Access

b. Identify records using two or more attributes

c. Identify records using two attributes

d. Are not recommended, ever

e. Are an adaptation to incomplete technology

68. Referential integrity is enforced

a. As the default option for newly created relationships

b. When a developer wants the foreign key of one table to always be the primary key in another table

c. When a developer wants the primary key of one table to always be the foreign key in another table

d. When a developer wants the primary key of one table to be the foreign key in another table

e. When a developer wants the foreign key of one table to never be the primary key of another table

69. A form can be started when MS Access starts by

a. Naming it frmMain. This designates the form as the startup form

b. Naming it frmStartup. This designates the form as the startup form

c. Going into Current Database options and choosing a Display form

d. Going into General Options and choosing a startup form

e. None of the above

70. The “enabled” property in a form

a. Specifies whether you can edit data in a control in form view

b. Specifies whether you can edit data in design view

c. Specifies whether you can edit data in layout view

d. Specifies whether a control can have the focus in form view

e. Specifies whether a control can have the focus in design view

71. The “TabStop” property in a form

a. Specifies whether you can move the focus to a control by pressing the TAB key in form view

b. Specifies whether you can move the focus to a control by pressing the TAB key in design view

c. Specifies whether you can move the focus to a control by pressing the TAB key in layout view

d. Specifies whether you can move the focus to a control by pressing the TAB key in print preview view

e. All of the above

72. In a form combo box

a. A user must always select an item from the combo box

b. A user may select an item from the combo box

c. A user must select from the combo box if the limit to list value is “Yes”

d. Both a and c

e. Both b and c

73. To concatenate multiple address fields and display them on multiple lines you might include

a. &

b. Chr(13)

c. Chr(10)

d. Multiple fields

e. All of the above

74. The Access IIF function

a. Returns a value is a specified condition is True

b. Returns a value is a specified condition is False

c. Returns no value if a specified condition is False

d. Both a and b

e. Both a and c

75. Which field property disallows data from being entered into a field before moving to the next field?

a. Validation rule only

b. Input mask only

c. Both validation rule and input mask

d. Neither validation rule nor input mask

e. Length rule only

76. What date constraint parameters should be used in the criteria when computing balance sheet items like account payables?

a. <= [Beginning of Period Date]

b. <= [End of Period Date]

c. Between [Beginning of Period Date] and [End of Period Date]

d. [Beginning Period Date] <= [End of Period Date]

e. [End of Period Date] >= [Beginning of Period Date]

77. In the MS Access Query Design view, to match a cell that contains nothing in a query, one would type in the criteria field:

a. Is Null

b. 0

c. “”

d. Nothing

e. None

78. In the MS Access Query Design view, if I were to add a field to a query with the contents: TotalExpense: [airfare] + [hotel] + [car rental]

What would we call this type of field?

a. Aggregate Field

b. Calculated Field

c. Summation Field

d. Totals Field

e. None of the Above

79. In MS Access, is it possible to query a query?

a. Yes

b. No

c. It depends

d. Maybe 20 years from now

e. None of the above

80. Parameter values allow you to

a. Enter a value when a query is run

b. Replace a value when a query is run

c. Change the functionality of a query when it is run

d. Modify formulas when a query is run

e. All of the above

81. Temp Vars allow you to

a. Change the value of an attribute when a query is run

b. Store, temporarily, values need in a table

c. Change the parameter value for a query

d. Define module variables

e. Store a value in a variable that can be reused in queries

82. To create an outer join

a. Left click on the relationship between fields in a query and choose options 1 or 2

b. Right click on the relationship between fields in a query and choose options 2 or 3

c. Left click on the relationship between fields in a query and choose options 2 or 3

d. Right click on the relationship between fields in a query and choose options 1 or 2

e. None of the above

83. An inner join will

a. Return all records from the table with the primary key

b. Return all records from the table with the foreign key

c. Return all records from the table with the foreign key and only matching records from the other table

d. Return all records from the table with the primary key and only matching records from the other table

e. Return only matching records from either table

84. The difference between project and select is

a. Project returns columns and select returns records

b. Project returns records and select returns columns

c. Project returns columns and select returns attributes

d. Project returns rows and select returns tuples

e. At least two of these answers are correct

85. You can most quickly create a form based on a table by opening a table and (under the create tab)

a. Clicking on the form wizard button

b. Clicking on the form design button

c. Clicking on the blank form button

d. Clicking on the navigation button

e. Clicking on the form button

86. The part of the ribbon that lets you access relationships is called

a. Home

b. Create

c. External data

d. Database tools

e. Design

87. The part of the ribbon that lets you create database objects is called

a. Home

b. Create

c. External data

d. Database tools

e. design

88. In the relationships view, if a table is added twice then

a. A table can’t be added twice

b. Access explodes

c. The second table is treated the same as the first, but is given a slightly different name

d. The second table is treated differently than the first and is given a slightly different name

e. The second table is treated differently than the first and is given the same name

89. In the relationships view, the cardinality is

a. Edited by selected 1 to 1, or 1 to many

b. Determined based on the tables’ designs and relationships

c. Unknown

d. All of the above

e. None of the above

90. The view that is unique to reports is called

a. Design

b. Print preview

c. Layout

d. SQL

e. Pivot Table

91. The view that is unique to forms is called

a. Layout

b. Design

c. Pivot Chart

d. Form

e. There are not views unique to forms

92. The view that is unique to queries is called

a. Design view

b. Layout view

c. Sql

d. Pivot table

e. Pivot chart

93. The view that is unique to tables is called

a. Pivot table

b. Pivot chart

c. Design

d. Datasheet

e. There are not views unique to tables

94. The view that is unique to modules is called

a. Design

b. Datasheet

c. Pivot Chart

d. Code

e. There are no comparable views for modules

95. Which term does not belong?

a. Record

b. Row

c. Tuple

d. Attribute

e. They all belong

96. In the current database menu under Access options you can

a. Customize the quick access toolbar

b. Change language settings

c. Switch between overlapping windows and tabbed documents

d. Change the default file format for a database

e. Modify the SQL Server compatible syntax

97. The Navigation Pane displays database objects including

a. Tables

b. Queries

c. Modules

d. Reports

e. All of the above

98. On the Access welcome screen, the two buttons that accomplish the same task are

a. Create

b. Blank Database

c. New

d. A and B

e. B and C

99. Which term does not belong?

a. Record

b. Attribute

c. Field

d. Column

e. They all belong

100. Access is supported by ____, an object-oriented programming language.

a. QBasic

b. C++

c. Java

d. Perl

e. VBA