Introduction To MS Access - Short Questions and Answers. This post contains the most important and more conceptual short questions with answers of Computer Science, ICS Part-II Chapter No.5: Introduction to Microsoft Access, for the examinations and database interview questions for jobs:
Chapter No.5
Introduction to Microsoft Access
Short Questions & Answers
Q.1: What do you know about MS Access?
Answer:
Microsoft Access is RDBMS (Relational Database
Management System) that is used to construct a database, view information, store
and manipulate a large amount of information. It is easy to understand and its graphical interface helps to create queries, forms, and reports.
Q.2: Write some features/benefits of Access?
Answer:
The following are some features/benefits of MS-Access:
- Sample Databases
- Wizard
- Keys to Understand the Database Structure
- MS Office Integration
- Easier Programming
- Common Standards
- Redundancy
- Data Dictionary
Q.3: What is a database wizard?
Answer:
It makes it very easy to create a database. You can choose from several
examples of databases in the Database Wizard for such storage
uses as contact information, and inventory control and then modify these
databases to meet your needs.
Q.4: What is meant by “Microsoft Office Integration”?
Answer:
You can use access with MS-Word, MS-Excel, and other office application
to create a mail merge, charts, and other helpful uses for your data.
Q.5: What is Data Redundancy?
Answer:
Data Redundancy means duplication of data in multiple
files. It wastes the storage media of computers. MS-Access allows you to
store, retrieve, sort, analyze, and print information contained in the
database. Data may be manipulated without data redundancy by defining
relationships between files.
Q.6: What will happen if the same name of the database is done?
Answer:
If you have previously created a database, and then create it again using
the same name, it will be overwritten any work you have done.
Q.7: How many methods do create the database?
Answer:
When you start up MS-Access, you get a dialog box asking if you
want to open an existing database or create a new one:
- Create a New Database
- Create a New Database using Wizard
- Open an existing Database
Q.8: What is Title Bar?
Answer:
The title bar identifies the database application you are
running in MS-Access. On the left side of the title bar is the program control
icon. On the right side of the title bar are the control buttons i.e.,
minimize, maximize, restore, and close.
Q.9: What is Program Control Icon?
Answer:
On the left side of the title bar is Program Control Icon,
if you click this, a menu of the commands to control the Access window
is displayed. This icon can also be changed with the company logo.
Q.10: What is Menu Bar?
Answer:
Each word on the menu bar represents a different menu. Each menu contains the commands you use to activate features of Access.
Q.11: What are Toolbars?
Answer:
Toolbars contain icon buttons that are shortcuts to the
commands in the menu. Toolbars make it easy to use the program’s most common
features and function.
Q.12: What are Scroll Bars?
Answer:
Scroll Bars are used to move around the window if its
contents do not fit on-screen. You can scroll around the sheet by clicking the
scroll arrows at either end of the scroll bar or dragging the scroll button in
the scroll bar.
Q.13: What is Status Bar?
Answer:
The status bar displays while you are working on an object
within a database. CAPS and NUM buttons on the keyboard show whether and respectively
are on.
Q.14: Differentiate between an application window and a database window?
Answer:
Application Window: The Access Application Window
follows the standard layout of the Microsoft Application. Its components are the title
bar, menu bar, toolbars, and status bar.
Database Window: The Database Window organizes all
of the objects in the database. The left side of the MS-Access database
window includes seven buttons, each corresponding to one of the seven objects
that make up an Access database.
Q.15: Define macro?
Answer:
A macro is used to perform the same sequence of steps or
automating tasks repeatedly. It may be created to automate tasks or more modules
to create database applications using Access.
Q.16: What is a module?
Answer:
A module is a software component or part of
a program that comprises one or more routines. It contains an object
that stores VBA (Visual Basic for Applications) code and make
a programmer's job easy by allowing the programmer to focus
on only one area of the functionality of the software application.
Q.17: What are the database objects?
Answer:
MS-Access database consists of various components called the objects.
The database objects are used to store data and to retrieve data from the database.
The major database objects are:
- Tables
- Queries
- Forms
- Reports
Q.18: What are Tables?
Answer:
A table is a collection of related data organized in rows
and columns. The data is stored in tables of the database. A relational database
may contain multiple tables, which are identified by unique names. This is the
fundamental property of a relational database.
Q.19: What are Queries?
Answer:
The query is a statement that extracts specific information
from the database. It is created by specifying the fields to display from a table(s)
or another query. It is a more flexible way of selecting, filtering, and sorting records.
Queries allow performing calculations of different fields. The output of
a query is also displayed in the form of a table and can also be used as a source
of records for Forms and Reports.
Q.20: What are Forms?
Answer:
Forms are used to enter data into the database, edit data,
delete records and view data from the database. They provide an easy method for entering,
editing data, and display data retrieved from database tables.
Q.21: What are Reports?
Answer:
Reports are used to retrieve the data from the database and present
it on screen in a predefined format. They do not allow users to change data or
to enter data into the database.
➤ Forms & Reports - MCQs
➤ Table and Query
➤ Data Integrity & Normalization
➤ Database Design Process
➤ Basic Concepts & Terminology of Databases
➤ Data Basics
➤ Getting Started with C
➤ Elements of C
➤ Input/Output
➤ Decision Constructs
➤ Loop Constructs
➤ Functions in C
➤ File Handling
Post a Comment
Your feedback is highly appreciated and will help us to improve. So, please give your good suggestions.