MS Access Basics, Microsoft Access

MS Access Basics

Question: How many data type are used in MS Access Database?
A
13

B
11

C
7

D
9

Note: Not available
1. Report
Question: _____ is able to store and manipulate data across multiple tables.
A
Relational Table

B
Relational Form

C
Relational Database

D
Relational Report

Note: Not available
1. Report
Question: Which one of the following stores the whole value entered but only displays the number up to two decimal places?
A
General Number

B
Fixed

C
Standard

D
Currency

Note: NA
1. Report
Question: Which one of the following statements is not correct related to Primary key?
A
A primary key is used as unique identifier for each column

B
A primary key field can never be left empty

C
When working with related tables, the primary key field in one table can be used as foreign key field in another table.

D
None of these

Note: not available
1. Report
Question: Which of the following is database object?
A
Table

B
Query

C
Form

D
All

Note: Not available
1. Report
Question: Which one of the following statements is not correct related to Index?
A
An index stores the location of records.

B
Index may speed up searches; it can also slow the process of updating data within table.

C
You can set index on a field which is seldom used

D
You can set index on any fields except OLE objects or attachment fields.

Note: Not available
1. Report
Question: Which one of the following is the extension of MS-Access 2007 database?
A
.mdb

B
.accdb

C
.xlsx

D
None

Note: Not available
1. Report
Question: The wildcard "[ ]" refers to ______.
A
Matches any single alphabetic character within a string.

B
Matches any single character within the brackets

C
Matches any character not defined within the brackets

D
Matches any one of a range of characters defined within the brackets

Note: Not available
1. Report
Question: To configure the properties of an object in MS-Access 2007, which of the following can we use?
A
Datasheet view

B
Design view

C
Table view

D
Print preview

Note: Not available
1. Report
Question: Which one of the following is not the form view?
A
Form view

B
Datasheet view

C
Layout view

D
Design view

Note: Not available
1. Report

First Prev 9 10 11 12 13 Next Last

Question: How many data type are used in MS Access Database?

Question: _____ is able to store and manipulate data across multiple tables.

Question: Which one of the following stores the whole value entered but only displays the number up to two decimal places?

Question: Which one of the following statements is not correct related to Primary key?

Question: Which of the following is database object?

Question: Which one of the following statements is not correct related to Index?

Question: Which one of the following is the extension of MS-Access 2007 database?

Question: The wildcard "[ ]" refers to ______.

Question: To configure the properties of an object in MS-Access 2007, which of the following can we use?

Question: Which one of the following is not the form view?