COMPUTER SCIENCE

ICS – 2nd Year

CHAPTER 5
INTRODUCTION TO MS ACCESS
Multiple Choice Questions
1. MS Access saves the database with the extension:
(A) .mbd (B) .msdb (C) .ppt (D).mdb
2. Which of the following is not a database object?
(A) Table (B) Query (C) Form (D) MS-Word
3. The example of popular DBMS is:
(A) MS-Word (B) MS-Access (C) MS-Excel (D) MS-Power Point
4. In Ms Access, table contains:
(A) Fields (B) Record (C) Character (D) File
5. SQL is used for
(A) Data definition (B) Data manipulation
(C) Data definition and manipulation (D) Data creation
6. It makes very simple to create a database:
(A) Sample database (B)Wizard
(C) Common standard (D) Easier programming
7. Find and replace command is found in:
(A) Edit menu (B) File menu (C) Tool (D) View menu
8. How many buttons available on access database window
(A) 4 (B) 5 (C) 7 (D) 9
9. Views are also called
(A) Complex tables (B) Simple tables (C) virtual tables (D) Actual tables
10. A report may be based on:
(A) Table (B) Relationship (C) Form (D) Attribute
11. A record is a complete set of _____ field.
(A) Distinct (B) Designed (C) Related (D) Non-related
12. Which of the following object of database is used to retrieve data from database?
(A) Queries (B) Forms (C) Reports (D) Tables
13. Which object is the output of a database application?
(A) Form (B) Query (C) Table (D)Report
14. A database consists of various components called:
(A) Tools (B) Properties (C) Entities (D)Objects
15. Which objects is used to store data in database?
(A) Table (B) Form (C)Report (D) Query
16. A request for information from a database in database terminology is called:
(A) Report (B) Letter (C) Table (D)Query
17. A database consists of various components called:
(A) tools (B) properties (C) entities (D)objects
18. Which of the following object is used to retrieve data from database and present in a formatted
way?
(A)Report (B) Form (C) Table (D) Query
Short Questions & Answers
1. What is Microsoft ACCESS?
Ans. Microsoft Access is one of the most popular and powerful DBMS. It has many built in features
to assist you in constructing database and viewing information. Microsoft Access is Relational
Database Management System (RDBMS) that you can use to store and manipulate large amounts of
information.
2. List down any two advantages of Microsoft Access.
Ans. It includes sample database applications to assist you to learn about real world tables, forms,
queries and reports. Wizard: It makes very easy to create a database you can choose from several
examples of database in database wizard.
3. List advantages of MS-ACCESS.
Ans. • Sample Databases • Wizard • Keys to understand structure
• Microsoft office integration • Common standards • Remove Redundancy
• Easier programming
4. What do you know about RDBMS?
Ans. RDBMS stands for Relational Database Management System. A relational database
management system (RDBMS) is a program that lets you create, update, and administer a relational
database.
5. What is sample database?
Ans. It includes sample database applications to assist you learn about real-world tables, forms,
queries and reports, and how they are interconnected to form a database management system.
6. Describe the Data Redundancy.
Ans. Data redundancy refers to the unnecessary duplication of data within a database or data storage
system. It occurs when the same piece of data is stored in multiple places instead of being stored
once and referenced when needed.
7. What is Database wizard?
Ans. It makes very easy to create a database. User can choose from several examples of database in
the Database Wizard for such storage uses as contact information, inventory control, a ledger, and
so on. User can create and then modify these databases to meet his own needs.
8. List any four parts of Application Window in MS-Access.
Ans. The Access Application Window follows the standard layout of all Microsoft Application. Main
parts of MS. Access application window are as follows:
1. Title Bar 2. Menu Bar 3. Toolbars 4. Scroll Bar 5. Status Bar
9. How is MS-ACCESS loaded?
Ans. To load MS Access, locate the MS Access application via the Start menu or a desktop shortcut,
and then launch the application. After launching, you can create a new database or open an existing
one from the welcome screen.
10. How MS-ACCESS exiting from Windows?
Ans. When you finish working in access, be sure to exit program to properly avoid damaging your
database.
• Click on File. File menu will appear.
• Click on Exit. File menu will close and you will return to Windows Desktop.
11. What is the purpose of views in MS Access?
Ans. In MS Access, views refer to the different ways a database object (such as a table, query, form,
or report) can be displayed and worked with. Each view serves a specific purpose to help users design,
edit, analyze, or use data effectively. There are two types of views are used in MS access for tables
like design view and datasheet view.
12. Describe Menu Bar
Ans. Menu bar contains different menus that are used to issue commands. Each word on menu bar
represents a different menu. A menu provides groups of related commands to perform different
functions.
13. What is the use of title bar in MS-Access?
 Ans. The title bar identifies the database application you are running in Microsoft Access. On the left
side of the title bar is program control icon. User can also use the minimize, maximize, restore, close
buttons on the right side of the title bar to control the MS-Access window.
14. Define Scroll Bar and its use.
Scroll bar is used to scroll around the sheet by clicking the scroll arrows at either end of the scroll bar
by dragging the scroll buttons in the scroll bar.
15. What is Toolbar.
Ans. Toolbar contains icon button that are shortcuts to the commands in the menu. Toolbar make it
easy to use the program's most common feature and functions. The buttons on the toolbar can
change depending on the objects selected.
16. What is main idea of Scroll Bar and Status Bar?
Ans. Scroll Bar: Scroll bar is a vertical or horizontal bar commonly on the right or bottom of window
that allow you to move the window viewing area up, down, left or right.
Status Bar: Status Bar is a graphical control element poses an information area typically found at
window's button.
17. Which database object is used to create and format printed output?
Ans. Report is the database object used to create and format printers output.
18. Write the use of database window in MS-Access.
Ans. The database window in MS-Access is used to organize all objects in the database. It contains its
own title bar and toolbar. The default table listing is used to display all tables in current database. It
is also used to create tables.
19. Which database object stores the data in database
Ans. Table stores data in database by using the means of tables. It is the combination of rows and
column and used to organize data. in database it is also known as relation.