MS Access Questions & Answers | Basic Computer Knowledge

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

Answer: Option 'B'

Open an existing database

DigitalOcean Referral Badge

2.

In MS-Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or

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

Answer: Option 'C'

F9

DigitalOcean Referral Badge

3.

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

DigitalOcean Referral Badge

4.

In MS-Access to open an existing database press

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

Answer: Option 'B'

CTRL+O

DigitalOcean Referral Badge

5.

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

DigitalOcean Referral Badge

6.

There are three types of data found in a spreadsheet:

   A.) Equations, data, numbers
   B.) Numbers, formulas, labels
   C.) Data, words, numbers
   D.) Words, numbers, labels

Answer: Option 'B'

Numbers, formulas, labels

DigitalOcean Referral Badge

7.

Which symbol must all formula begin with:

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

Answer: Option 'B'

=

DigitalOcean Referral Badge

8.

To merge the cells which tab do you use from the format, cells menu?

   A.) Alignment tab
   B.) Number tab
   C.) Font tab
   D.) Merge tab

Answer: Option 'A'

Alignment tab

DigitalOcean Referral Badge

9.

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

Answer: Option 'C'

A dark wide boarder

DigitalOcean Referral Badge

10.

How do you rearrange the date in ascending or descending order?

   A.) Data, table
   B.) Data, sort
   C.) Data, form
   D.) Data, subtotals

Answer: Option 'B'

Data, sort

DigitalOcean Referral Badge

11.

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

DigitalOcean Referral Badge

12.

Which of the following is not a data base application?

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

Answer: Option 'C'

edit

DigitalOcean Referral Badge

13.

You can create hyperlinks from the Excel workbook to

   A.) A webpage on company internet
   B.) A web page on the internet
   C.) Other office 97 application documents
   D.) All of the above

Answer: Option 'D'

All of the above

DigitalOcean Referral Badge

14.

How many save as option in MS Access 2007?

   A.) 1
   B.) 2
   C.) 3
   D.) 4

Answer: Option 'C'

3

DigitalOcean Referral Badge

15.

The advantage of using a spreadsheet is

   A.) Calculations can be done automatically
   B.) Changing data automatically updates calculations
   C.) More flexibility
   D.) All of the above

Answer: Option 'D'

All of the above

DigitalOcean Referral Badge

16.

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

DigitalOcean Referral Badge

17.

_______ 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

DigitalOcean Referral Badge

18.

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

DigitalOcean Referral Badge

19.

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

DigitalOcean Referral Badge

20.

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

DigitalOcean Referral Badge

21.

________ 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

DigitalOcean Referral Badge

22.

_______ 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

DigitalOcean Referral Badge

23.

MS-Access database files have a default extension?

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

Answer: Option 'A'

MDE

DigitalOcean Referral Badge

24.

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

DigitalOcean Referral Badge

25.

_______ 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

DigitalOcean Referral Badge

26.

______ 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

DigitalOcean Referral Badge

27.

______shows a single record at a time?

   A.) Columnar
   B.) Tabular
   C.) Datasheet
   D.) None of these

Answer: Option 'C'

Datasheet

DigitalOcean Referral Badge

28.

_________ provides the tools for creating fields in a table?

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

Answer: Option 'C'

Both a and b

DigitalOcean Referral Badge

29.

______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

DigitalOcean Referral Badge

30.

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

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

Answer: Option 'B'

Field

DigitalOcean Referral Badge

31.

_______ a series of lines and data appear in the form in Design view?

   A.) Order of tabs
   B.) Grid lines
   C.) Label
   D.) None of these

Answer: Option 'B'

Grid lines

DigitalOcean Referral Badge

32.

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

DigitalOcean Referral Badge

33.

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

DigitalOcean Referral Badge

34.

_______ 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

DigitalOcean Referral Badge

35.

Which of the following is not a layout in the form design?

   A.) Autoform Layout
   B.) Justified Layout
   C.) Columnar
   D.) Database

Answer: Option 'A'

Autoform Layout

DigitalOcean Referral Badge

36.

Which of the following is not a valid relationship in MS-Access?

   A.) One to one relationship
   B.) One to two relationship
   C.) Many to many relationship
   D.) One to many relationship

Answer: Option 'B'

One to two relationship

DigitalOcean Referral Badge

37.

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

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

Answer: Option 'B'

255

DigitalOcean Referral Badge

38.

_____ property is used to set the maximum size for data stored in a field?

   A.) Data entry
   B.) Field size
   C.) Format
   D.) Rows

Answer: Option 'B'

Field size

DigitalOcean Referral Badge

39.

Which of the following the AutoCalc command on the toolbar provides in MS-Access?

   A.) Sum
   B.) Count
   C.) Min
   D.) All of the above

Answer: Option 'D'

All of the above

DigitalOcean Referral Badge

40.

Which of the following is valid text and memo format in MS-Access?

   A.) @
   B.) <
   C.) &
   D.) All of the above

Answer: Option 'D'

All of the above

DigitalOcean Referral Badge

41.

A database makes it unreadable in MS-Access is called?

   A.) Encode
   B.) Database
   C.) Decode
   D.) None

Answer: Option 'A'

Encode

DigitalOcean Referral Badge

42.

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

DigitalOcean Referral Badge

43.

MDE file does not contain?

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

Answer: Option 'D'

Source code

DigitalOcean Referral Badge

44.

Caption is a string that can contain up to _________ characters in MS-Access?

   A.) 2037
   B.) 2048
   C.) 2025
   D.) 2031

Answer: Option 'B'

2048

DigitalOcean Referral Badge

45.

_____ 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

DigitalOcean Referral Badge

46.

Which key is used to join the two table in MS-Access?

   A.) Foreign key
   B.) Primary key
   C.) Special key
   D.) None of these

Answer: Option 'A'

Foreign key

DigitalOcean Referral Badge

47.

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

DigitalOcean Referral Badge

48.

MS-Access is a type of?

   A.) Utility software
   B.) Application Software
   C.) System software
   D.) None

Answer: Option 'B'

Application Software

DigitalOcean Referral Badge

49.

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

Answer: Option 'A'

Database Window 

DigitalOcean Referral Badge

50.

MS-Access is a component of?

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

Answer: Option 'A'

Microsoft Office

DigitalOcean Referral Badge

MS Access MCQs Download Pdf

Recent Posts