CH-3

Chapter 3
Microsoft Access 2010
Short answer type questions :-
Q1. What is Microsoft Access ?
Ans. It is a powerful personal database and data manipulation tool that is also widely used in many businesses .
Q2. List any five advantages of MS Access 2010 .
Ans. (i) Easy to install and use .             (ii) Widely Popular
            (iii) Saves Time .                              (iv) Multiuser support
            (v) Importing Data
Q3.What does Microsoft Access 2010 database contain ? Write any five names .
Ans. Microsoft Database is made up of 7 major components . The five names are as follows :-
(i)Tables                                (ii)Relationships                              (iii)Forms
(iv)Reports                           (v)Macros
Q4. Define Tables .
Ans. The tables are the backbone and the storage container of the data entered into the database .
Q5. What is Relationships ?
Ans.Relationships are the bonds we build between the tables .
LONG ANSWER TYPE QUESTIONS :-
Q1. Define each of the following :-
a) Queries – Queries produce related records from a table that meet certain predefined conditions .
b) Forms – Forms are used for adding , modifying and removing records in a table . It is a graphical representation of a table .
c) Reports – A report is an effective way of presenting the data in an attractive layout . Reports cannot be edited .
Q2. Name the various screen elements of MS Access 2010 window and explain any four elements .
Ans .The various screen elements are :-
1.     Quick Access toolbar
2.     Title Bar
3.     File Tab
4.     Tab
5.      Ribbon
6.     Navigation Pane
7.     Status Bar
8.     Record Selector
9.     View Button
Title Bar – It displays the name of the database on the title bar .
File tab-  It displays a list of menu commands like New ,Save , Open , Print ,Exit, Close etc.
Tab – It displays various tabs like Home Tab , Create Tab etc.
Status Bar – It displays the information about the current object .


Q3. Write a note on Access Templates .
Ans . Access Template is a ready to use database which contains all the tables , forms, reports , queries , macros , relationships that we need to start working . They Save our time and effort  and enable us to start using our database right away .
Q4. Write Steps to :
a)     Start MS Access 2010
·        Click On Start Button .
·        Click on All Programs
·        Click on Microsoft Office .
·        Click on Microsoft Access 2010 ( MS Access window will appear ).
b)    Close and Exit MS Access 2010
·        Click on the File Tab
·        Click on Close Database (backstage view will appear ).
·        Click on Exit (The desktop screen will appear ).









Comments

Post a Comment

Popular posts from this blog

ch-6 QBASIC

Ch-6 QBASIC Short answer type questions:- Q1. Write the purpose and syntax of the following statements: a)       CLS         b) LET    c) INPUT               d) END ANS1. Statement Syntax Purpose 1.CLS CLS It clears the screen. 2.LET LET<variable>=<constants> To assign a value to a variable. 3.END END It ends the program permanently. It can be used only once at the end of the program. 4.INPUT INPUT<variable> To accept a value for the variable. Q2. What is elseif? Explain. Ans2. The command allows us to perform a secondary action if the first expression mentioned with the IF statement was ...
Read more

ch-10

Chapter 10 Internet Short Answer Type questions :- Q1. Write the use of internet in the field of education . Ans. Internet provides us number of books , reference books , online help centre ,expert’s views and other study materials that has made the learning process easy. There are lot of websites from where we can gain a lot of knowledge . Q2. Write a short note on ‘Picasa web albums ‘. Ans . The Picasa web Albums is Google’s photo sharing site ,where we can upload photos. A free picasa account gives us 1 GB of storage space. Q3.What is Social Networking? Ans. It is a service on the internet that enables us to connect with people who share the interests Q4. What do you know about ‘Entertainment on web ‘? Ans. The internet provides us many sources of entertainment . we can download music ,tune into Internet – based radio stations .we can see the photos of people sharing on the internet , videos ,watch movies on YouTube etc . Q5.What do you know about WhatsApp ? ...
Read more

ch-1 computer peripherals

Image
Class VII Chapter 1                              Computer Peripherals G. Short answer type questions:- 1. What is an Operating System ? Ans. An Operating System is the software that manages the computer’s resources and executes application programs. 2. What do you mean by Peripheral devices ? Ans. Peripheral devices are defined as auxiliary   devices   such as a computer mouse or keyboard that connects to and works with the computer in some way. Other examples are microphones, loudspeakers, webcams, and digital cameras. 3. What is a scan code ? Ans. When any key from the keyboard is pressed , the microprocessor generates a number called the Scan Code. 4. What is a Hard Copy ? Ans. The output given by a printer is called as a hard copy . 5.Write a short note on Line Printer ? Ans. Line printers produce output by pr...
Read more