The auto shapes tool provides you with

A. Fancy text to place on your slide

B. Commonly found shapes*

C. Any shape you want to add on a slide

D. Clip art that is related to your presentation

E. Insert, new slide

 

Which of the following should e used when you want to add a slide to an existing presentation?

A. File, add a new slide

B. Insert, new slide*

C. File, open

D. File, new

E. Any shape you want to add on a slide

 

MS Dbase Access

110. This data type allows alphanumeric characters and special symbols.

A. text*

B. memo

C. auto number

D. none of the above

E. record

 

111. Query design window has two parts. The upper part shows

A. Name of fields, field type and size

B. Tables with fields and relationships between tables*

C. Criteria

D. Sorting check boxes

E. Edit relationship dialog box appears

 

112. In a database table, the category of information is called ____________

A. tuple

B. field*

C. record

D. All of above

E. Memo

 

113. To create a new table, in which method you don’t need to specify the field type and size?

A. Create table in Design View

B. Create Table using wizard

C. Create Table by Entering data*

D. All of above

E. Create table in Entering data

 

114. Which of the following is not a database object?

A. Tables

B. Queries

C. Relationships*

D. Reports

E. All of above

 

115. The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables

A. relationship*

B. Join

C. Query

D. None of these

E. Queries

 

116. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?

A. Home Tab

B. Create Tab

C. External Data Tab

D. Database Tab*

E. Between Tab

 

117. This is the stage in database design where one gathers and lists all the necessary fields for the database project.

A. data definition*

B. data refinement

C. establishing relationship

D. none of the above

E. none of above

 

118. The two form layout types will display multiple records at one time are tabular and___

A. columnar

B. justified*

C. date sheet

D. pivot table

E. field name

 

119. The size of a field with Number data type can not be

A. 2

B. 4

C. 8

D. 16*

E. 12

 

120. A small button with three dots usually displayed at the right of field properties box

A. Make button

B. Expression button

C. Build button*

D. None of above

E. None the of above

 

121. The size of Yes No field is always

A. 1 bit*

B. 1 byte

C. 1 character

D. 1 GB

E. 1MB

 

122. This key uniquely identifies each record

A. primary key*

B. key record

C. unique key

D. field name

E. build button

 

123. The command center of access file that appears when you create or open the MS Access database file.

A. Database Window*

B. Query Window

C. Design View Window

D. Switchboard

E. Relationships

 

124. To duplicate a controls formatting you can use___

A. Manager

B. Wizard

C. Painter*

D. Control

E. Currency

 

125. Which field type will you select when creating a new table if you require to enter long text in that field?

A. Text

B. Memo*

C. Currency

D. Hyperlink

E. Manager

 

126. This 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 the above

E. None of above

 

127. In table design view, which key can be used to switch between the field names and properties panels?

A. F3

B. F4

C. F5

D. F6*

E. F7

 

128. Which of the following is NOT a type of Microsoft Access database object?

A. Table

B. Form

C. Worksheets*

D. Modules

E. Hyperlink

 

129. Which of the field has width 8 bytes?

A. Memo

B. Number

C. Date/Time*

D. Hyperlink

E. Worksheets

 

130. Which of the following database object hold data?

A. Forms

B. Reports

C. Queries

D. Tables*

E. Number

 

131. 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

E. Worksheets

 

132. The expression builder is an access tool that controls an expression___ for entering an expression

A. Table

B. Box*

C. Cell

D. Palette

E. Memo

 

133. A __________ enables you to view data from a table based on a specific criterion

A. Form

B. Query*

C. Macro

D. Report

E. Table

 

134. Which of the following database object produces the final result to present?

A. Forms

B. Reports*

C. Queries

D. Tables

E. Macros

 

135. A __ name must be unique within a database

A. Table*

B. Field

C. Record

D. Character

E. Query

 

136. It is an association established between common fields of two tables.

A. line

B. relationship*

C. primary key

D. records

E. Character

 

137. When entering field name, how many characters you can type in maximum?

A. 60

B. 64*

C. 68

D. 62

E. Any number of character

 

138. It is a database object to view, change, and analyze data in different ways

A. query*

B. form

C. report

D. None of the above

E. Hyperlink

 

139. To achieve AND effect when you are entering criteria in a query design window

A. write criteria values vertically one in a row

B. write criteria values horizontally*

C. Write criteria values in same field separated with AND

D. Write criteria values in same field separated with &

E. Huge collection of MCQ questions

 

140. What are the columns in a Microsoft Access table called?

A. Rows

B. Records

C. Fields*

D. Columns

E. Hyperlinks

 

141. Unlike text data type, this can store up to maximum of 65 535 characters.

A. memo*

B. data/time

C. number

D. All of above

E. Both of above

 

142. Which field type can store photos?

A. Hyperlink

B. OLE*

C. Both of these can be used

D. Access tables can’t store photos

E. Number

 

143. It is most common type of query. It retrieves records from one or more tables and then displays the

A. Parameter

B. Select*

C. Crosstab

D. All of above

E. None of the above

 

144. It is a query that when run displays its own dialog box prompting you for information, such as

A. Select

B. Crosstab

C. Parameter*

D. Append

E. All of above

 

145. What is the maximum length a text field can be?

A. 120

B. 255*

C. 265

D. 75

E. 155

 

146. Microsoft Access is a

A. RDBMS*

B. OODBMS

C. ORDBMS

D. Network database model

E. Pivot Chart View

 

147. Which of the following store command to retrieve data from database?

A. Forms

B. Reports

C. Queries*

D. Tables

E. Parameter

 

148. If you write criteria values vertically (one in a row) it will mean

A. OR conditions*

B. AND conditions

C. NOT condition

D. None of above

E. Both of above

 

149. The key uniquely identifies each record in a table.

A. primary key*

B. key word

C. filed name

D. All of above

E. Both of above

 

150. What do you mean by one to many relationship between Student and Class table?

A. One student can have many classes*

B. One class may have many student

C. Many classes may have many students

D. Many students may have many classes

E. Create Table using wizard