MS Access Questions & Answers | Basic Computer Knowledge

1.

MS-Access is a component of?

   A.) Microsoft Office
   B.) Windows XP
   C.) Windows
   D.) None of these

Answer: Option 'A'

Microsoft Office

2.

MDE file does not contain?

   A.) Macros
   B.) Tables
   C.) Queries
   D.) Source code

Answer: Option 'D'

Source code

3.

Which symbol must all formula begin with:

   A.) @
   B.) =
   C.) +
   D.) %

Answer: Option 'B'

=

4.

________ provides the tools for creating fields in a table?

   A.) Drawing View
   B.) Table View
   C.) Drawing View
   D.) Both b and c

Answer: Option 'A'

Drawing View

5.

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)

Answer: Option 'B'

=A1 + A2

6.

In MS-Access to open new database press

   A.) CTRL+N
   B.) CTRL+O
   C.) ALT+F4
   D.) None of these

Answer: Option 'A'

CTRL+N

7.

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 

Answer: Option 'C'

​DDL

8.

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

Answer: Option 'C'

In An Indexed Field You May Or May Not Enter Duplicate Value Depending Upon Setting 

9.

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

   A.) Tables
   B.) Reports
   C.) Form
   D.) None of the above

Answer: Option 'B'

Reports

10.

Using the keyword ______ will return records in which the field value equals a defined text.

   A.) Like
   B.) Between
   C.) Is Null
   D.) Equal

Answer: Option 'A'

Like

11.

Which of the following data type is used to store logical value in MS Access?

   A.) Yes/No
   B.) True/False
   C.) On/Off
   D.) All of the above

Answer: Option 'A'

Yes/No

12.

_______ defines a data type for a set of values in a table?

   A.) Field
   B.) File
   C.) Record
   D.) None of these

Answer: Option 'A'

Field

13.

In MS-Access the maximum length of validation text is?

   A.) 126
   B.) 255
   C.) 129
   D.) 234

Answer: Option 'B'

255

14.

_____ property is used to specify requirements for data entered into a record, field or control?

   A.) Validation text
   B.) Validation rule
   C.) Both a and b
   D.) None of these

Answer: Option 'C'

Both a and b

15.

The task of arranging data in order is called

   A.) Ordering
   B.) Searching
   C.) Sorting
   D.) Ascending

Answer: Option 'C'

Sorting

16.

The complete information about an entity in a database is called

   A.) Field
   B.) Record
   C.) Information
   D.) All of the above

Answer: Option 'B'

Record

17.

This Key Uniquely Identifies Each Record

   A.) Primary Key
   B.) Key Record 
   C.) Unique Key 
   D.) Field Name 

Answer: Option 'A'

​Primary Key

18.

______ is a component of database such as a table, query, form and macro?

   A.) Table
   B.) Object
   C.) Record
   D.) None of these

Answer: Option 'B'

Object

19.

A __________ Enables You To View Data From A Table Based On A Specific Criterion

   A.) Form
   B.) Macro
   C.) Query
   D.) Report 

Answer: Option 'C'

Query

20.

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

Answer: Option 'A'

Relationship


MS Access MCQs Download Pdf

Recent Posts