Prakhar Gupta has 4+ years of experience in Content Marketing Field. 

Content Marketing Specialist

Questions regarding MS Access are frequently asked in various competitive exams. These questions are somewhat tricky to answer but are also rewarding. You must have an understanding of Computer-related terms and concepts to answer these questions. You can begin to answer once you have studied about it.

With a little practice, you&#39;ll be able to answer these General Awareness questions with ease. So we&#39;ve included ten questions about MS Access for you to practice with. Each of these questions should be answered in less than a minute. 
 

<h2>Questions on MS Access</h2>

You can also download the questions and answers pdf. Just click on the Download PDF button. So let&#39;s start with the first question.

Q:1 Which of the following is the shortcut key for closing the active window in MS Access?

1. CTRL+W

2. ALT+SPACEBAR

3. ALT+F11

4. SHIFT+F10

(Difficulty: 1, Estimated Time: 10 Seconds) Let&#39;s begin with something really easy.

Q:2 Which of the following is a method to enter data in MS Access 2013?

1. Using SQL View

2. Using form

3. Datasheet View

4. All of the above

(Difficulty: 1, Estimated Time: 10 Seconds) This one&#39;s easy too.

Q:3 When was MS Access released?

1. 2012

2. 2002

3. 1992

4. 1982

(Difficulty: 2, Estimated Time: 15 Seconds) You need to think a bit for this one. Did you get it right?

Q:4 Which of the following views for reports are available in MS Access?

1. Print preview

2. Design View

3. Layout View

4. All of the above

(Difficulty: 3, Estimated Time: 20 Seconds) This isn&#39;t that difficult. Try to get it right.

Q:5 The databases in MS Access is composed of how many objects?

1. 5

2. 4

3. 3

4. 2

(Difficulty: 2, Estimated Time: 15 Seconds) You can answer this if you have used MS Access

Q:6 MS Access file extension is _____.

1. .adcdb

2. .acddb

3. .accdb

4. .accdc

(Difficulty: 4, Estimated Time: 25 Seconds) Try to eliminate the wrong ones. 

Q:7 What type of data/file can be created on MS Access.?

1. queries

2. forms and reports

3. Table

4. All of the above

(Difficulty: 2, Estimated Time: 15 Seconds) We are halfway through. Try to get this one right.

Q:8 Which of the following is a part of the data table in MS Access?

1. The Stub

2. The Title

3. The Body

4. All of the above

(Difficulty: 3, Estimated Time: 20 Seconds) Think closely for this one.

Q:9 What is the shortcut key for opening a new database in MS Access?

1. CTRL+P

2. CTRL+N

3. CTRL+W

4. CTRL+S

(Difficulty: 1, Estimated Time: 10 Seconds) This one&#39;s quite basic. Do you know it?

Q:10 In MS Access 2013, the maximum number of characters that can fit in Short text data type is

1. 127

2. 128

3. 255

4. 250

(Difficulty: 2, Estimated Time: 15 Seconds) We have reached the end. Hurry up!

 

<h2>Answer Key</h2>

Let&#39;s have a look at your score.

<table border="0" cellpadding="1" cellspacing="1">
	<tbody>
		<tr>
			<td>1. (1)</td>
			<td>2. (4)</td>
			<td>3. (3)</td>
			<td>4. (4)</td>
			<td>5. (2)</td>
		</tr>
		<tr>
			<td>6. (3)</td>
			<td>7. (4)</td>
			<td>8. (4)</td>
			<td>9. (2)</td>
			<td>10. (3)</td>
		</tr>
	</tbody>
</table>

Comment below your score, considering each question has 1 mark only. If you scored 8 to 10, congratulations! You are one step closer to selection. If you have scored 5 to 8 marks, then you are doing well, keep it up. If you have scored less than 5 marks then you need to work a little harder on this subject. But don&#39;t worry, we are here to help you master the subject.

Let&#39;s check the answers and solutions and try to find out what went wrong. 
 

<h2>Answers and Solutions</h2>

Q:1 The correct answer is Option 1 i.e. CTRL+W

The shortcut key for closing an active window in MS Access is CTRL+W.

Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools.

It is a part of the Microsoft Office suite of applications.

 

Q:2 The correct answer is Option 4 i.e. All of the above

The different methods to enter data in MS Access are:

1. Using SQL View

2. Using form

3. Datasheet View

 

Q:3 The correct answer is Option 3 i.e. 1992

MS-Access is application software for managing databases.

It was released by Microsoft in November 1992.

It actually stores the data on the basis of the relational Jet Database Engine.

 

Q:4 The correct answer is Option 4 i.e. All of the above

The users who work with Microsoft Access can easily view their reports in following different ways:

1. Print preview

2. Design View

3. Layout View

4. Report View

MS-Access is application software for managing the databases.

It actually stores the data on the basis of the relational Jet Database Engine.  

 

Q:5 The correct answer is Option 2 i.e. 4

MS Access uses “objects&#39; to help the user list and organize information, as well as prepare specially designed reports.

Databases in Access are composed of four objects: tables, queries, forms, and reports.

Together, these objects allow you to enter, store, analyze, and compile your data however you want.

 

Q:6 The correct answer is Option 3 i.e.  .accdb.

MS Access

1. It was released on Nov. 1992

2. It is Database Management Software (DBMS)

3. Table, queries, forms and reports can be created on MS Access

4. Import and export of data into other formats can be done

5. MS Access file extension is  .accdb.

 

Q:7 The correct answer is Option 4 i.e. All of the above

MS Access

1. It was released on November 13, 1992

2. It is Database Management Software (DBMS)

3. Table, queries, forms and reports can be created on MS Access

4. Import and export of data into other formats can be done

5. The file extension is “.accdb”

 

Q:8 The correct answer is Option 4 i.e. All of the above

A relational database like Access usually has several related tables.

In a well-designed database, each table stores data about a particular subject, such as employees or products. 

The major parts of a data table are as follows:

1. The Title

2. The Box Head

3. The Stub

4. The Body

5. Prefatory Notes

6. Foot Notes

7. Source Notes.

 

Q:9 The correct answer is Option 2 i.e. CTRL+N

<table border="1" cellpadding="1" cellspacing="1">
	<tbody>
		<tr>
			<td>Shortcut Key</td>
			<td> Use</td>
		</tr>
		<tr>
			<td>CTRL+N</td>
			<td>Open a new database</td>
		</tr>
		<tr>
			<td>CTRL+O</td>
			<td>Open an existing database</td>
		</tr>
		<tr>
			<td>CTRL+P</td>
			<td>Print option for database</td>
		</tr>
		<tr>
			<td>CTRL+S</td>
			<td>Save the current database</td>
		</tr>
		<tr>
			<td>SHIFT+F10</td>
			<td>Display shortcut menu</td>
		</tr>
	</tbody>
</table>

 

Q:10 The correct answer is Option 3 i.e. 255

Short Text In . accdb files, the Short Text field works the same as the Text field in earlier versions. It stores up to 255 characters. 

Up to 255 characters. Microsoft Access only stores the characters entered in a field; it does not store space characters for unused positions in a Text field. To control the maximum number of characters that can be entered, set the FieldSize property. 
 

So that&#39;s it for today. Computer related topics are generally important. We&#39;ll go over another aspect of General Awareness later. Until then, you can practice the questions by downloading the MS Access PDF.

Since 1995, Neetu Mam is Providing Free Content for English to the Students

Best Publisher for English Content

Practice questions on the topic of General Awareness&nbsp;in exams - MS Access!

Questions on MS Access with detailed solutions - Download PDF!

Latest Notifications

Exam Eligibility

Exam Dates

Exam Pattern

Syllabus

Admit Card

Exam Cutoff

Answer Key

Exam Results

Daily Current Affairs

Current Affairs Quiz

Daily Editorial

Daily Vocabulary

Study Plan

Important Days

Question Paper

Previous Year PDF

English Language

Logical Reasoning

Quantitative Aptitude

General Knowledge

General Awareness

General Science

Today in History

Know Your State

Full Form

Know Your Country

Government Schemes

Know Your City

Know Your Leader

Books and Authors

question answer

Quiz

Courses

Classes

Syllabus of General Knowledge for SSC CGL- Subject Wise Topics Weightage

&lt;p&gt;No title&lt;/p&gt;

SSC CHSL General Awareness Syllabus - Subject Wise Topics Weightage

Microsoft Access is a common topic in competitive exams. This site provides a complete set of MS Access questions and detailed explanations. You can boost your chances of success in competitive exams by practicing solving these questions. You can download the PDF by clicking here now!

Questions on MS Access with detailed solutions - Download PDF!

MS Access Comments:

MS Access RELATED ARTICLES