1. Microsoft Access provides visual environment for design of _______.
(a) tables
(b) reports
(c) forms
(d) all of them
Ans. d
2. By default, new table is displayed in ______view.
(a) Datasheet View
(b) Design View
(c) Report View
(d) Form View
Ans. a
3. _______ is an alternate to datasheet view for design of table in MS Access.
(a) Datasheet View
(b) Design View
(c) Report View
(d) Form View
Ans. b
4. An ordinary form for data entry in MS Access tables may be created using______ menu.
(a) Create>Form
(b) Create>Split Form
(c) Create>Multiple Items
(d) Create>Blank Form
Ans. a
5. In MS Access, a form with data records at one half and entry format at the other half may be created using______ menu.
(a) Create>Form
(b) Create>Split Form
(c) Create>Multiple Items
(d) Create>Blank Form
Ans. b
6. In MS Access, multiple rows of data may be created using______ menu.
(a) Create>Form
(b) Create>Split Form
(c) Create>Multiple Items
(d) Create>Blank Form Ans. c
7. In MS Access, blank form may be created using______ menu.
(a) Create>Form
(b) Create>Split Form
(c) Create>Multiple Items
(d) Create>Blank Form
Ans. d
8. In MS Access, form may created through a wizard using______ menu.
(a) Create>More Forms>Form Wizard
(b) Create>Split Form
(c) Create>Multiple Items
(d) Create>Blank Form Ans. a
9. In MS Access, data sheet may be created using _______ menu.
(a) Create>More Forms>Form Wizard
(b) Create>More Forms>Data Sheet
(c) Create>More Forms>Modal Dialog
(d) Create>Blank Form
Ans. b
10. In MS Access, form dialog may be created using_______ menu.
(a) Create>More Forms>Form Wizard
(b) Create>More Forms>Data Sheet
(c) Create>More Forms>Modal Dialog
(d) Create>Blank Form
Ans. c
11. In MS Access, form may be manually designed through available components (like textfield, datapicker, combo-box, etc.) using ______menu.
(a) Create>More Forms>Form Wizard
(b) Create>More Forms>Data Sheet
(c) Create>More Forms>Modal Dialog
(d) Create>Form Design
Ans. d
12. In MS Access, default report may be created using ______ menu.
(a) Create>Report
(b) Create>Blank Report
(c) Create>Report Wizard
(d) Create>Report Design Ans. a
13. In MS Access, blank report may be created using_______ menu.
(a) Create>Report
(b) Create>Blank Report
(c) Create>Report Wizard
(d) Create>Report Design
Ans. b
14. In MS Access, report may be created through wizard using_______ menu.
(a) Create>Report
(b) Create>Blank Report
(c) Create>Report Wizard
(d) Create>Report Design
Ans. c
15. In MS Access, report may be designed using components like combobox, text field, text area, list, etc. using _______menu.
(a) Create>Report
(b) Create>Blank Report
(c) Create>Report Wizard
(d) Create>Report Design
Ans. d
16. In MS Access, macro may be recorded to carry out different actions using______ menu.
(a) Create>Report
(b) Create>Blank Report
(c) Create>Report Wizard
(d) Create>Macro
Ans. d
17. In MS Access, a macro can be activated by pressing,_______ button.
(a) Form
(b) Report
(c) Run
(d) Table
Ans. c
18. In MS Access, macros can automate__________ .
(a) program flow/ data entry
(b) data import/ data export
(c) filter/ query/ search
(d) all of them
Ans. d
19. What is the maximum length of the field name in Access?
A. 16 characters
B. 32 characters
C. 64 characters
D. 128 characters
Ans. c
20.Which view is used to arrange table data in different graphical layouts to summarize data?
A. Table view
B. Design view
C. Data sheet view
D. Pivot chart view
Ans. d
21.Which view allows to modify table‟s structure in Access?
A. Design view
B. Datasheet view
C. Pivot table view
D. Pivot shart view
Ans. A
22.Which object stores information about related data?
A. Document
B. Table
C. Page
D. Screen
Ans. b
23.Which key stoke moves the active cell towards left in Access table?
A. F2
B. F5
C. Tab
D. Shift + Tab
Ans. d
24.Which combination of key zooms the content of active cell in Access table?
A. Ctrl + F2
B. Ctrl + F5
C. Shift + F2
D. Shift + F5
Ans. c
25.Which technique prevents invalid data being saved in Access table?
A. Index
B. Filter
C. Validation rule
D. Input mark
Ans. c
26. Which validation rule accepts only a - z letters for fields in Access?
A. Is null or NOT like “*[! a - z]*”
B. Is null or NOT like “*[a - z ]*”
C. Is null or NOT like “*![a - z]*”
D. Is null or NOT like “[! a - z]”
Ans. a
27.Which validation rule allows only 0 - 9 for fields in Access?
A. Is Null or Not Like “*[ ! 0 - 9 ]*”
B. Is Null or Not Like “[! 0 - 9]”
C. Is Null or Not Like “*[0 - 9]*”
D. Is Null or Not Like “*[!0-9]*”
Ans. d
28.Which validation rule allows only positive numbers for fields in?
A. Is Null or > = 0
B. Is Null or Positive
C. Is Null or < 0
D. Is Null or = “+”
Ans. a
29.What is allowed the input mark symbol # in Access?
A. Letter or digit
B. Letter A through Z
C. A digit 0 - 9 with +/- sign
D. A digit 0 - 9 without +/- sign
Ans. c
30.Which validation rule allows exactly digits for number fields in Access?
A. Is Null or Between 100000 and 99999
B. Is Null or Like “????”
C. Is Null or >= 0 AND< = 99999
D. Is Null or < = 99999
Ans. c
31.What is the output when the data „1678.95‟ is set to the number format „###0.00‟ in Access?
A. 1670.00
B. 1670.95
C. 1678.00
D. 1678.95
Ans. d
32.Which of the following is a valid time format is Access?
A. hh:mm:ss AM/PM
B. hh.mm.ss AM/PM
C. hh-mm-ss AM/PM
D. hh/mm/ss AM/PM
Ans. a
33.Write the output when the data „Primary Key‟ is set to the text < in Access?
A. Primary key
B. primary key
C. PRIMARY KEY
D. Primary Key
Ans. b
34.What is the output when the data “FOREIGN key‟ is set to the text format > in Access?
A. foreign key
B. FOREIGN KEY
C. Foreign Key
D. Foreign key
Ans. b
35. What is the reason for not accepting zero in the fields of Access tables?
A. Fields is set with is Null or > 0
B. Fields is set with is Null or < = 0
C. Fields is set with is Null or! [0]
D. Fields is set with is Null or like “?”
Ans. a
36. Which field type will you select when you need to enter long text in the field?
a) Text
b) z memo
c) currency
d) hyperlink
Ans. b
37. The expression builder is access tool that controls expression ____ for entering expression
a) Table
b) Box
c) Cell
d) Palette
Ans. b
38. Which of the following is not type of MS Access database object?
a) Table
b) Form
c) Worksheets
d) Modules
Ans. c
39. In which method we don‟t need to specify the field type and size while creating a new table?
a) Design view
b) While using Wizard
c) Create Table by entering Data
d) All of these
Ans. c
40.Th size of yes/no field is always ______ .
a) 1 Bit
b) 1 byte
c) 1 character
d) 1 kb
Ans. a
41. The size of a field with number data type can not be ____
a) 2
b) 4
c) 8
d) 16
Ans. D
42. What does the show check box in query design window indicate?
a) It indicates whether the field is to be used or not.
b) It indicates whether the field is to be displayed in query result or not
c) It indicates whether the field names to be displayed in query result or not.
d) It indicates whether the field is to be used for grouping result or not.
Ans. b
43. Which of the following option creates a Drop Down list of values ?
a) Ole Object
b) Hyperlink
c) Memo
d) Lookup wizard
Ans. d
44. What is a form that we can create in MS Access ?
a) it is used to take printout of a form from Access Tables.
b) It is an input screen for viewing and entering data.
c) It is used for storing special data other than text.
d) It is optional. We can use report instead of Form
Ans. b
45. What cascade delete option is used for?
a) It is used to delete all the records of all tables in a database.
b) It repeats the recent delete operation to all the records of current table.
c) It ensure that all the related records will be deleted automatically when the record from parent table is deleted.
d) It is used to delete all the records of related tables in a database.
Ans. c
46. The ______ button on the tool box display data from a related table.
a) Sub form sub report
b) Relationships
c) select objects
d) More controls
Ans. a
47. The command center of MS access file that appears when we create or open the MS Access database file
a) Database window
b) Query window
c) Design view window
d) switchboard
Ans. a
48. While creating relationship using mouse, how the mouse pointer looks like?
a) A thick plus sign
b) A thin plus sign
c) An outlined rectangle
d) Arrow with plus sign
Ans. c
49. The columns is a Microsoft access table are also called ______.
a) Rows
b) Records
c) Field
d) Columns
Ans. C
50. how can you define a field so that when entering data #### is displayed?
a) Input mask
b) Validation rule
c) Indexed
d) Ime mode
Ans. a
51. In the context of Microsoft access, which of the following statement is true?
a) Reports are used to retrieve and calculate data from tables.
b) Queries can be printed and presented as the information
c) Queries can include calculated fields that do not exist in table
d) Reports and forms are similar but forms are use to print but reports to display on screen only
Ans. c
52. The upper part of the query design window in MS Access has two parts shows ______.
a) Fields name with field size
b) Field name with relationships
c) Fields and Criteria
d) Sorting Options
Ans. b
53. To define AND condition while entering criteria in a query design window we write ____
a) Criteria values vertically one in a row
b) Criteria values horizontally
c) Write criteria values separated by AND
d) Write criteria values using & (anchor and) sign
Ans. b
54. Which feature is used to duplicate a control‟s formatting ?
a) Manager
b) Wizard
c) Painter
d) Control
Ans. c
55. Which of the following is not a type of relationship that can be applied in Access database?
a) One to one
b) One to many
c) Many to many
d) All of these
Ans. d
56. While creating relationship, what happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
a) A relationship is created
b) Edit relationship dialog box appears
c) A connector symbol is created
d) A connecting line is visible
Ans. b
57. What is the role of Cascade update option ?
a) It says do not change the value in the primary key field if that record has related records in another table
b) It means change all the related records in child tables if the record in parent table is changed
c) Both A and B
d) None of these
Ans. c
58. How many ways to open a table in MS Access ?
a) 3
b) 2
c) 1
d) 4
Ans. a
59. Which of the following is a method to create a new table in MS Access?
a) Using Design View
b) Create Table Wizard
c) Directly Entering Data
d) All of these
Ans. d
60. If you write criteria values one in a row in query design window, that means you are specifying
a) Or Conditions
b) AND Conditions
c) NOT Conditions
d) ALL conditions
Ans. a
61. How can we create a query in Microsoft Access?
a) Drag and drop fields
b) Type the SQL
c) Use Query wizard
d) All of these
Ans. d
62. Which option allows us to build a new table by entering data directly into a tabular grid?
a) Datasheet view
b) Design view
c) Linked Table d) Grid view
Ans. a
63. What is the shortcut key to switch between the field names and properties panels in table design view?
a) F3 key
b) F4 key
c) F5 key
d) F6 key
Ans. d
64. Which field type can store photos ?
a) Hyperlink
b) OLE object
c) Both can be used
d) it is not possible
Ans. b
65. Which data type should we use if we are planning to store a couple of paragraph or detailed description in a field ?
a) Text
b) Para
c) Memo
d) Desc
Ans. c
66. Which of the following database object hold data?
a) Forms
b) Reports
c) Queries
d) Tables
Ans. d
67. When creating a new table which method can be used to choose fields from standard databases and tables
a) create table in design view
b) create table using wizard
c) Create table by entering
d) none of these
Ans. b
68. Which one of these is the most common type of query that retrieves records from one or more tables and then displays the result in tabular form?
a) Tabular Query
b) Crosstab query
c) Select query
d) pivot query
Ans. c
69. Microsoft Access is a _____ kind of application ?
a) RDBMS
b) OODBMS
c) ORDBMS
d) Network Database Model
Ans. a
70. Queries in MS Access can be used _____
a) To view data
b) As source for forms
c) As source for Reports
d) All of these
Ans. d
71. The small button with three dots displayed at the right of field properties box is called :
a) Make button
b) Expression Button
c) Built Button
d) None of these
Ans. c
72. Which of the following shows the final result in a presentable way ?
a) Forms
b) Reports
c) Queries
d) Tables
Ans. b
73. In MS Access, how can we create relationship between two tables in the GUI?
a) Drag the foreign key of a table into the primary key of another table
b) Drag any field from parent table and drop on child table
c) Drag the primary key of a table into foreign key of another table
d) Any of these can be done to create relationship
Ans. c
74. Which of the following store command to gather data from database ?
a) Forms
b) Reports
c) Queries
d) Tables
Ans. c
75. A search value in SQL query can be a specific value or it can be _____
a) Logical Operator
b) Relationship
c) Wild card Character
d) Comparison operation
Ans. c
76. What is the default and maximum size of text field in MS Access ?
a) 50 and 255 characters
b) 8 and 1 Gb
c) 266 and 64000 characters
d) 8KB and 1.5 MB
Ans. a
77. How can we remove a relationship defined between two tables?
a) From edit menu ( by choosing delete relationship)
b) Select the relationship line and press delete
c) Choose Delete option from relationship menu
d) Choose remove option from relationship menu
Ans. b
78. In MS Access to open new database press
a) Ctrl + N
b) Ctrl + o
c) Alt + F4
d) None of these
Ans. a
79. In MS Access to open a combo box
a) F4 or Alt + Down Arrow
b) Down Arrow
c) Page down
d) F9
Ans. a
80. In MS Access to open an existing database press
a) Ctrl + N
b) Ctrl + o
c) Alt + F4
d) None of these
Ans. b
81. In MS Access to refresh the contents of a lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box
a) F4 or Alt + Down Arrow
b) Down Arrow
c) Page down
d) F9
Ans. d
82. Press the following keys in MS Access to cancel print preview or layout preview
a) Ctrl + p
b) P or ctrl + P
c) ctrl + s
d) C or Esc
Ans. d
83. Press the following keys in MS Access to Print the current or selected object
a) Ctrl + P
b) P or Ctrl + P
c) ctrl + s
d) C or Esc
Ans. a
84. In MS Access press Alt + F11 to
a) Display the control menu
b) Display the shortcut menu
c) Close the active window
d) None of these
Ans. d
85. How can you display the relationship in a database?
a) Select view > Relationship from the menu
b) Click the relationship button on the toolbar
c) Select Edit > Relationship from the menu
d) All of these
Ans. b
86. How can you display Pivot table report summary data in a currency format ?
a) Use custom calculation
b) Type in the currency symbol
c) Modify the field settings
d) None of these
Ans. c
87. A query summarizes information in a grid, organized by regions and months. Which type of query is this?
a) A cross tab query
b) An update query
c) A parameter query
d) An active query
Ans. a
88. The filters by selection feature allows you to filter
a) Those records that match an entity in a field
b) Records based on a criterion you specify
c) Records that meet any of several criteria you specify
d) All of these
Ans. a
89. How can you display sales grouped by country, region, and salesperson, all at the same time?
a) Use the sort descending command
b) Use the pivot table view command
c) Use the fine command on specified group
d) All of these
Ans. b
90. What is the memo data type field used for?
a) To add table
b) To store objects created in other programs
c) For long text entries
d) For shout text entries of no more than 255 characters
Ans. c
91. The checking operation performed on input data is called the
a) Validation of data
b) Verification of data
c) Cross check
d) Control of data
Ans. a
92. What is the purpose of the description column in Table Design view?
a) To define the data type applied to each field within the table
b) To describe the data that should be entered in each field
c) To enter lookup data that the field should refer to
d) None of these
Ans. B
93. What is the purpose to a sub datasheet?
a) To provide a hierarchical view of related tables or queries in a single window
b) To display grouped data in a report
c) To display summarized data.
d) All of these
Ans. a
94. You can keep the sum ([sales]) to calculate the totals for each month in
a) The report footer section
b) the page footer section
c) the month group footer section
d) the summary section
Ans. c
95. The type of query extract the data and put them into separate table
a) A parameter query
b) A make-table query
c) An update query
d) A crosstab query
Ans. b
96. The procedure for selecting multiple controls on a report
a) Hold down the shift key as you click each object that you want to select
b) If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler above or to the left of the controls
c) Hold down the Ctrl key as you click each object that you want to select
d) All of these
Ans. a
97. The following database object can you import from one MS-Access database to another?
a) Queries
b) Tables
c) Forms
d) All of these
Ans. d
98. What field type is used to store picture in a table?
a) Memo
b) OLE c) Hyperlink
d) None Ans. b
99. Queries design window has two parts. The upper part shows
a) Name of fields, field type and size
b) Sorting check boxes
c) Tables with fields and relationships between tables
d) None of these
Ans. c
100. In a database table, the category of information is called _____
a) record
b) Tuple
c) field
d) None of these
Ans. c
101. Which of the following is not a database object?
a) Form
b) Tables
c) Reports
d) Relationships
Ans. d
102. This is the stage in database design where one gathers and lists all the necessary fields for the database project.
a) Data dictionary
b) data refinement
c) data definition
d) none of these
Ans. c
103. This key uniquely identifies each record
a) key record
b) composite key
c) foreign key
d) primary key
Ans. d
104. Which of the field has width 8 bytes?
a) Currency
b) memo
c) hyperlink
d) date/time
Ans. d
105. Which of the following are view to display a table in Access?
a) Datasheet view
b) Design view
c) Both A and B
d) None of these
Ans. c
106. A _____ enables you to view data from a table based on a specific criterion
a) Query
b) Report
c) Form
d) All of these
Ans. a
107. Which of the following database object produces the final result to present ?
a) Table
b) Reports
c) Queries
d) None of these
Ans. b
108. The database language that allows you to access or maintain data in a database
a) DML
b) DCL
c) DDL
d) TCL
Ans. a
109. What are the columns in Microsoft Access table called?
a) Table
b) Reports
c) Queries
d) fields
Ans. d
110. The ______ operator will cause a report to be selected only if two or more conditions are satisfied
a) NOT
b) XOR
c) OR
d) AND
Ans. d
111. What is the maximum length a text field can be?
a) 255
b) 256
c) 257
d) 355 Ans. a
112. DCL provide commands to perform actions like
a) Change the structure of tables
b) Authorizing access and other control over database
c) Insert, update or delete records and data values
d) All of these
Ans. b
113. Which of the following store command to retrieve data from database?
a) Queries
b) Forms
c) Records
d) Reports
Ans. a
114. A part of database that stores only one type of data is
a) Record
b) Table
c) Field
d) Report
Ans. c
115. A database can be best described as
a) Useful presentation of data
b) Organized collection of data
c) Graphical representation of data
d) None of these
Ans. b
116. Collection of related records in a database is known as
a) Record
b) Table
c) Field
d) Report
Ans. b
117. The complete information about an entity in a database is called
a) Record
b) Table
c) Field
d) Report
Ans. a
118. The task of arranging data in order is called
a) Ordering
b) Searching
c) Sorting
d) Ascending
Ans. c
119. A composite key is
a) The primary key with Auto Number as the field type
b) Is a foreign key that uniquely identifies records
c) Made up of two or more fields to uniquely identify records
d) None of these
Ans. c
120. An organized collection of logically related data is known as
a) Data base
b) Meta data
c) Information
d) Information
Ans. a
121. HSAM stands for______
a) Hierarchic standard and method
b) Hierarchic Sequential and method
c) Hierarchic standard Access method
d) Hierarchic Sequential Access Method
Ans. d
122. In a database, what does each row represent ?
a) Field
b) Database
c) Record
d) All of these
Ans. c
123. What do you call a primary key field included in another table ?
a) Child key
b) Composite key
c) Parent key
d) Foreign key
Ans. d
124.Which data type is better to use for storing the price of an item?
a) Number
b) Text
c) Currency
d) Hyperlink
Ans. c
125. The basic elements of a form or a report are called :
a) Windows
b) Controls
c) Objects
d) Table
Ans. b
126. Which of the following data type is used to store logical value in MS Access?
a) Yes/No
b) On/ Off
c) True/False
d) All of these
Ans. a
127. In MS Access “Lookup Wizard” is used to
a) To select value from another table
b) To select values from Excel sheet
c) To select from previous values
d) None of the Above
Ans. a
128. Which of the following is use to get data from user?
a) Query
b) Form
c) Report
d) Table
Ans. b
129. Validation Rule in a field will
a) Defines the appearance for the text
b) Displays the value in specified format when user leave the field
c) Checks the value entered when user leaves the field
d) None of the above
Ans. c
130. Query can be used to select data from
a) single table
b) multiple table
c) Both single & Multiple tables
d) None of these
Ans. c
131. Data can be import into Access Database from
a) Notepad Files
b) Power point files
c) Word files d) Excel files
Ans. d
132. Queries can be created in Access by
a) Using Query Wizard
b) Typing Queries in SQL View
c) Drag and Drop fields on Query Builder
d) All of these
Ans. d
133. Which of the following is the default join between two records?
a) Inner join
b) Outer join
c) Right outer join
d) None of these
Ans. a
134. Any report, including a basic report, can be modified in ______ .
a) Print Preview
b) Report view
c) Layout view
d) All of these
Ans. c
135. Using he keyword _____ will return records is which the field value equals a defined text.
a) Like
b) Between
c) Is Null
d) Equal
Ans. a
136. In a query, using the keyword ______ will return records in which the field value is between two numbers.
a) Like
b) Between
c) Is Null
d) Equal
Ans. b
137. Database is also called as ______
a) DBMS
b) RDMS
c) DDMS
d) None of these
Ans. b
138.In Access data is stored in _____
a) Rows
b) Columns
c) Both A and B
d) None of these
Ans. c
139. The organization of a table is _______.
a) Logical
b) Physical
c) Both A and B
d) None of these
Ans. a
140. Access contains objects like _____
a) Tables
b) Forms
c) Queries
d) All of these
Ans. d
141. Popular Databases are _____
a) Access
b) FoxPro
c) Clipper
d) All of these
Ans. d
142. In RDMS, a table is comparable to a database file but more_____
a) Lonely structured
b) Highly Structured
c) Non structured
d) None of these
Ans. b
143. Each record in a table contain _____ keys.
a) Unique
b) Primary keys
c) Both A and B
d) None of these
Ans. a
144. OLE data object data type can store ______
a) Video clips
b) Pictures
c) Graph
d) All of these
Ans. d
145. Querying a database is a method of ______
a) Retrieving specific data
b) Displaying specific data
c) Both A and B
d) None of these
Ans. c
146. Sorting can be done in _______ order.
a) Ascending
b) Descending
c) Both A and B
d) None of these
Ans. c
147. Reports are required for presenting information on _______
a) Paper
b) On screen
c) Both A and B
d) None of these
Ans. c
148. Tree structured are used to stored data in
a) Network model
b) Relational model
c) Hierarchical model
d) File base system
Ans. a
149. The rule that a value of a foreign key must appear as a value of some specific table is called
a) Referential constraint
b) index
c) Integrity constraint
d) Functional dependency
Ans. a
150. ______ view permits selection of data types, default values and constraints for each column.
(a) Datasheet
(b) Design
(c) Report
(d) Form
Ans. b
151. A relation is in ______ if an attribute of a composite key is dependent on an attribute of other composite key.
a) 2NF
b) 3NF
c) BCNF
d) 1NF
Ans. b
152. What is data integrity?
a) It is the data contained in database that is non redundant
b) It is the data contained in database that is accurate and consistent
c) it is the data contained in database that is secured.
d) It is the data contained in database that is shared.
Ans. b
153. Which of the following is not a database application?
a) dBase
b) Flash
c) FoxPro
d) Access
Ans. b
154. Which of the following is not a logical database structure?
a) Chain
b) Network
c) Tree
d) Relational
Ans. a
155. A ____ is a unit of information in a ______
a) record, field
b) field, record
c) data source, field
d) record, data source
Ans. b
156. Which type of field is increment automatically?
a) Auto Elevate
b) Auto Number
c) Auto Increment
d) Auto Value
Ans. b
157. Which will display values in drop down box from another table while entering data….
a) Query wizard
b) Look up wizard
c) Form Wizard
d) Report wizard
Ans. b
158. A primary key in any table has the following properties
a) Not Null
b) No Duplicates
c) Both A and B
d) None of these
Ans. c
159. What is the file extension of MS Access 2003?
a) .mdb
b) .mcb
c) .acc
d) .mcd
Ans. a
160. Which option allows you to build a new table by entering data directly into the datasheet.
a) Datasheet view
b) design view
c) link table
d) None of these
Ans. a
161. Which key stoke is used to move the active cell towards right, in access table? A Ctrl + Tab B Alt + Tab C Tab D Shift + Tab Ans. c 162. Refresh button can be found in….
a) Create Tab
b) External Data
c) Home Tab
d) Database Tool
Ans. c
163. How can you protect your data with password?
a) From Macro
b) From database tool
c) From SQL server
d) From Datasheet tab
Ans. b
164. Which will help to search data from database?
a) Queries
b) Froms
c) Reports
d) Macros
Ans. a
165. Which combination of key allows user to move to the first field in the first record in Access table?
A. Ctrl + Tab
B. Shift +Tab
C. Shift + Home
D. Ctrl + Home
Ans. d
166. Which command quickly locates the data is Access table?
A. Find
B. Locate
C. Search
D. Edit
Ans. a
167. OODBMS stands for_______.
a) object oriented database management system.
b) order data base management system
c) order base management system
d) office data base management system
Ans. a
168. MS Access creates files are stored with______ extension.
(a) .docx
(b) .xlsx
(c) .accdb
(d) .pptx
Ans. b
169. New database created in MS Access has got a default table named________ .
(a) Table1
(b) Database1
(c) Column1
(d) Row1
Ans. a
170. What can be created to help easy data entry in MS Access tables.
(a) Form
(b) Report
(c) database
(d) spreadsheet
Ans. a
171. By default, first column of an MS Access table is named _______ and it has auto increment property.
(a) NAME
(b) DATE
(c) NULL
(d) ID
Ans. d
172. How can you edit a relationship already established between two tables?
a) Right click the relationship line and choose edit relationship
b) Double click the relationship line
c) Both the above
d) None of the above
Ans. c
173. Which of the following database object hold data?
a) Reports
b) Tables
c) Forms
d) All of these
Ans. b
174. Full form of DBMS
a) Data base management system
b) Document Base Management System
c) Digital Base Management System
d) None of these
Ans. a
No comments:
Post a Comment