MS Access Questions & Answers | Basic Computer Knowledge

1.

MS-Access is a?

   A.) Programming Tool
   B.) Database Tool
   C.) Web Page Creation Tool
   D.) None of the Above

Answer: Option 'B'

Database Tool

2.

A part of database that stores only one type of data is

   A.) Record
   B.) Table
   C.) Field
   D.) Report

Answer: Option 'C'

Field

3.

How we save database file in MS Access 2007 for Ms Access 2000?

   A.) Save As MS Access 2000 Database
   B.) Save Only
   C.) Save Object As
   D.) None of these

Answer: Option 'A'

Save As MS Access 2000 Database

4.

Which Of The Following Creates A Drop Down List Of Values To Choose From?

   A.) Ole Object 
   B.) Memo
   C.) Hyperlink 
   D.) Lookup Wizard

Answer: Option 'D'

Lookup Wizard

5.

_______ is a field property that determines what kind of data a field can store?

   A.) Data select
   B.) File type
   C.) Data type
   D.) None of these

Answer: Option 'A'

Data select

6.

What are the columns in a Microsoft Access table called?

   A.) Reports
   B.) Rows
   C.) Fields
   D.) Records

Answer: Option 'C'

Fields

7.

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

Answer: Option 'B'

Open an existing database

8.

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

9.

Any report, including a basic report, can be modified in _____.

   A.) Print Preview
   B.) Report View
   C.) Layout View
   D.) All of the above

Answer: Option 'C'

Layout View

10.

Which of the following is latest version of MS-Access?

   A.) MS-Access 2002
   B.) MS-Access 2000
   C.) MS-Access ME
   D.) MS-Access XP

Answer: Option 'D'

MS-Access XP

11.

Which symbol must all formula begin with:

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

Answer: Option 'B'

=

12.

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

   A.) data dictionary
   B.) data refinement
   C.) data definition
   D.) none of the above

Answer: Option 'C'

data definition

13.

A database can be best described as

   A.) Useful presentation of data
   B.) Organized collection of data
   C.) Graphical representation of data
   D.) None of the above

Answer: Option 'B'

Organized collection of data

14.

Which Of The Field Has Width 8 Bytes?

   A.) Memo
   B.) Number 
   C.) Date/time
   D.) Hyperlink

Answer: Option 'C'

Date/time

15.

In MS-Access to Open a combo box

   A.) F9
   B.) PAGE DOWN
   C.) DOWN ARROW
   D.) F4 or ALT+DOWN ARROW

Answer: Option 'D'

F4 or ALT+DOWN ARROW

16.

The Database Language That Allows You To Access Or Maintain Data In A Database

   A.) DCL
   B.) DML
   C.) DDL
   D.) None Of Above

Answer: Option 'A'

DCL

17.

Which Of The Following Is Not A Type Of Microsoft Access Database Object?

   A.) Table
   B.) Worksheets
   C.) Table
   D.) Modules

Answer: Option 'B'

Worksheets

18.

HSAM stands for ________

   A.) Hierarchic Standard and Method
   B.) Hierarchic Sequential and Method
   C.) Hierarchic Standard Access Method
   D.) Hierarchic Sequential Access Method

Answer: Option 'D'

Hierarchic Sequential Access Method

19.

In MS Access “Lookup Wizard” is used to

   A.) to select value from another table
   B.) to select values from Excel Sheet
   C.) to select from previous values
   D.) None of the above

Answer: Option 'A'

to select value from another table

20.

MDE file is a?

   A.) Memory Database Encrypt
   B.) Microsoft Access Database
   C.) Microsoft Database Encrypt
   D.) Memory Database Encode

Answer: Option 'B'

Microsoft Access Database

21.

_______ is a field property that determines what kind of data a field can store?

   A.) File type
   B.) Data type
   C.) Data select
   D.) None of these

Answer: Option 'C'

Data select

22.

What Are The Columns In A Microsoft Access Table Called?

   A.) Fields
   B.) Columns
   C.) Rows
   D.) Records

Answer: Option 'A'

Fields

23.

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

Answer: Option 'A'

Data Definition 

24.

Which of the following is not a database object?

   A.) Form
   B.) Reports
   C.) Tables
   D.) Relationships

Answer: Option 'D'

Relationships

25.

In MS-Access, minimum of _________data types can be assigned to a field?

   A.) 2
   B.) 6
   C.) 8
   D.) 10

Answer: Option 'D'

10


MS Access MCQs Download Pdf

Recent Posts