MS ACCESS 25 QUESTION OBJECTIVE

1. What Are The Different Views To Display A Table
 A) Datasheet View
 B) Design View
 C) Pivote Table & Pivot Chart View
 D) All Of Above

2. Which Of The Following Creates A Drop Down List Of Values To Choose From?
 A) Ole Object
 B) Hyperlink
 C) Memo
 D) Lookup Wizard

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

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

5. In A Database Table, The Category Of Information Is Called __________
 A) Tuple
 B) Field
 C) Record
 D) All Of Above

6. This Key Uniquely Identifies Each Record
 A) Primary Key
 B) Key Record
 C) Unique Key
 D) Field Name

7. It Is An Association Established Between Common

 A) Line
 B) Relationship
 C) Primary Key
 D) Records
8. This Is The Stage In Database Design Where One Gathers And List All The Necessary Fields For The Database Project.
 A) Data Definition
 B) Data Refinement
 C) Establishing Relationship
 D) None Of The Above

10. Which Of The Field Has Width 8 Bytes?
 A) Memo
 B) Number
 C) Date/time
 D) Hyperlink

11. Which Of The Following Statement Is True?
 A) Foreign Key Fields Don\'t Allow Duplicate Values
 B) In Primary Key Field You Can Enter Duplicate Value
 C) In An Indexed Field You May Or May Not Enter Duplicate Value    Depending Upon Setting
 D) All Statements Are True

12. Following Is Not A Database Model
 A) Network Database Model
 B) Relational Database Model
 C) Object Oriented Database Model
 D) None

13. Microsoft Access Is A
 A) RDBMS
 B) OODBMS  C) ORDBMS
 D) Network Database Model

14.  Which Of The Following Is A Method To Create A New Table In Ms Access?

 A) Create Table In Design View

 B) Create Table Using Wizard

 C) Create Table By Entering Data

 D) All Of Above

15. 8. 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

16. What Is The Maximum Length A Text Field Can Be?
 A) 120
 B) 255
 C) 265
 D) 75

 17. Which Of The Following Is Not A Database Object?
 A) Tables
 B) Queries
 C) Relationships
 D) Reports

18. A __________ Enables You To View Data From A Table Based On A Specific Criterion
 A) Form
 B) Query
 C) Macro
 D) Report

19. What Are The Columns In A Microsoft Access Table Called?
 A) Rows
 B) Records
 C) Fields
 D) Columns

20. Which Of The Following Is Not A Type Of Microsoft Access Database Object?
 A) Table
 B) Form
 C) Worksheets
 D) Modules

21. When Entering Field Name, How Many Characters You Can Type In Maximum?

 A) 60

 B) 64

 C) 68

 D) Any Number Of Character

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

23. Which Of The Following Is Not A Field Type In Access

 A) Memo

 B) Hyperlink

 C) Ole Object

 D) Lookup Wizard

24. The Size Of A Field With Number Data Type Can Not Be

 A) 2

 B) 4

 C) 8

 D) 16

25. The Size Of Yes No Field Is Always

 A) 1 Bit

 B) 1 Byte

 C) 1 Character

 D) 1 Gb

Answers 1-D, 2-D, 3-A, 4-A, 5-B, 6-A, 7-B, 8-A, 10-C, 11-C, 12-D, 13-A, 14-d, 15---, 16-B, 17-C, 18-B, 19-C, 20-C 21-B, 22-D, 23-D, 24-D, 25-A

ottom:0in;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none'>d. F10

Want your logo in the same position on every slide, automatically? Insert it on the

a. Handout master

b. Notes master

c. Slide master

d. All of the above