Exam Tiger
APTITUDE TESTS - MENTAL ABILITY - SOLVED OBJECTIVE MCQ SETS - QUESTION ANSWER - PDF STUDY MATERIALS - SHORTCUT TIPS

Microsoft Access Database

MS Access Database Question & Answer : Microsoft Access is part of Microsoft Office package. It is a desktop database management system (DBMS) which was first released in 1992. MS Access provides a great database development tool through simple user-friendly graphical user interface. It has many advantages over MS Excel or other spreadsheet applications. Access is relatively simple application to create databases for personal use or for use of a small group. It can also be used in client-server mode through front-end applications.

Earlier, the extension of a MS Access file was .mdb (Access 97-2003). The default file format has changed from .mdb to .accdb with the introduction of MS Access 2007. MS Access serves the purpose of a Database Management System, and it helps us to store data for producing information for creating great report and data analysis form a large volume of data. We can also import or link data from other data sources into MS Access database. MS Access databases can be uploaded in web servers to create database driven web applications.


Microsoft Access Database Multiple Choice (MCQ) objective question with answer keys

Here you will find a list of common important questions on microsoft access database in multiple choice question (MCQ) style with answer. These frequently asked sample questions are given with correct choice of answer that you can check instantly. Presently we have added total 10 sets of questions on microsoft access database for you to practice. We will keep adding more questions and provide this question bank in PDF format, so that you can download them instantly in E-book style.

The following section consists of objective multiple choice questions (mcq) on microsoft access database with answers.


INSTRUCTION: CLICK ON THE OPTION (A, B, C, D) TO SELECT IT AS YOUR ANSWER.


Q. Which field type will you select if you need to enter long text in that field?
A.
Text
B.
Memo

C.
Currency
D.
Hyperlink


Show Answer
Q. The expression builder is an access tool that controls an expression___ for entering an expression
A.
Table
B.
Box

C.
Cell
D.
Palette


Show Answer
Q. Which of the following is not a type of MS Access databaseobject?
A.
Table
B.
Form

C.
Worksheets
D.
Modules


Show Answer
Q. In which method we don't need to specify the field type and size while creating a new Table?
A.
Design View
B.
While using Wizard

C.
CreateTable By Entering Data
D.
All of Above


Show Answer
Q. The size of yes/no field is always ________
A.
1 Bit
B.
1 Byte

C.
1 Character
D.
1 KB


Show Answer



Advertisement


eXTReMe Tracker