MS Access Questions & Answers | Basic Computer Knowledge

1.

MS-Access database files have a default extension?

   A.) MDE
   B.) DBM
   C.) PRG
   D.) BBE

Answer: Option 'A'

MDE

2.

Which of the following database object hold data?

   A.) Reports
   B.) Tables
   C.) Forms
   D.) All of the above

Answer: Option 'B'

Tables

3.

In MS-Access, what Are The Different Views To Display a table?

   A.) Datasheet View
   B.) Design View
   C.) Pivot Table & Pivot Chart View
   D.) All of the above

Answer: Option 'D'

All of the above

4.

Which of the following is not a database object?

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

Answer: Option 'D'

Relationships

5.

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

6.

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 

7.

MDE file does not contain?

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

Answer: Option 'D'

Source code

8.

Which of the following is not a data type in MS-Access?

   A.) Table
   B.) Number
   C.) Text
   D.) OLE object

Answer: Option 'A'

Table

9.

This Key Uniquely Identifies Each Record

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

Answer: Option 'A'

​Primary Key

10.

What is the maximum length a text field can be?

   A.) 255
   B.) 256
   C.) 257
   D.) 355

Answer: Option 'A'

255

11.

Queries can be created in Access by

   A.) Using Query Wizard
   B.) Typing Queries in SQL View
   C.) Drag and Drop fields on Query Builder
   D.) All of the Above

Answer: Option 'A'

Using Query Wizard

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.

______shows multiple records at a time on a page with fields in columns and records in rows?

   A.) Database
   B.) Justified
   C.) Tabular
   D.) Database

Answer: Option 'C'

Tabular

14.

DCL provides commands to perform actions like

   A.) Change the structure of tables
   B.) Authorizing access and other control over database
   C.) Insert, update or delete records and data values
   D.) All of the above

Answer: Option 'B'

Authorizing access and other control over database

15.

24 Microsoft Access is a

   A.) OODBMS
   B.) ORDBMS
   C.) RDBMS
   D.) None of the above

Answer: Option 'C'

RDBMS

16.

What Are The Columns In A Microsoft Access Table Called?

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

Answer: Option 'A'

Fields

17.

Which of the following is not a data base application?

   A.) Access
   B.) dBase
   C.) edit
   D.) FoxPro

Answer: Option 'C'

edit

18.

_______ 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

19.

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

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

Answer: Option 'B'

Object

20.

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 


MS Access MCQs Download Pdf

Recent Posts