Microsoft Access

1. In MS-Access press CTRL+O to

A) Open a new database

B) Open an existing database

C) Exit MS-Access

D) None of these

 

2. In MS-Access to open an existing database press

A) CTRL+N

B) CTRL+O

C) ALT+F4

D) None of these

 

3. In MS-Access to Open a combo box

A) F4 or ALT+DOWN ARROW

B) DOWN ARROW

C) PAGE DOWN

D) F9

4. In MS-Access to open new database press

A) CTRL+N

B) CTRL+O

C) ALT+F4

D) None of these

5. Which symbol must all formula begin with:

A) @

B) =

C) +

D) %

6. In an excel sheet the active cell is indicated by:

A) A blinking border

B) A dotted border

C) A dark wide boarder

D) None of These

7. To add two cells (A1 and A2) together you use the following formula:

A) A1 plus A2

B) =A1 + A2

C) =Add(A1+A2)

D) =together(A1:A2)

 

8. There are three types of data found in a spreadsheet:

A) Numbers, formulas, labels

B) Data, words, numbers

C) Words, numbers, labels

D) Equations, data, numbers

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

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

D) Lookup Wizard

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

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

13. In A Database Table, The Category Of Information Is Called __________
A) Tuple

B) Field

C) Record

D) All Of Above

14. This Key Uniquely Identifies Each Record

A) Primary Key

B) Key Record

C) Unique Key

D) Field Name

15. It Is An Association Established Between Common
A) Line
 
B) Relationship
 C) Primary Key
D) Records

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



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

17. A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________
A) DCL
B) DML

 C) DDL
 D) All Of Above


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

19. Following Is Not A Database Model
A) Network Database Model
B) Relational Database Model
C) Object Oriented Database Model

 D) None

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

 

21. DCL Provides Commands To Perform Actions Like
A) Change The Structure Of Tables
B) Insert, Update Or Delete Records And Data Values
 
C) Authorizing Access And Other Control Over Database
 D) None Of Above

22. The Database Language That Allows You To Access Or Maintain Data In A Database
 
A) DCL
 B) DML
C) DDL
D) None Of Above

 

 

 

 

 

 

 

 

 

 

 

 

 

 



23. What Is The Maximum Length A Text Field Can Be?
A) 120

 B) 255
 C) 265
D) 75

 

24. Which Of The Following Is Not A Database Object?
A) Tables
B) Queries

 C) Relationships
 D) Reports

25. A __________ Enables You To View Data From A Table Based On A Specific Criterion
A) Form

 B) Query
 C) Macro
D) Report

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

27. Which Of The Following Is Not A Type Of Microsoft Access Database Object?
A) Table
B) Form

 C) Worksheets
 D) Modules

 

​​28. Which Of The Following Database Object Hold Data?

A) Forms

 B) Reports

 C) Queries

 D) Tables

29. Which Of The Following Store Command To Retrieve Data From Database?

 A) Forms

 B) Reports

 C) Queries

 D) Tables

30. Which Of The Following Database Object Produces The Final Result To Present?

 A) Forms

 B) Reports

 C) Queries

 D) Tables

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

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

33. 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 Data

 D) None Of Above

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

35. In Table Design View What Are The First Column Of Buttons Used For

 A) Indicate Primary Key

 B) Indicate Current Row

 C) Both Of Above

 D) None Of Above

36. The Default And Maximum Size Of Text Field In Access

 A) 50 And 255 Characters

 B) 8 And 1 Gb

 C) 266 Characters & 64000 Characters

 D) None Of Above

 

 

 

 

 

 

 

 

 

37. The Size Of Yes No Field Is Always

 A) 1 Bit

 B) 1 Byte

 C) 1 Character

 D) 1 Gb

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

 A) Memo

 B) Hyperlink

 C) Ole Object

 D) Lookup Wizard

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

 A) 2

 B) 4

 C) 8

 D) 16

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

41. Which Field Type Can Store Photos?

 A) Hyperlink

 B) Ole

 C) Both Of These Can Be Used

 D) Access Tables Can’t Store Photos

 

 

 

 

 

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

 A) 60

 B) 64

 C) 68

 D) Any Number Of Character

43. Which of the following database object is created first before any other created?
 
A) Table
 B) Form
C) Report
D) Query

44. This type of database contains multiple tables that are connected to produce combined output from all tables.
A) Bound
B) Linked
 
C) Relational
 D) Joined

45. The ‘Filter by selection’ allows you to filter those records
 
A) That match the selected field
 B) That match the criteria specified
C) That meet any of several criteria specified
D) All of above

46. The operation of checking input data against specified criteria is known as?
A) Data Verification
 
B) Data Validation
 C) Cross Check
D) Data Control

47. Some rules are set in databases to check and permit only correct values. What is this feature called?
A) Data Verification
B) Auditing
C) Data Filtering
 
D) Data Validation

 

 

 

 

 

 

 

 

 

 

 

 

 

 



48. Database access levels are specified so as to define who can access what in a database. It is identified through
 A) User ID
 B) Password
C) Status
D) None of above

 

49. What it is called to present information in a particular order based on numeric or alphabetical value?
 A) Sorting
 B) Searching
C) Arranging
D) Cropping

50. A collection of related records in database is known as a
A) Table
B) Database

 C) File
 D) None of above

51. A part of database that stores complete information about an entity such as employee, sales, orders etc.
A) File

 B) Record
 C) Field
D) Query

52. To create this, you enter an expression in the design grid that instructs Access to perform a calculation using the current field values.
A) Formulated field
B) Numeric field
C) Formula field

 D) Calculated field

53. The ascending order of data hierarchy is?
 
A) Bit - Byte - Field - Record - File - Database
 B) Bit - Byte - Record - Field - File - Database
C) Byte - Bit - Field - Record - File - Database
D) Bit - Byte - Field - Record - Database - File

54. Which of the following database object can be used if you need to mail the invoice to customers?

 

 A) A form
B) A Query

 C) A report
 D) A Table

55. When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from A-Z
 
A) ?
 B) !
C) #
D) \

56. In Access, this displays the results of a calculation in a query
A) Lookup field

 B) Calculated field
 C) Source field
D) Child field

57. In Access, this operation copies a backup file from the storage medium back onto the computer
A) Recreate
 
B) Restore
 C) Copy
D) Structure


58. If you make an invalid entry in the Input Mask Wizard dialog box, this will display to advise you that the entry is not correct
A) Text error
 
B) Validation error
 C) Literal error
D) Entry error

59. In the Form Wizard dialog box, the fields from the selected table are displayed in this list box.
A) All Fields
B) All Records
C) Available Records
 
D) Available Fields

60. This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.
A) Tabular
B) Justified
 
C) Columnar
 D) Datasheet

61. This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading.
A) Columnar
B) Justified
C) Datasheet
 
D) Tabular

 

62. This form displays multiple records, one per row, in the Form window
 A) Datasheet
 B) Tabular
C) Columnar
D) Justified

63. The file extension for an Access 2003 database is
A) EXE
B) DOC
C) EXC

 D) MDB

64. Which of the following is a database management system?
A) MS Word
B) MS Excel

 C) Oracle
 D) Lotus 1-2-3

65. Which of the following columns does not exist in Macro Design window?
A) Arguments
B) Comments
 
C) Conditions
 D) Actions