121. A group of characters used to identiry a given low level instruction is
A. File
B. Record
C. Key field
D. Label
Answer
D. Label
122. One or more characters used to identify a data field in a computer program is
A. File name
B. Database
C. Label
D. Group
Answer
C. Label
123. In Form view, which command displays records alphabetically?
A. Find
B. Advanced Filter/Sort
C. Sort
D. All of the above
Answer
C. Sort
124. Where do report and forms get their information form?
A. Forms
B. Modules
C. Tables
D. Queries
Answer
C. Tables
125. The number of logical records in a physical record is
A. group
B. blocking factor
C. sector
D. field
Answer
D. field
126. A top to bottom relationship among the items in a database is established by a
A. Hierarchical schema
B. Network Schema
C. Relational schema
D. All of the above
Answer
A. Hierarchical schema
127. A command that lets you cange one or morefields in a record is
A. Insert
B. Modify
C. Look up
D. All of the above
Answer
B. Modify
128. A logical schema
A. Is the entire database
B. Is a standard way of organizing information into accessible parts
C. Describes how data is actually stored on disk
D. All of the above
Answer
B. Is a standard way of organizing information into accessible parts
129. What is the purpose of the page field on a pivot table report?
A. It creates a new page for each type of data
B. It allows the data within the the Pivot Table report to be filtered
C. It displays a title for the Pivot Table report
D. None of the above
Answer
B. It allows the data within the the Pivot Table report to be filtered
130. What does the Special Effect button on the formatting toolbar do?
A. It lets you add animation to your forms and reports to make them more entertaining and amusing
B. It lets you select a transitional effect for how a form opens and closes.
C. It applies a 30d effect to a selected control
D. None of these
Answer
C. It applies a 30d effect to a selected control
131. Pivot Table report data must meet which of the following criteria?
A. It must be in tabular form, have unique column labels, and each row must represent a unique piece of data
B. Any dates should be formatted with the data format and blank rows or columns should be removed
C. It must be in tabular form, have unique column lagels, and all rows must be sorted
D. Both (A) and (B)
Answer
D. Both (A) and (B)
132. Customers, Orders. What’s their best relationship?
A. Many-to-many
B. One-to-one
C. One-to-many
D. All of the above
Answer
C. One-to-many
133. Which control does access use to link data access page components to access data?
A. Microsoft Dynamic Data Control
B. Microsoft Data Connection Control
C. Microsoft Office Data Source Control
D. None of the above
Answer
C. Microsoft Office Data Source Control
134. Which program do you use to edit code for data access pages?
A. Microsoft script editor
B. Microsoft code editor
C. Microsoft data access pages editor
D. None of above
Answer
A. Microsoft script editor
135. The way a particular application views thedata from the database that the applicaton uses is a
A. Module
B. Relational model
C. Schema
D. Sub-schema
Answer
D. Sub-schema
136. Which of the following is a database management system?
A. Ms-Word
B. Lotus 1-2-3
C. Oracle
D. None of above
Answer
C. Oracle
137. What is the corresponding text for the <#1/1/ 95# validation rule setting?
A. Neter a value less or more than 1,195
B. Value must be less than 95 characters
C. Enter a date before 1995
D. All of above
Answer
A. Neter a value less or more than 1,195
138. What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library’s available objects and members?
A. Object Viewer
B. Object Browser
C. Type Library Spy
D. None of above
Answer
B. Object Browser
139. A computer language for informing the DBMS regarding the data structure used is
A. PASCAL
B. DDL
C. PROLOG
D. FORTRAN
Answer
B. DDL
140. Which of the following is not a data type ?
A. Picture/graphic
B. Data/time
C. Texst
D. Number
Answer
A. Picture/graphic
141. The executive responsible for the data processing function in an organization is
A. PM
B. DBMS
C. DP
D. DPM
Answer
B. DBMS
142. Which of the following is NOT a type of Microsoft Access database object?
A. Queries
B. Workbooks
C. Forms
D. Tables
Answer
B. Workbooks
143. A file containing relatively permanent data is
A. Random file
B. Transaction file
C. Master file
D. Sequential file
Answer
C. Master file
144. The complete picture of data stored in database is known as
A. Record
B. Scheme
C. System flowchart
D. DBMS
Answer
B. Scheme
145. A subset of characters within a data field is known as
A. Record
B. File
C. Data string
D. Byte
Answer
C. Data string
146. Data items groped together for storage purposes are called a
A. Record
B. Title
C. List
D. string
Answer
A. Record
147. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?
A. Relational
B. Structural
C. Network
D. All of the above
Answer
B. Structural
148. In a relational schema, each tuple is dividedinto fields called
A. Relations
B. Domains
C. Queries
D. All of the above
Answer
B. Domains
149. How do you filter by selection?
A. Right click the field value and select filter by selection from the shortcut menu
B. Find and double click the value on which you want to base the filter
C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu
D. None of the above
Answer
A. Right click the field value and select filter by selection from the shortcut menu
150. What is a fast way to adjust the width of a column?
A. Right click the left side of the column heading
B. Double click the left side of the column heading
C. Double click the right side of the column heading
D. Select tools>adjust column width from the menu
Answer
C. Double click the right side of the column heading
151. What are the columns in a Microsoft Access table called?
A. Rows
B. Fields
C. Cells
D. Records
Answer
B. Fields
152. How do you update Pivot Table report data after changes are made to the source data?
A. Save your changes, close the workbook, and then reopen it.
B. Select the Pivot Table worksheet and press F9 on the keyboard
C. Click the report, and on the Pivot Table toolbar, click the refresh data button
D. All of the above
Answer
C. Click the report, and on the Pivot Table toolbar, click the refresh data button
153. In access, the best types of queries to use for data analysis are:
A. Select querie
B. Parameter queries
C. Action queries
D. All of the above
Answer
A. Select querie
154. How can you add a table to the relationship window?
A. Select Tools>Add table from the menu
B. Select the table from the table list on the toolbar
C. Click the show table button on the toolbar
D. Select Edit>Add table from the menu
Answer
B. Select the table from the table list on the toolbar
155. What is the first step in creating a form or report with the form wizard or report wizard?
A. Selecting the fields that you want to appear in the form or report
B. Selecting the underlying table or query on which you want to base the form or report
C. Reading several screens of mostly useless information and clicking next
D. Selecting how the form or report should be formatted
Answer
B. Selecting the underlying table or query on which you want to base the form or report
156. Which action will optimize your databaseperformance?
A. Set the record set type to Snapshot
B. Use the compact and repair database tool
C. Create a replica of the database
D. All of the above
Answer
B. Use the compact and repair database tool
157. The arranging of data in a logical sequence is called
A. Sorting
B. Classifying
C. Reproducing
D. Summarizing
Answer
A. Sorting
158. If a piece of data is stored in two places in the database, then a
A. Storage space is wasted
B. Changing the data is one spot will cause data inconsistency
C. It can be more easily accessed
D. Both (A) and (B)
Answer
D. Both (A) and (B)
159. A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As
A. Tables
B. Relations
C. Tuple
D. Both (A) and (B)
Answer
D. Both (A) and (B)
