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