MICROSOFT ACCESS Questions and Answers :1. When a picture or other graphic image is placed in the report header section it will appear____ a. Once in the beginning of the report b. At the top of every every page c. Every after record break d. On the 1st and last pages of the report 2. ascade delete option a. is used to delete all the records of all tables in a database b. will repeat the the recent delete delete operation to all all the records of of current table table c. is available in Edit relationship dialog bo! which makes sure that all the related records will be deleted automatically when the record from parent table is deleted d. "one of above #. $his data type allows alphanumeric characters and special symbols. a. te!t b. memo c. auto number d. "one of the above %. &uery design window has two parts. $he upper part shows a. "ame of fields' field type and si(e b. $ables with fields fields and relationships relationships between between tables c. riteria d. )orting check bo!es *. +n a database table' the category of information is called ____________ a. tuple b. field
c. record d. All of above ,. $o create a new table' in which method you don-t need to specify the field type and si(e a. reate table in /esign 0iew b. reate $able using using wi(ard c. reate $able by Entering data d. All of above &. What & )et offers for the candidates of computer obs e!ams a. /ownloads of & 3anks b. 4uge collection collection of & 5uestions 5uestions c. Online & 5ui( d. )ubective 5uestions and answers 6. Which of the following is not a database obect a. $ables b. &ueries c. 7elationshi 7elationships ps d. 7eports 8. +n one9to9many relationship relationship the table in :one- side is called _______ and on :manyside is called _______ a. hild ' ;arent b. ;arent ' hild c. 3rother ' )ister d.
c. record d. All of above ,. $o create a new table' in which method you don-t need to specify the field type and si(e a. reate table in /esign 0iew b. reate $able using using wi(ard c. reate $able by Entering data d. All of above &. What & )et offers for the candidates of computer obs e!ams a. /ownloads of & 3anks b. 4uge collection collection of & 5uestions 5uestions c. Online & 5ui( d. )ubective 5uestions and answers 6. Which of the following is not a database obect a. $ables b. &ueries c. 7elationshi 7elationships ps d. 7eports 8. +n one9to9many relationship relationship the table in :one- side is called _______ and on :manyside is called _______ a. hild ' ;arent b. ;arent ' hild c. 3rother ' )ister d.
a. relationship b. >oin c. &uery d. "one of these 1?. $wo tables can be linked with relationship so that the data integrity can be enforced. Where can you find find 7elationship 7elationship ommand a. 4ome $ab b. reate $ab c. E!ternal /ata $ab d. /atabase $ab 11. $his is the stage in database design where one gathers and lists all the necessar necessary y fields for the database proect. a. data definition b. data refinement refinement c. establishing relationship d. none of the above 12. $he two form layout types will display multiple records at one time are tabular and___ a. columnar b. ustified c. date sheet d. pivot table 1#. $he si(e of a field with "umber data type can not be a. 2 b. % c. 8 d. 1,
&. What & )et offers for the candidates of computer obs e!ams a. /ownloads of & 3anks b. 4uge collection of & 5uestions c. Online & 5ui( d. )ubective 5uestions and answers 1%. A small button with three dots usually displayed at the right of field properties bo! a. ake button b. E!pression button c. 3uild button d. "one of above 1*. $he si(e of @es "o field is always a. 1 bit b. 1 byte c. 1 character d. 1 3 1,. $his key uni5uely identifies each record a. primary key b. key record c. uni5ue key d. field name 16. $he command center of access file that appears when you create or open the ) Access database file. a. /atabase Window b. &uery Window c. /esign 0iew Window d. )witchboard
18. A database language concerned with the definition of the whole database structure and schema is ________ a. /B b. /B c. //B d. All of above 1=. When creating a new table which method can be used to choose fields from standard databases and tables a. reate table in /esign 0iew b. reate $able using wi(ard c. reate $able by Entering data d. "one of above 2?. What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table a. A relationship is created b. Edit relationship dialog bo! appears c. Error occurs d. "othing happens 21. 4ow can you define a field so that when entering data for that field it will display CCCCCC instead of actual typed te!t a. +nput mask b. 0alidation 7ule c. +nde!ed d. +E ode 22. $o sort records in a table a. Open table' click on the field on which the sorting is to be done' then click )ort button on database toolbar
b. Open table' click )ort button on database toolbar' choose field based on which to sort' click OD c. lick the field heading to sort it ascending or descending d. All of above 2#. $o create relationship between two tables a. drag the primary key of a table into foreign key of another table b. drag the foreign key of a table into the primary key of another table c. drag any field from parent table and drop on child table d. Any of above can be done to create relationship 2%. After entering all fields re5uired for a table' if you reali(e that the third field is not needed' how will you remove a. @ou need to delete the whole tabl$here is no method to remove a particular field only. b. /elete all the fields from third downwards and reenter the re5uired fields again. c. )elect the third column in datasheet view then /elete d. )elect the third row in table design view then /elete 2*. $o duplicate a controls formatting you can use___ a. anager b. Wi(ard c. ;ainter d. ontrol 2,. Which field type will you select when creating a new table if you re5uire to enter long te!t in that field a. $e!t b. emo c. urrency d. 4yperlink 26. +n table design view what are the first column of buttons used for
a. +ndicate ;rimary Dey b. +ndicate urrent 7ow c. 3oth of above d. "one of above &. What & )et offers for the candidates of computer obs e!ams a. /ownloads of & 3anks b. 4uge collection of & 5uestions c. Online & 5ui( d. )ubective 5uestions and answers 28. What does the show check bo! in 5uery design window indicate a. +t indicates whether the field is to be used or not b. +t indicates whether the field is to be displayed in 5uery result or not c. +t indicates whether the field names to be displayed in 5uery result or not d. "one of above 2=. Which of the following is not a type of relationship that can be applied in Access database a. One to One b. One to any c. any to any d. All of above can be applied #?. $his option allows you to build a new table by entering data directly into the datasheet. a. datasheet view b. design view c. link table d. "one of the above #1. $o create 5ueries in Access
a. @ou can drag and drop fields on 5uery builders b. you can type the )&B command in )&B view c. @ou can use 5uery wi(ard or design view d. All of above #2.
a. /atasheet 0iew b. /esign 0iew c. ;ivot $able F ;ivot hart 0iew d. "one of above #6. Which of the following database obect hold data a.
a.
a. /ownloads of & 3anks b. 4uge collection of & 5uestions c. Online & 5ui( d. )ubective 5uestions and answers %*. $he database language that allows you to access or maintain data in a database a. /B b. /B c. //B d. "one of above %,. 7eferential integrity means a. /o not enter a value in the foreign key field of a child table if that value does not e!ist in the primary key of the parent table b. /o not enter a value in the primary key field of child table if that value does not e!ist in the primary key of the parent table c. /o not enter a value in the foreign key field of a parent table if that value does not e!ist in the primary key of the child table d. All of above %6. A __ name must be uni5ue within a database a. $able b.
%=. Which of the following is not a field type in Access a. emo b. 4yperlink c. OBE Obect d. Bookup Wi(ard *?. When entering field name' how many characters you can type in ma!imum a. ,? b. ,% c. ,8 d. Any number of character *1. +t is a database obect to view' change' and analy(e data in different ways a. 5uery b. form c. report d. "one of the above *2. Which of the following creates a drop down list of values to choose from a list a. OBE Obect b. 4yperlink c. emo d. Bookup Wi(ard *#. $o achieve A"/ effect when you are entering criteria in a 5uery design window a. write criteria values vertically one in a row b. write criteria values hori(ontally c. Write criteria values in same field separated with A"/ d. Write criteria values in same field separated with F *%. A search value can be an e!act value or it can be
a. Bogical Operator b. 7elationship c. Wild card character d. omparison operation **. What are the columns in a icrosoft Access table called a. 7ows b. 7ecords c.
a. operator b. 5uery c. e!pression d. "one of the above *=. We can remove a relationship defined between two tables by a.
a. view' change and analy(e data in different ways b. a source of records for forms and reports c. Only a d. 3oth a and b ,%. While creating relationship' when you drag a field of a field to drop into another table the mouse pointer changes into a. a doctor-s sign b. thin H sign c. outline rectangle d. "one of above ,*. Which of the following is a method to create a new table in ) Access a. reate table in /esign 0iew b. reate $able using wi(ard c. reate $able by Entering data d. All of above ,,. +t is most common type of 5uery. +t retrieves records from one or more tables and then displays the a. ;arameter b. )elect c. crosstab d. All of above &. What & )et offers for the candidates of computer obs e!ams a. /ownloads of & 3anks b. 4uge collection of & 5uestions c. Online & 5ui( d. )ubective 5uestions and answers ,6. What is the difference between :Open- and :Open E!clusively-
a. Open statement opens access database files and Open E!clusively opens database files of other program like Oracle b. Open E!clusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed c. 3oth Open and Open E!clusively are same d. Open E!clusive command does not e!ist in ) Access ,8. Which of the following statement is true a. 7eports can be used to retrieve data from tables and calculate b. &ueries can be printed in well formatted manner and presented as the information c. &ueries can include calculated fields that do not e!ist in table d. 7eports and forms are similar but forms are use to print but reports to display on screen only ,=. +t is a 5uery that when run displays its own dialog bo! prompting you for information' such as a. )elect b. crosstab c. ;arameter d. Append 6?. +t is used to calculate and restructure data for easier analysis of your data. +t calculates the sum' a. ;arameter b. )elect c. crosstab d. Append 61. What is the ma!imum length a te!t field can be a. 12? b. 2**
c. 2,* d. 6* 62. Which of the following statement is true a.
c. authori(ing access and other control over database d. "one of above 6,. Which of the following store command to retrieve data from database a.
c. any classes may have many students d. any students may have many classes 81. A part of database that stores only one type of data is a. 7eport b.
c. $able d. 7elationship 8,. $he task of arranging data in order is called a. )earching b. )orting c. Ordering d. )horting 86. Each record is constituted by a number of individual data items which are called a.
c. Online & 5ui( d. )ubective 5uestions and answers =?. $he complete information about an entity in a database is called a. /ata b. +nformation c.
c. /atabases' $ables'
a. $ype ;7+A7@ in field type bo! when creating re5uired field b. ark the ;rimary check bo! in field name of re5uired field c. lick the ;rimary Dey button in /esign ribbon when the cursor is in re5uired field d. "one of the above &. What & )et offers for the candidates of computer obs e!ams a. /ownloads of & 3anks b. 4uge collection of & 5uestions c. Online & 5ui( d. )ubective 5uestions and answers 1??. 4ow can you link a table with another so that a field in current table will display values in drop down bo! from another table while entering dataK a. &uery Wi(ard b. Book up Wi(ard c.
c. /atabase d. +nformation 1?2. +n databases' Bocking level is also called as a. ranularity b. ) lock c. M lock d. /ead lock 1?#. Which of the following is not a database application a. d3ase b.
c. /atabase d. $able &. Why you can rely on & )ets to prepare your computer obs e!ams a. +t offers you to downloads of & 3anks b. & )ets has huge collection of & 5uestions c. Online & &ui( is helpful to practice d. @ou can get subective 5uestions and answers 1?6. +n a datasheet' what does each row represent a. 7ecord b.
c. Auto +ncrement d. Auto 0alue 111. Which obect is used to create a form a. $ables and &ueries b. $ables only c. $ables and reports d. &ueries and reports 112. What determines a table-s sort order a. Auto"umber field b. +nde! field c.
c. )imple 5uery wi(ard d. $able 5uery wi(ard 11*. Which of the following is not a view for interacting with a form obect a. /atasheet view b. /esign view c.
c. )tructured &uery Banguage d. )mall &uery Bength 12?. Which data type is better to use for storing phone number in the following format N=6691912#%*,6 a. $e!t b. Auto"umber c. "umber d. urrency &. Why you can rely on & )ets to prepare your computer obs e!ams a. +t offers you to downloads of & 3anks b. & )ets has huge collection of & 5uestions c. Online & &ui( is helpful to practice d. @ou can get subective 5uestions and answers 121. What do you call a collection of records matching parameters of a 5uery a.
a. (ipcode' firstname' lastname b. firstname' lastname' (ipcode c. (ipcode' lastname' firstname d. can-t sort by multiple fields 12%. What does the e!pression QdetailR S QproductR C 1.#? do a. multiplies the contents of detail and product fields by 1.# b.
a. )earch 5uery b. ross tab 5uery c. )elect 5uery d. Gpdate 5uery 128. What is the result of :)elect C from customer where ust+/V1? and ust+/1??5uery a. display all customers with ust+/ from 1? to 1?? b. display all customers with ust+/ above 1? c. display all customers with ust+/ below 1?? d. display all customers with ust+/ from 11 to == 12=. 4ow to make a date field /O3 store the dates like N2??21?16 a. 3y setting the input mask property to Nyyyymmdd b. 3y setting the format property to Nyyyymmdd c. 3y entering dates in yyyy' mm' dd order d. none of the above 1#?. @ou have field :)e!- of type 3yte "umber. 4ow to limit its value to ? and 1 only a. 3y setting re5uired to :@es b. 3y using default value c. 3y defining validation rule d. 3y using format 1#1. +n an application created using the database wi(ard' the main menu is presented as aK a. form' called a switchboard b. report' called a menu c. table' called a switchboard d. 5uery' called a menu 1#2. Which leads you through the process of creating a table
a. wi(ard b. assistant c. relation d. coach 1##. Which data type is better to use for storing the price of an item a. $e!t b. Auto"umber c. "umber d. urrency 1#%. Which do you click to display the tableX-s primary key and inde!es in a separate window a. inde!es button b. primary key button c. view datasheet button d. view design button 1#*. After right click the field selector button' which do you choose to delete a field in design view a. /elete field b. delete rows c. remove field d. remove rows &. Why you can rely on & )ets to prepare your computer obs e!ams a. +t offers you to downloads of & 3anks b. & )ets has huge collection of & 5uestions c. Online & &ui( is helpful to practice d. @ou can get subective 5uestions and answers 1#,. Which tool is used to generate printout of a tableX-s structure
a. Analy(er b. /esigner c. /ocumenter d. enerator 1#6. Which of the following is not a legitimate section for form obects a.
a. /atasheet view b. /esign view c. ;rint preview d. Bayout preview 1%2. $he report footer section is most useful for displayingK a. grand totals b. olumn headings c. subtotals d. page numbers 1%#. Which function can not be used for calculated controls in a report a. )G b. A0 c. ;$ d. OG"$ 1%%. Which setting you must modify to print a report using letterhead a. roup b. argin c. )ection d. Orientation 1%*. +n the datasheet formatting dialogue bo!' which is not an option in the border and line styles dropdown list bo! a. datasheet border b. datasheet underline c. olumn 4eader underline d. vertical gridline 1%,. Which is not an option for customi(ing a datasheet window
a. change one rowX-s height b. hide one column c. change one columnX-s width d. free(e one column 1%6. Which is not a command that is selectable from right click menu of a field column a. 4ide columns b. 7ename columns c. free(e columns d. sort descending &. Why you can rely on & )ets to prepare your computer obs e!ams a. +t offers you to downloads of & 3anks b. & )ets has huge collection of & 5uestions c. Online & &ui( is helpful to practice d. @ou can get subective 5uestions and answers 1%8. What do you call the process of restricting the display of records in a table to those matching a particular criterion a. filtering b. restricting c. sorting d. sifting 1%=. +n the relationships window' what does the appearance of symbols' such as 1 and the infinity symbol' at the endpoints of a relationship line mean a. 7eferential integrity is enforced b. 7eferential integrity isnX-t enforced c. An inner oin is set d. An outer oin is set 1*?. Which of the following is not an action 5uery
a. add b. delete c. make9table d. update 1*1. +n ) Access' $e!t /ata type may contain ma!imum character of a. 2** haracter b. 2*, haracter c. 1?,% haracter d. "o Bimit 1*2. Which of the following is not a valid /ata $ype in ) Access a. emo b. ;icture c. urrency d. Auto"umber 1*#. +n ) Access N4yperlink /ata $ype can store a. Web Address b. email Address c. ;ath of a
a. /ate$ime b. $ime Only c. $ime d. $ime cannot be stored 1*,. +n ) Access NBookup Wi(ard is used to a. to select from previous values b. to select values from E!cel )heet c. to select value from another table d. "ot a valid /ata $ype 1*6. Which of the following /ata $ype is used to store picture in ) Access a. ;icture b. OBE Obect c. emo d. ;icture cannot be stored 1*8. in ) Access' which data type is appropriate to store large te!t and numbers a. $e!t b. emo c. OBE d. Barge $e!t 1*=. in ) Access' OBE Obect /ata type can store a. icrosoft Word documents b. icrosoft E!cel spreadsheets c. )ounds d. All of the Above 1,?. in ) Access' Auto"umber /ata $ype
a. an be )e5uential b. an be 7andom c. an be Edited d. Only A F 3 &. Why you can rely on & )ets to prepare your computer obs e!ams a. +t offers you to downloads of & 3anks b. & )ets has huge collection of & 5uestions c. Online & &ui( is helpful to practice d. @ou can get subective 5uestions and answers 1,1. Which of the following is use to get data from user a. &uery b. ;ages c.
a. /atabase should be created before create table b. $able can be created using $able $emplates c. $here must be at least one ;rimary key in a table d. All of the above 1,*. Which of the following is use to view or print the data in organi(ed manner a. &uery b. 7eport c. $able d.
a. )ingle $able b. ultiple $ables c. 3oth A F 3 d. 16?. /ata can be import into Access /atabase from a. Word
16%. Which of the following relationship is not valid in ) Access a. any to any b. any to "ull c. One to One d. One to any 16*. A collection of related tables is called a. 7ow b. 7ecord c. /atabase d.
a. +t offers you to downloads of & 3anks b. & )ets has huge collection of & 5uestions c. Online & &ui( is helpful to practice d. @ou can get subective 5uestions and answers 16=. What is the use of ascade /elete Option in ) Access a. +t makes sure that all the records from the parent table and child table is deleted from selected database b. +t makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted c. +t makes sure that all the related records will be deleted automatically from ;arent table when the records from child table is deleted d. "one of above 18?. acros can recover from _______ in a controlled manner. a. events b. modules c. arguments d. errors 181. A report module includes code for all event _______ triggered by events occurring on a specific report or its controls. a. properties b. procedures c. macros d. commands 182. $he 03 "ame used to display the warning message icon is _______. a. vbritical b. vb+nformation c. vbE!clamation d. vb&uestion
18#. What happens when a user double9clicks an obect in the ;roect pane of the 0isual 3asic Editor a. $he associated code is displayed in the ode pane. b. $he associated code is displayed in a new window. c. $he obect is deleted from the ;roect pane. d. $he obectX-s property sheet opens. 18%. AInJ _______ is maor obect that completes an action or a set of actions. a. event b. property c. procedure d. macro 18*. 3y default' what is the name of a new module in the odules folder of the ;roect pane called a. 3as1 b. odule c. "ew odule d. odule1 18,. $o assign a macro to an event' users need to open the form in /esign 0iew. a. event b. property c. title d. macro 186. +n a module' the 03 "ame used to display a warning 5uery icon is _______. a. vbritical b. vb+nformation c. vbE!clamation d. vb&uestion
188. +n a module' aInJ _______ is a series of commands and properties that perform a specific task. a. event b. property c. procedure d. macro 18=. AInJ_______ is a maor obect that can run independent of a control. a. event b. property c. procedure d. macro 1=?. Which of the following statements about option group is incorrect a. +t is a control obect. b. +t is bound to two fields. c. +t is a control to identify a choice. d. +t contains a set of controls representing choices. 1=1. $he option button ____ identifies each button or check bo! in an option group. a. event b. frame c. label d. value &. Why you can rely on & )ets to prepare your computer obs e!ams a. +t offers you to downloads of & 3anks b. & )ets has huge collection of & 5uestions c. Online & &ui( is helpful to practice d. @ou can get subective 5uestions and answers
1=2. Which of the following statements about a tab control in a form is incorrect a. +t can contain only one obect. b. +t defines a layered space. c. +t is a control obect. d. +t is created in multipage forms. 1=#. $he option group ____ describes the contents of the entire option group. a. event b. frame c. label d. value 1=%. AInJ ____ is the default control for a @es"o field. a. check bo! b. option button c. toggle button d. list bo! 1=*. Which of the following components has a property sheet that includes settings for the frame and the option group a. Option group label b. Option group frame c. Option button d. Option button labels 1=,. Which control lets a user create multiple pages in a form a. heck bo! control b. ombo bo! control c. Option group control d. $ab control
1=6. On the property sheet' which of the following tabs contains the aption property a. /ata b. Event c.
1?1 L c 1?2 L a 1?# L b 1?% L a 1?* L a 1?, L b 1?6 L a 1?8 L b 1?= L a 11? L b 111 L a 112 L b 11# L c 11% L c 11* L d 11, L b 116 L d 118 L b 11= L c 12? L a 121 L d 122 L c 12# L c 12% L d 12* L b 12, L d 126 L c 128 L d 12= L b 1#? L c 1#1 L a 1#2 L a 1## L d 1#% L a 1#* L b 1#, L c 1#6 L b 1#8 L a 1#= L c 1%? L c 1%1 L a 1%2 L a 1%# L c 1%% L b 1%* L c 1%, L a 1%6 L b 1%8 L a 1%= L a 1*? L a 1*1 L a 1*2 L b 1*# L d 1*% L c 1** L a 1*, L c 1*6 L b 1*8 L b 1*= L d 1,? L d 1,1 L c 1,2 L a 1,# L d 1,% L d 1,* L b 1,, L a 1,6 L d 1,8 L a 1,= L c 16? L b 161 L a 162 L d 16# L d 16% L b 16* L c 16, L d 166 L d 168 L a 16= L b 18? L a 181 L b 182 L c 18# L a 18% L d 18* L d 18, L a 186 L d 188 L c 18= L d 1=? L b 1=1 L c 1=2 L a 1=# L c 1=% L a 1=* L b 1=, L d 1=6 L c 1=8 L a 1== L d 2?? L b 2?1. +n Access 2??6' to make changes in the $rust enter' you need to go to the ____. a. icrosoft Office button b. "avigation ;ane c. &uick Access toolbar d. /atabase $ools command tab 2?2.
c. 4yper$e!t arkup Banguage d. 4yperlink $ransfer arkup Banguage 2?*. +n Access 2??6' to set a table to open as a document tab' you need to go to the ____. a. icrosoft Office button b. "avigation ;ane c. &uick Access toolbar d. /atabase $ools command tab 2?,. Which of the following is the file e!tension for an E!tensible arkup Banguage a. EB b. 4$B c. MB d. M)/ 2?6. AInJ __________ is an E!tensible )cheme )tandard file that is an approved W# standard design as a basic infrastructure. a. 4$B b. MB c. M)/ d. M)B 2?8. A disadvantage to a ____file is that there is no easy way to tell which fields are numbers' te!t' dates' or currency. a. standardi(ed b. fi!ed c. delimited d. te!t &. What & )et offers for the candidates of computer obs e!ams
a. /ownloads of & 3anks b. 4uge collection of & 5uestions c. Online & 5ui( d. )ubective 5uestions and answers 2?=. AInJ _____ is an image control that displays in the background of a page on a form or report. a. legend b. icon c. logo d. watermark 21?. Which colors are used to define a custom color a. 7ed' 3lue' @ellow b. 7ed' reen' 3lue c. 3lue' reen' Orange d. reen' Orange' 0iolet 211. +f a color property contains NU##,,==' how many blue units are in the color a. ## b. ,, c. == d. 2** 212. $he _____ function returns a string that has been converted to uppercase te!t. a. Allap b. Gase c. Gpase d. Gpper 21#. Which part of the ++< e!pression is the action performed if the true condition e!ists
a. inner b. first c. second d. third 21%. +f you need a calculation in an unbound control' you can create a custom _____. a. string b. e!pression c. relationship d. synta! 21*. $he _____ 3uilder is an Access tool for selecting colors from a palette or creating custom colors. a. olor b. E!pression c. ;alette d. ;roperty 21,. Which function evaluates a Ntruefalse e!pression and then performs one of two actions a. ase b. +< c. ++< d. +s$rue 216. When adding an image' which si(e mode will change the height or width of the image fit the control a. lip b. )tretch c. Yoom d. rop
218. $he three parts of an ++< function are separated by _____. a. dashes b. asterisks c. semicolons d. commas 21=. A )mart $ag can be set using the _____ tab in the property sheet. a.
222. 4ow can a user open the E!pression 3uilder dialog bo! a. 3y clicking the drop9down arrow on the ontrol )ource property b. 3y clicking the drop9down arrow of the +nput ask property in the /ata tab c. 3y clicking the 3uild button of the +nput ask in the /ata tab d. 3y clicking the 3uild button of the ontrol )ource property in the /ata tab 22#. According to the Bes(ynski "aming onventions' which of the following is the prefi! for a combo bo! control a. cbo b. cob c. cmb d. cb! 22%. @ou have a ommand button in the
c. alendar d. Appointment 226. $he _____ )ymbol )mart $ag launches icrosoft E!plorer and obtains a stock 5uote. a. )" oney b. ;ortfolio c.
c. onthBabel d. onth0alue 2#2. Which of the following 5ueries prompts users for input data by displaying dialog bo!es a. Append b. /elete c. ;arameter d. Gpdate 2##. AInJ _______________ 5uery makes changes to or moves records in a dynaset' in a single operation. a. select b. summary c. parameter d. action 2#%. Which of the following 5ueries modifies fields not records a. Append b. /elete c. ake9$able d. Gpdate 2#*. A summary 5uery can be created by adding which row to the design grid of a select 5uery a. Arguments b. roup c. )ummary d. $otal 2#,. Which of the following functions is used to all the values in a numeric field
a. "um b. ount c. )um d. $otal &. What & )et offers for the candidates of computer obs e!ams a. /ownloads of & 3anks b. 4uge collection of & 5uestions c. Online & 5ui( d. )ubective 5uestions and answers 2#6. Which of the following 5ueries can create a table a. Append b. /elete c. ake9$able d. Gpdate 2#8. +n a 5uery' which row do you need to place wildcards to affect a parameter a. Arguments b. riteria c.
2%?. Which of the following types of oins displays records with the same value in the common field a. +nner oin b. Beft outer oin c. 7ight outer oin d. )elf oin 2%1. A global oin will be created automatically when using tables in aInJ _____. a. form b. report c. 5uery d. field 2%2. Which of the following is the default oin between two recordsets a. +nner oin b. Beft outer oin c. 7ight outer oin d. )elf oin 2%#. +n a 5ueryX-s /esign 0iew' right9clicking the sloping portion of the oin line between two tables and selecting /elete will delete what a. $he oin line but not the relationship between the two tables b. $he relationship between the two tables locally c. $he relationship between the two tables globally d. $he primary key of the first table 2%%. What is an inde! a. A wi(ard that creates a functional database structure based on the userX-s selections b. A widely recogni(ed naming convention for database obects c. A sort order for records' which is identified in the table design d. A set of relationship rules that enforce defined database relationships
2%*. @ou created a 5uery with two tables that did "O$ have a oin line. $he first table has 12 records and the second has *. $he resulting recordset would have how many records a. 6 b. 16 c. ,? d. "ot enough information to tell 2%,. Which of the following dialog bo!es enables users to enforce referential integrity in a One9$o9any relationship a. Edit 7elationships b. +nde!es c. Option d. )how $able 2%6. +n a unction table' the _____ field consists of the foreign key from both the linked tables. a. first defined b. last defined c. foreign key d. primary key 2%8. What does an inner oin display a. 7ecords from the second recordset and only records from the first recordset where the common fields are e5ual b. 7ecords from the first recordset and only records from the second recordset where the common fields are e5ual c. 7ecords that have the same value in the common field d. 7ecords from the first recordset only 2%=. $he page count of a report can be determined by clicking the _______ button.
a.
a. /esign 0iew b. Bayout 0iew c. ;rint ;review d. 7eport 0iew 2**. Which report section prints once at the bottom of every printed page a. /etail b. ;age 4eader c. ;age
a. /atasheet b. /esign c. ustified c. )tacked d. $abular 2,1. Which
a. Align b. 3ound c. alculated d. Gnbound 2,%. When increasing the ontrol ;adding' space is added where a. 3etween the content of the controls and the outside edge of then controls b. 3etween all controls c. 3etween the control and the
a. lip b.
a. 3etween b. +s "ull c. Bike d. "ot 26%. What is the process of eliminating redundant fields by separating data into tables called a. 7enormali(ations b.
266. +n a 5uery' using the keyword _______________ will return records in which the field value is between two numbers. a. 3etween b. +s "ull c. Bike d. "ot 268. Which of the following database obects e!tracts information from one or more tables or 5ueries a.
c. foreign' primary d. foreign' common 282. 7eferential integrity can be enforced if both _______________ belong to the same icrosoft Access database. a. 5ueries b. fields c. records d. tables 28#. +n the 7elationship window' related fields from each table are connected by aInJ _______________. a. default field b. linking tables tables c. inde! d. oin line 28%. 7elationships between tables can be graphically viewed in the _______________ window. a. /esign b. >oins c. 7elationshi 7elationships ps d. $ables 28*. A One9$o9any relationship relationship that is not enforcing referential integrity' displays what symbol symbol ne!t to the foreign foreign key field a. 1 b. c. r d. "one 28,. +n the
a. bold b. italici(ed c. underlined d. with key icon 286. What type of relationsh relationship ip is created when you select a primary key in both related tables a. One9$o9One b. +ndeterminate +ndeterminate c. One9$o9any d. any9$o9any 288. $he $able _______________ Wi(ard analy(es a database and recommends changes for normali(ation. a. Analy(er b. /ocumenter /ocumenter c. leanup d. "ormali(at "ormali(ation ion 28=. $he +nput ask wi(ard does "O$ include the ability to do which of the following a.
2=1. Which of the following field properties is an e!pression that specifies criteria or re5uirements re5uiremen ts for entering data a.
c.
c. Online & 5ui( d. )ubective 5uestions and answers #??. AInJ _____________ is dynamic mathematical calculation that displays a single value for a specific field. a. format row b. criteria row c. aggregate function d. format layout AnswersK lick the Bike' $weet or oogleH buttons below to show correct answersK &."o9orrect Answer 2?1 L a 2?2 L d 2?# L a 2?% L c 2?* L a 2?, L c 2?6 L c 2?8 L d 2?= L d 21? L b
211 L c 212 L b 21# L c 21% L b 21* L a 21, L c 216 L b 218 L d 21= L d 22? L d 221 L a 222 L d 22# L a 22% L c 22* L a 22, L a 226 L c 228 L c
22= L a 2#? L a 2#1 L b 2#2 L c 2## L d 2#% L d 2#* L d 2#, L b 2#6 L c 2#8 L b 2#= L c 2%? L a 2%1 L b 2%2 L a 2%# L b 2%% L c 2%* L c 2%, L a
2%6 L c 2%8 L c 2%= L d 2*? L b 2*1 L b 2*2 L b 2*# L c 2*% L b 2** L c 2*, L c 2*6 L c 2*8 L a 2*= L b 2,? L d 2,1 L d 2,2 L c 2,# L b 2,% L b
2,* L a 2,, L a 2,6 L b 2,8 L d 2,= L c 26? L c 261 L a 262 L c 26# L c 26% L c 26* L d 26, L a 266 L a 268 L b 26= L b 28? L b 281 L a 282 L d
28# L d 28% L c 28* L d 28, L d 286 L a 288 L a 28= L a 2=? L c 2=1 L d 2=2 L c 2=# L c 2=% L b 2=* L a 2=, L c 2=6 L a 2=8 L d 2== L a #?? L c
MICROSOFT ACCESS INTERVIEW Questions and Answers :: #?1. $he content and application of the )earch tool A""O$ be retained when you ______. a. format an obect b. resi(e a column c. use /atasheet 0iew d. close an obect #?2. $he )earch tool A""O$ be used on which maor Access obect a.
a. +t offers & collection b. +t allows to download & 3anks c. @ou can get your answers through subective 5uestionsanswers d. +t has online & 5ui( system #?*. Which is not an option for
a. /esign 0iew b. /atasheet 0iew c. Office 0iew d. ;rint ;review #1?. What is the keyboard shortcut to move to the last records in a table a. Q$abR b. Q)hiftRHQ$abR c. QtrlRH4omeR d. QtrlRHQEndR #11. A ____ is a maor database obect used to display information in an attractive' easy9to9read screen format. a. form b. 5uery c. report d. table #12. ;rint options can be changed in the ;rint ____. a. tab b. layout mode c. setup routine d. dialog bo! #1#. Which maor database obect stores all data a.
a. 49pointer b. +9pointer c. 49beam d. +9beam #1*. Access file operations can be found by clicking the ____. a. Access 3utton b. /atabase 3utton 3utton c. Office 3utton d. Window 3utton &. & )ets is helpful to prepare your e!ams because a. +t offers & collection b. +t allows to to download & 3anks c. @ou can get your answers through subective 5uestionsanswers 5uestionsanswers d. +t has online & 5ui( system #1,. A ____ is a maor database obect used to display information information in a printable page format. a. form b. 5uery c. report d. table #16. +n /atasheet 0iew' new records are added to a table ____. a. in alphabetical order b. at the end of the table table c. at the beginning of the table d. in numerical order #18. What happens when a user selects a record in a form and presses Q/eleteR
a. $he record is deleted in the form and from its source table. b. $he record is deleted deleted in the form' form' but not from its its source table. table. c. $he record is neither deleted in the form' nor from its source table. d. $he record is not deleted in the form' but is deleted from its source table. #1=. Which of the following A""O$ be done to data using a
a. icon b. button c. thumb tack d. paperclip #2%. Which of the following methods A""O$ be used to delete records from a table a. )electing records and pressing Q/eleteR b. ;ressing QtrlRHQX-R QtrlRHQX-R c. licking the /elete 7ecord button d.
a. scalability b. e!pandability c. maintainability d. platform9independence #2=. $he most open source /3). a. icrosoft )&B )erver b. icrosoft Access c. y)&B d. Oracle ##?. A /3) that runs on many different operating systems is said to be __________. a. scalable b. robust c. platform independent d. distributed ##1. )earch engines use aInJ __________ to automatically inde! sites. a. crawler b. 5uery c. enterprise d. sitebuilder &. & )ets is helpful to prepare your e!ams because a. +t offers & collection b. +t allows to download & 3anks c. @ou can get your answers through subective 5uestionsanswers d. +t has online & 5ui( system ##2. $he __________ performs document tracking.
a. distributed application b. enterprise software c. Oracle software d. E/ software ###. An enterprise solution with data storage' a client interface and a security system is aInJ __________ system. a. 29tier b. #9tier c. %9tier d. n9tier ##%. __________ will answer 5uestions you did not think to ask of your data. a. data mining b. data e!trapolation c. knowledge discovery d. data enlightenment ##*. __________ is the clear leader for personal databases. a. icrosoft Access b. icrosoft
a.
a. form b. report c. 5uery d. macro #%#. $o store your picture in a database re5uires aInJ __________ field. a. 3BO3 b. te!t c. image d. logical #%%. $he __________ is used to access one record at a time. a. 5uery b. filter c. form d. report &. & )ets is helpful to prepare your e!ams because a. +t offers & collection b. +t allows to download & 3anks c. @ou can get your answers through subective 5uestionsanswers d. +t has online & 5ui( system #%*. )&B stands for __________. a. )tandard &uery Banguage b. )tructured &uery Banguage c. )implified &uery Banguage d. )tatic &uery Banguage #%,. What are the different views to display a table
a. /atasheet view b. /esign view c. ;ivote table F pivot chart view d. All of above #%6. Which of the following creates a drop down list of values to choose from a. Ole obect b. 4yperlink c. emo d. Bookup wi(ard #%8. $he command center of access file that appears when you create or open the ) Access database file. a. /atabase window b. &uery window c. /esign view window d. )witchboard #%=. +n a database table' the category of information is called __________ a. $uple b.
a. /ata definition b. /ata refinement c. Establishing relationship d. "one of the above #*2. Which of the field has width 8 bytes a. emo b. "umber c. /atetime d. 4yperlink #*#. Which of the following statement is true a.
a. hange the structure of tables b. +nsert' update or delete records and data values c. Authori(ing access and other control over database d. "one of above #*6. $he database language that allows you to access or maintain data in a database a. /cl b. /ml c. /dl d. "one of above #*8. What is the ma!imum length a te!t field can be a. 12? b. 2** c. 2,* d. 6* #*=. which of the following is not a database obect a. $ables b. &ueries c. 7elationships d. 7eports #,?. A __________ enables you to view data from a table based on a specific criterion a.
a. 7ows b. 7ecords c.
a.
#6?. Which of the following is not a field type in access a. emo b. 4yperlink c. Ole obect d. Bookup wi(ard #61. Which field type can store photos a. 4yperlink b. Ole c. 3oth of these can be used d. Access tables can-t store photos #62. When entering field name' how many characters you can type in ma!imum a. ,? b. ,% c. ,8 d. Any number of character #6#. After entering all fields re5uired for a table' if you reali(e that the third field is not needed' how will you remove a. @ou need to delete the whole table. $here is no method to remove a particular field only. b. /elete all the fields from third downwards and reenter the re5uired fields again. c. )elect the third column in datasheet view then delete d. )elect the third row in table design view then delete #6%. &ueries in access can be used as a. 0iew' change and analy(e data in different ways b. A source of records for forms and reports c. Only a d. 3oth a and b
#6*. $o create 5ueries in access a. @ou can drag and drop fields on 5uery builders b. @ou can type the s5l command in s5l view c. @ou can use 5uery wi(ard or design view d. All of above #6,. What is a form in ) Access a. +t is a printed page where users will write their data to fill it up b. +t is an input screen designed to make the viewing and entering data easier c. $his is an important part of database used by analysts to draw conclusions d. All of above #66. Which of the following statement is true a. 7eports can be used to retrieve data from tables and calculate b. &ueries can be printed in well formatted manner and presented as the information c. &ueries can include calculated fields that do not e!ist in table d. 7eports and forms are similar but forms are use to print but reports to display on screen only #68. $wo tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command a.
#6=. While creating relationship' when you drag a field of a field to drop into another table the mouse pointer changes into a. A doctor-s sign b. $hin H sign c. Outline rectangle d. "one of above #8?. What do you mean by one to many relationship between student and class table a. One student can have many classes b. One class may have many student c. any classes may have many students d. any students may have manu classes #81. 7eferential integrity means a. /o not enter a value in the foreign key field of a child table if that value does not e!ist in the primary key of the parent table b. /o not enter a value in the primary key field of chield table if that value does not e!ist in the primary key of the parent table c. /o not enter a value in the foreign key field of a parent table if that value does not e!ist in the primary key of the child table d. All of above #82. ascade delete option a. +s used to delete all the records of all tables in a database b. Will repeat the recent delete operation to all the records of current table c. +s available in edit relatiionship dialog bo! which makes sure that all the related records will be deleted automatically whn the record from parent table is deleted d. "one of above #8#. ascade update option
a. eans do not change the value in the primary key field if that record has related records in another table b. eans change all the related records in child tables if the record in parent table is changed c. 3oth of above d. "one of above #8%. We can remove a relationship defined between two tables by a.
a. Bogical operator b. 7elationship c. Wild card character d. omparison operation #8=. 3oth conditions display on the same row in the design grid when ___operator is in use a. Or b. +n c. And d. Bike #=?. @ou can automatically include all of the field in a table in a 5uery by___ a strike that appear list bo! in 5uery design view a. licking b. 7ight clicking c. /ouble clicking d. "one of the above #=1. $he___ operator will cause a record to be selected only if two or more conditions are satisfied a. Or b. +f or c. 7ange d. And #=2. When a picture or other graphic image is placed in the report header section it will appear____ a. Once in the bugging of the report b. At the top of every page c. Every after record break d. On the 1st and last pages of the report
#=#. $he__ button on the tool bo! display data from a related table a. )ub form sub report b. 7elationships c. )elect obects d. ore controls #=%. @ou can set a controls border type to make the border invisible. a. $ransparent b. +nvisible c. /o not display d. "o border #=*. A __ name must be uni5ue within a database a. $able b.
#=8. Gnlike te!t data type' this can store up to ma!imum of ,*' *#* characters. a. emo b. /atatime c. "umber d. All of above &. & )ets is helpful to prepare your e!ams because a. +t offers & collection b. +t allows to download & 3anks c. @ou can get your answers through subective 5uestionsanswers d. +t has online & 5ui( system #==. +t is a database obect to view' change' and analy(e data in different ways a. &uery b.
#?1 L d #?2 L c #?# L d #?% L b #?* L b #?, L a #?6 L c #?8 L d #?= L d #1? L d #11 L a #12 L d #1# L d #1% L d #1* L c #1, L c #16 L b #18 L a
#1= L a #2? L a #21 L c #22 L c #2# L d #2% L b #2* L d #2, L b #26 L d #28 L a #2= L c ##? L c ##1 L a ##2 L d ### L b ##% L c ##* L a ##, L b
##6 L a ##8 L c ##= L d #%? L a #%1 L c #%2 L b #%# L a #%% L c #%* L b #%, L d #%6 L d #%8 L a #%= L b #*? L b #*1 L a #*2 L c #*# L c #*% L d
#** L a #*, L c #*6 L a #*8 L b #*= L c #,? L b #,1 L c #,2 L c #,# L d #,% L c #,* L b #,, L b #,6 L d #,8 L d #,= L a #6? L d #61 L b #62 L b
#6# L d #6% L d #6* L d #6, L b #66 L c #68 L d #6= L c #8? L a #81 L a #82 L c #8# L c #8% L b #8* L c #8, L a #86 L b #88 L c #8= L c #=? L c
#=1 L d #=2 L a #=# L a #=% L c #=* L a #=, L b #=6 L a #=8 L a #== L a %?? L b %?1. +t is a 5uery that when run displays its own dialog bo! prompting you for information' such as a. )elect b. rosstab c. ;arameter d. Append %?2. +t is used to calculate and restructure data for easier analysis of your data. +t calculates the sum' a. ;arameter b. )elect c. rosstab d. Append %?#. +t is a sign or symbol that specifies' operator' and values that produce a result
a. Operator b. &uery c. E!pression d. "one of the above %?%. Which of the following database obect is created first before any other created a. $able b. oined %?,. $he :filter by selection- allows you to filter those records a. $hat match the selected field b. $hat match the criteria specified specified c. $hat meet any of several criteria specified d. All of above %?6. $he operation of checking input data against specified criteria is known as
a. /ata verification v erification b. /ata validation validation c. ross check d. /ata control %?8. )ome rules are set in databases to check and permit only correct values. What is this feature called a. /ata verification v erification b. Auditing c. /ata filtering d. /ata validation %?=. /atabase access levels are specified so as to define who can access what in a database. +t is identified through a. Gser id b. ;assword c. )tatus d. "one of above %1?. What it is called to present information in a particular order based on numeric or alphabeticall value alphabetica a. )orting b. )earching c. Arranging d. ropping %11. A collection of related records in database is known as a a. $able b. /atabase c.
%12. A part of database that stores complete information about an entity such as employee' sales' orders etc. a.
c. U d. X %16. +n access' this displays the results of a calculation in a 5uery a. Bookup field b. alculated field c. )ource field d. hild field %18. +n access' this operation copies a backup file from the storage medium back onto the computer a. 7ecreate b. 7estore c. opy d. )tructure %1=. +f you make an invalid entry in the input mask wi(ard dialog bo!' this will display to advise you that the entry is not correct a. $e!t error b. 0alidation error c. Biteral error d. Entry error %2?. +n the form wi(ard dialog bo!' the fields from the selected table are displayed in this list bo!. a. All fields b. All records c. Available records d. Available fields %21. $his form displays the field name labels down the left side of the column' with the data for each field ust to the right of its corresponding label.
a. $abular b. >ustified c. olumnar d. /atasheet %22. $his form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading. a. olumnar b. >ustified c. /atasheet d. $abular %2#. $his form displays multiple records' one per row' in the form window a. /atasheet b. $abular c. olumnar d. >ustified %2%. +n this form' a single record may appear in multiple rows in the form window in order to fully display the field name label and data. a. /atasheet b. $abular c. >ustified d. olumnar %2*. Which of the following is not a form style available in the form wi(ard dialog bo!. a. 3lends b. )tandard c. )tone d. 4ighlights %2,. @ou can move between fields in a form by using any of these keys e!cept
a. $ab b. Enter c. )hiftHtab d. ;age up %26. &ueries are based on this' allowing you to use a 5uery as the source for forms and reports a.
%#?. $his 5uery wi(ard will create a select 5uery. a. rosstab b.
c.
a. lick on the three dots to the right of the caption entry field b. lick on the three dots to the right of the format entry field c. lick on the input mask toolbar d. lick on the three dots to the right of the input mask entry field %%?. )aving a database in access is done a. At the beginning of the database b. $he first time you save data c. When closing the application d. /uring auto save %%1. $he file e!tension for an access 2??# database is a. E!e b. /oc c. E!c d. db %%2. Which of the following best describes the grouped report a. A part of report that can be generated by the report wi(ard b. A report that displays data that has been sorted in ascending or descending order c. A report that displays data grouped by fields you specify d. "one of a the above %%#. What is the use of description field in table design window a. $he description will be displayed on status bar when entering data in datasheet view b. $he description will be displayed on status bar when entering data in form c. 3oth of above d. "one of a the above %%%. 4ow can you display the related records from other tables in datasheet view
a. lick on the e!pand indicator ne!t to the record b. /ouble click on the record to e!pand it c. Apply filter by command to display related records d. All of above %%*. Which of the following 5uery type is best suitable to analy(e data a. ross tab 5ueries b. ;arameter 5ueries c. Action 5ueries d. "one of above %%,. Which of the following is a database management system a. s word b. s e!cel c. Oracle d. Botus 1929# %%6. +n relational database schema each tuple is divided into fields known as a. 7elations b. &ueries c. 7ecords d. /omains &. 0isit & )ets for a. ultiple hoice &uestions ollection b. /ownload & 3anks c. Attempt online 5ui( d. )tudy subective 5uestionsanswers %%8. Which of the following columns does not e!ist in macro design window
a. Arguments b. omments c. onditions d. Actions %%=. What is the type of 5uery that e!tracts data from a table and puts them into separate table a. ;arameter 5uery b. ake table 5uery c. Gpdate 5uery d. ;ut table 5uery %*?. What type of control in a form can display data from database table a. 3ound control b. Gnbound control c. 3oth of above d. "one of above %*1. $o display value from table for a label control a. )et teh control source and record source prom property panel b. hoose the databse' table' field and select data value to display c. Book at the table and type value in the caption d. )et the record source property and then control source %*2. Which of the following is not a section in report design window a. 7eport header section b. ;age header section c. )ummary section d. 7eport footer section %*#. @ou can not import data into access database from
a. /base iii database files b. E!cel spreadsheets c. omma delimited te!t files d. "one of the above %*%. Which control does access use to link data access page components to Access data a. icrosoft dynamic data control b. icrosoft data connection control c. icrosoft office data source control d. "one of the above %**. which program do you use to edit code for data access pages a. icrosoft script editor b. icrosoft code editor c. icrosoft data access pages editor d. "one of above %*,. the way a particular application views the data from the database that the applicaton uses is a a. odule b. 7elational model c. )chema d. )ub9schema %*6. which of the following is a database management system a. s9word b. Botus 1929# c. Oracle d. "one of above %*8. what is the corresponding te!t for the U11=*U validation rule setting
a. "eter a value less or more than 1'1=* b. 0alue must be less than =* characters c. Enter a date before 1==* d. All of above %*=. what is the name of the visual basic editor utility that allows you to view the icrosoft Access type library-s available obects and members a. Obect viewer b. Obect browser c. $ype library spy d. "one of above %,?. a computer language for informing the dbms regarding the data structure used is a. ;ascal b. /dl c. ;rolog d.
a. ultiple hoice &uestions ollection b. /ownload & 3anks c. Attempt online 5ui( d. )tudy subective 5uestionsanswers %,#. which of the following is not a type of icrosoft Access database obect a. &ueries b. Workbooks c.
a. 7ecord b. $itle c. Bist d. )tring %,8. which of the following terms does not describe a database structure used by a dbms to link data from several files a. 7elational b. )tructural c. "etwork d. All of the above %,=. in a relational schema' each tuple is divided into fields called a. 7elations b. /omains c. &ueries d. All of the above %6?. how do you filter by selection a. 7ight click the field value and select filter by selection from the shortcut menu b.
a. 7ows b.
a. )et the record set type to snapshot b. Gse the compact and repair database tool c. reate a replica of the database d. All of the above %68. $he arranging of data in a logical se5uence is called a. )orting b. lassifying c. 7eproducing d. )ummari(ing &. 0isit & )ets for a. ultiple hoice &uestions ollection b. /ownload & 3anks c. Attempt online 5ui( d. )tudy subective 5uestionsanswers %6=. According to access help' what-s a good way to design a database a. )tart from data access pages and work backward b. )ketch the design of your database using a pencil and paper c. Gse the table analy(er to reverse9engineer your flat source data. d. "one of above %8?. +f a piece of data is stored in two places in the database' then a a. )torage space is wasted b. hanging the data is one spot will cause data inconsistency c. +t can be more easily accessed d. 3oth a and b %81. A relational database management I7/3)J package manages data in more than one file at once. 4ow does it organi(e these file As
a. $ables b. 7elations c. $uple d. 3oth a and b %82. Which of the following database obects asks a 5uestion of information in a database and then displays the result a. $ables b. 7eports c. &ueries d.
a. $he table will not include any fields from the table b. $he 5uery sorts the table-s record in the order you specify c. $he 5uery will include every field from the table d. $he 5uery uses the records from the table without displaying them %86. Which editor was provided for use with access basic a. $he visual basic 1.? editor b. "otepad c. $he 5uickbasic editor d. All of above %88. $he filter by selection feature allows you to filterK a. $hose records that match an entity in a field b. 7ecords based on a criterion you specify c. 7ecords that meet any of several criteria you specify d. All of above %8=. What is the memo data type field used for a. $o add table b. $o store obects created in other programs c.
a. $o provide a hierarchial view of related tables or 5ueries in a single window b. $o display grouped data in a report c. $o display summari(ed data. d. All of the above %=2. Which of the following is not a selection techni5ue a. $o select a word' double click the word b. $o select an entire table click the empty bos! to the left of the field names c. $o select a row' click the record selector bo! to the left of the row d. $o select a column' double click anywhere in the column &. 0isit & )ets for a. ultiple hoice &uestions ollection b. /ownload & 3anks c. Attempt online 5ui( d. )tudy subective 5uestionsanswers %=#. 4ow can you display pivot table report summary data in a currency format a. Gse custom calculation b. $ype in the currency symbol c. odify the field settings d. "one of the above AnswersK lick the Bike' $weet or oogleH buttons below to show correct answersK Ql2gR &."o9orrect Answer %?1 L c %?2 L c
%?# L a %?% L a %?* L c %?, L a %?6 L b %?8 L d %?= L a %1? L a %11 L c %12 L b %1# L d %1% L a %1* L c %1, L a %16 L b %18 L b %1= L b %2? L d
%21 L c %22 L d %2# L a %2% L c %2* L d %2, L d %26 L b %28 L a %2= L d %#? L c %#1 L d %#2 L b %## L c %#% L c %#* L b %#, L b %#6 L c %#8 L d
%#= L d %%? L a %%1 L d %%2 L c %%# L c %%% L a %%* L a %%, L c %%6 L d %%8 L c %%= L b %*? L a %*1 L d %*2 L c %*# L d %*% L c %** L a %*, L d
%*6 L c %*8 L a %*= L b %,? L b %,1 L a %,2 L b %,# L b %,% L c %,* L b %,, L c %,6 L a %,8 L b %,= L b %6? L a %61 L c %62 L b %6# L c %6% L a
%6* L b %6, L b %66 L b %68 L a %6= L b %8? L d %81 L d %82 L c %8# L a %8% L c %8* L c %8, L c %86 L b %88 L a %8= L c %=? L b %=1 L a %=2 L d
