MS ACCESS TWO MARK QUESTIONS WITH ANSWERS
1. What is Database Management System (DBMS)? The computer Software to manage, maintain atabase as we!! as "iew upate an retrie"e ata is ca!!e atabase management system.
#. $ist some atabase app!ications. Some of the popu!ar atabase management systems are% &rac!e, Sybase, MS 'ccess, MS S$ Ser"er, arao*, DB+#, Dbase, o*ro, MyS-!, etc.
. What is MS / 'ccess? MS / 'cces 'ccesss is a 0DBMS 0DBMS (0e!at (0e!ation iona! a! Databas Databasee Managem Management ent System System)) app!ica app!icatio tion n e"e!ope by Microsoft nc. that runs on Winows operating System.
2. What is Database? ' atabase is an organi3ation of ata re!ate to a particu!ar sub4ect or purpose so that the ata can be retrie"e or processe.
5. What is the e*tension of 'ccess atabase fi!e? The e*tension of MS / 'ccess ata fi!e is MDB.
6. What is re!ationa! atabase? ' atabase with tab!es re!ate to each other on a common fie! to faci!itate the ata retrie"a! from mu!tip!e tab!es is 7nown as re!ationa! atabase.
8. What is a 7ey fie!? ' common fie! on which two tab!es are !in7e is 7nown as 7ey fie!. 9. What is primary 7ey? ' primary 7ey is a ru!e which ensures that uni-ue ata is entere for the fie! an the fie! is not !eft b!an7. This is the fie! that wou! ientify a recor uni-ue!y in tab!e.
:. What are the e!ements of a atabase? The ma4or si* e!ements of a atabase are Tab!es, ueries, orm, 0eports, Macros an Mou!es.
1;. What is a tab!e? ' tab!e is a co!!ection of ata about a specific topic such as proucts, stuents or supp!iers. ' tab!e organi3es ata into co!umns (fie!s) an rows (recors or tup!es).
11. What is a fie!? ' fie! in a atabase is a piece of information about a sub4ect.
1#. What is a recor? ' recor is comp!ete information about a sub4ect. ' recor is a co!!ection of fie!s an presente as a row in a tab!e of atabase.
1. What is a -uery? ' -uery is a -uestion about ata in atabase. t resu!ts a set of ata from atabase that can be use as a source of recors for reports an forms.
12. What is a form?
15. What is a report? ' report is an ob4ect in MS / 'ccess that is use to "iew an print ata. Though a 0ep ort is simi!ar to a form= its specia!ty !ies in specia! features !i7e he!p to summari3e ata.
16. What are the ifferences between a form an a report? orms are primari!y us e to eit o"er"iew ata whereas reports are use primari!y to print or "iew ata. n a form your usua!!y na"igate from one recor to another, whereas in reports summari3e ata are possib!e to present.
18. What is a macro? ' macro is an ob4ect in MS / 'ccess that is use to e*ecute one or more atabase commans automatica!!y. Macros are usefu! in tas7s such as printing month / en reports, aing new recor to a tab!e, printing !etters to customers perioica!!y.
19. What is a mou!e? ' mou!e ob4ect in 'ccess is a program written using >B' (>isua! Basic for 'pp!ication) to automate an customi3e atabase function.
1:. What are the ifferent umber fie! types in 'ccess? The ifferent number fie! types are% Byte, nteger, $ong nteger, Sing!e an Doub!e.
#;. What o you mean by ata processing? Data processing is the techni-ue of sorting re!ating, interpreting an computing item of ata in orer to pro"ie usefu! an meaningfu! information.
#1. What are the ten fie! types in 'ccess? The ten ifferent fie! types in 'ccess are% Te*t, Memo, umber, D, Date+Time, @urrency, 'uto umber, Aes+o, &$< &b4ect, yper!in7 an $oo7up Wi3ar.
##. What are the ob4ects of 'ccess Database? The ob4ects of 'ccess Database are% Mou!es.
Tab!es, orms, 0eports, ueries, Macros an
#. What is the meaning of fo!!owing fie! properties? ie! Si3e, ormat, nput Mas7, @aption, Decima! !aces, Defau!t >a!ue, >a!iation 0u!e, >a!iation Te*t, 0e-uire, '!!ow Cero $ength, ne*e. ie! properties an their meaning are escribe be!ow% ie! Si3e% Ma*imum number of character or "a!ue you can enter in fie! ormat% ormat for the fie!. t gi"es the !ayout for the fie!. nput Mas7% ' way or pattern of ata to be entere. @aption% The !abe! for the fie! Decima! !aces% The number of igits to the right of ecima! p!ace. Defau!t >a!ue% The "a!ue automatica!!y entere for the new recor. >a!iation 0u!e% 'n e*pression that !imit the "a!ue to be entere in the fie!. >a!iation Te*t% The message to be isp!aye whi!e user "io!ates the ru!e when entering ata. 0e-uire% The ata shou! be entere the fie! cant be !eft b!an7. '!!ow Cero $ength% ermits 3ero !ength of string ne*e% The fie! is to be ine*e. ne*ing spees up the searching E sorting
#2. What is atasheet "iew? Datasheet "iew is a winow that isp!ays ata from a tab!e or -uery in row an co!umn format where you can eit fie!s, a, e!ete ata as we!! as search for ata.
#5. What is a sub/form? ' sub form is a form containe within another form or a report. This feature is usefu! to represent one/to/many re!ationship between tab!es. n the form we can show the ata of the Master tab!e an at the same time in a secon form we can show re!ate ata from the transaction tab!e.
#6. What o you mean by fi!ter? i!ter is the process of hiing a!! unnecessary recors or isp!ays on!y the recors that satisfy the criteria specifie.
#8. What are the ifferent ways to a a tab !e in 'ccess atabase? There are three ifferent ways you can a a tab!e in 'ccess atabase. They are% Datasheet >iew, Design >iew an Tab!e Wi3ar. Datasheet >iew% n atasheet "iew you can enter the fie! names an recors as in <*ce! sheet. 'ccess efines correct fie! types an si3es base upon the ata you enter for the fie!. ' tab!e is ae when you sa"e the atasheet. Design >iew% n esign "iew you wi!! specify the fie! name, ata type an "arious re-uire options for the fie!. ' tab!e is ae when you sa"e the esign. Tab!e Wi3ar% Tab!e wi3ar pro"ies you samp!e tab!es an samp!e fie!s from which you can se!ect the re-uire fie!s. 'fter comp!eting the wi3ar a tab!e is ae in atabase.
#9. What is the use of >a!iation 0u!e property of a fie!? >a!iation ru!e property a!!ows specifying what "a!iation must be mae for the ata entere in the fie!. f anything is specifie in the "a!iation ru!e property, on!y the ata that satisfies the conition specifie can be entere, a!! oth er ata is re4ecte.
#:. What is an 'utoorm? 'utoorm is a wi3ar in 'ccess that creates the specifie type of form from se!ecte tab!e or -uery. To create an 'utoorm, Se!ect the orms tab an c!ic7 on new button.
;. What are the three ifferent forms of auto forms? The three ifferent types of auto forms are% @o!umnar
•
•
Tabu!ar
•
Datasheet
1. What are contro!s? ow to use them? Fi"e e*amp!es for contro!. @ontro!s are ob4ects that can be p!ace in a form. Different contro!s are a"ai!ab!e in the Too! Bo*. 'fter se!ecting the contro! in the too!bo* it can be p!ace on the forms. 'fter p!acing the contro! we can set its properties to ser"e our re-uest. <*amp!es for contro!s are, te*tbo*, !abe!, $ist Bo*, @hec7 Bo*, &ption Buttons etc.
#. What are the ifferent options that you can use to fi!ter recors? The "arious options a"ai!ab!e to fi!ter recors are% i!ter by orm i!ter by Se!ection i!ter for nput '"ance i!ter+Sorting
. <*p!ain uery. ueries are use to retrie"e an isp!ay specific recors in a tab!e. They can a!so be use to isp!ay specific fie!s of specific recors, which meet the conition specifie. ' -uery isp!ays a subset of a!! or specific fie!s an recors in a tab!e. When a change is mae to the ata, which is isp!aye by the -uery, this change is ref!ecte in the tab!e a!so. Because of this ynamic re!ationship between the -uery an the tab!es, the subset of the ata isp!aye by the -uery is ca!!e a Dynaset.
2. What is a macro? ' macro is a set of instructions, which can be e*ecute repeate!y. it is usefu! for automating certain routine tas7s !i7e printing reports etc. The macro once create can be e*ecute from buttons or any other contro!s.
