41. Different levels of access are assigned to personnel records in the health and fitness gym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by
A. Password
B. User id’s
C. Status
D. None of the above
Answer
A. Password
42. You can switch back and forth betweendesign and datasheet view by clicking the
A. queries object tab
B. switch command on the view menu
C. view button
D. select query title bar
Answer
C. view button
43. The table wizard
A. Quickly creates a default report
B. Displays a subset of the data in a database
C. Contains sample tables and fields you can use to create a table
D. Automatically edits your data as you enter it
Answer
D. Automatically edits your data as you enter it
44. The names, address, and account balance of all of your customers, select the best fit for answer
A. record
B. file
C. database
D. key field
Answer
D. key field
45. An integrated collection of all of the data about your customers. Select the best fit for answer
A. Record
B. File
C. Database
D. Key field
Answer
B. File
46. An identification field in a record. Select the best fit for answer
A. Record
B. File
C. Database
D. Key field
Answer
C. Database
47. What is part of database that holds all of the information about one item or subject?
A. Record
B. File
C. Query
D. Chart
Answer
A. Record
48. What is a stored question about information in a database?
A. Record
B. Field
C. Report
D. Query
Answer
D. Query
49. RDBMS stands for
A. Relational Database Management System
B. Relation Data Module System
C. Right Data Base Management System
D. None of the above
Answer
A. Relational Database Management System
50. Pack command is used to
A. Remove records permanently
B. Remove records temporarily
C. Restore records permanently
D. Restore records temporarily
Answer
A. Remove records permanently
51. Modules are
A. selection of commands used to automate repetitive tasks
B. programs written in Visual C++
C. Object tabs
D. Group of records
Answer
A. selection of commands used to automate repetitive tasks
52. APPEND command is used to
A. Add record to the end of active database file and starts full screen data entry
B. Add Record to the start of active database file
C. Add record to the start of active database file and starts full screen data entry
D. Add record to the end of database file
Answer
A. Add record to the end of active database file and starts full screen data entry
53. Append from command is used to
A. Add records from information in an array
B. Adds records from a file
C. Add records from a variable
D. Add records from stock
Answer
A. Add records from information in an array
54. Examples of centralized multi-user databases are
A. Barclays’ Bank customer accounts
B. Supermarket stock control, organ donor database, client database
C. Airline reservations and other national global booking systems
D. None of above
Answer
C. Airline reservations and other national global booking systems
55. New record is added using
A. Append record from browse menu
B. Append record into from browse menu
C. Add record from edit menu
D. All of above
Answer
A. Append record from browse menu
56. When a customer makes an online hotel booking, the database is updated in
A. Batch mode
B. Pseudo real-time
C. One month
D. All of above
Answer
B. Pseudo real-time
57. A database that contains tables linked by common fields is called a
A. Centralized database
B. Flat file database
C. Relational database
D. None of above
Answer
C. Relational database
58. The use of integrated collections of database records and files for data storage and processing. The best fit for answer:
A. Database management approach
B. DBMS uses
C. Database administrator
D. Query language
Answer
D. Query language
59. DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer
A. Database management approach
B. DBBMS uses
C. Database administrator
D. Query language
Answer
D. Query language
60. A specialist in charge of the database of anorganization select the best fit for answer
A. Database management approach
B. DBMS uses
C. Database administrator
D. Query language
Answer
B. DBMS uses
61. This DBMS feature allows users to easily interrogate a database. Select the best fit for answer
A. Database management approach
B. DBMS uses
C. Database administrator
D. Query language
Answer
C. Database administrator
62. The ___ presents data in a way similar to an excel spreadsheet
A. Datasheet view
B. Design view
C. Print preview
D. Layout preview
Answer
C. Print preview
63. It Is used to build and modify database objects and also to create new queries
A. Datasheet view
B. Design view
C. Print preview
D. Layout preview
Answer
C. Print preview
64. It shows the appearance and layout of a report, table or form in order to confirm what will be printed.
A. Datasheet view
B. Design view
C. Print preview
D. Layout preview
Answer
B. Design view
65. It examines a small portion or sample of your data in a report before printing it.
A. Datasheet view
B. Design view
C. Print preview
D. Layout preview
Answer
D. Layout preview
66. A report form
A. Appears on the computer monitor during data entry
B. Is used during report generation to format data
C. Both (A) and (B)
D. All of above
Answer
B. Is used during report generation to format data
67. Which of the following columns can not be found in the macro design window?
A. Arguments column
B. Comment column
C. Conditions column
D. Actions column
Answer
B. Comment column
68. The ascending order of a data hierarchy ios:
A. Bit, byte, field, record, file, database
B. Bit, byte, record, field, file, database
C. Byte, bit, field, record, file, database
D. Byte, bit, record, field, file, database
Answer
D. Byte, bit, record, field, file, database
69. A good query system
A. Can accept English language commands
B. Allows non-programmers to access information stored in a database
C. Can be accessed only by data prssing professionals
D. Both (A) and (B)
Answer
B. Allows non-programmers to access information stored in a database
70. How do you freeze a field a column or field in Microsoft Access?
A. Click anywhere in the column and select Edit>Freeze Column form the menu
B. Place an ice cube in the column
C. Click anywhere in the column and click the freeze button on the toolbar
D. Right click the column and select freeze columns from the shortcut menu
Answer
D. Right click the column and select freeze columns from the shortcut menu
71. Within Table Datasheet view, how can you display associated records from another table?
A. Click the expand indicator (+) next to a record
B. Double click the record.
C. Apply the filter by form command
D. None of the above
Answer
A. Click the expand indicator (+) next to a record
72. Which of the following is not a command to find specific word or phrases in a database?
A. Click the find button on the toolbar
B. Click the find button on the record navigation button area
C. Press Ctrl+F
D. Select Edit>Find from the menu.
Answer
B. Click the find button on the record navigation button area
73. One of the type libraries that you can use to programmatically connect to Microsoft Access data is
A. Collaborative Data Objects
B. ActiveX Data Objects
C. Dynamic Data Interfaces
D. None of the above
Answer
B. ActiveX Data Objects
74. The data in a Pivot Table report is categorized using
A. Column headings
B. Items from the Pivot Table field list
C. Header rows
D. All of above
Answer
B. Items from the Pivot Table field list
75. Records are deleted using
A. DELETE command followed by pack
B. DELETE command without pack
C. DELETE command followed by zap
D. DELETE command without zap
Answer
A. DELETE command followed by pack
76. You can enter data in a table in
A. design view
B. datasheet view
C. format view
D. None of the above
Answer
C. format view
77. Creating a data file means
A. Designing base and defining the structure of the database
B. Getting the information about database
C. Selecting data from database
D. Deleting data from database
Answer
A. Designing base and defining the structure of the database
78. In a large DBMS
A. each user can “see” only a small part of the entire database
B. each user can access every subschema
C. each subschema contains every field in the logical schema
D. none of the above is true
Answer
A. each user can “see” only a small part of the entire database
79. You want to keep track of addresses, phone numbers, parent/guardian names as well as class attendance, average and grades. Every so often you want to send reports home that select failing grades and excessive absences. The following of the Microsoft Office suit used in this course is best suited for this kind of information
A. Excel
B. PowerPoint
C. Access
D. Word
Answer
C. Access
80. Each individual data items of record is called a
A. Field
B. Data type
C. Comment
D. All of the above
Answer
B. Data type
