PPSC Computer Science Chapter 6 Microsoft Access Online Test With Answers

PPSC Computer Science Chapter 6 Microsoft Access Online Test

Sr. # Questions Answers Choice
1 It is most common type of query it retrieves records from one or more tables and then displays the. Parameter Select Crosstab All of above
2 Unlike text data type this can store up to maximum of 65,535, characters. Query Form Report None of the above
3 This data type allows alphanumeric characters and special symbols Text Memo Auto number None of the above
4 The key uniquely identifies each record in a table Primary key Key word Field name All above
5 The option allows you to build a new table by entering data directly into the datasheet. Data sheet view Design view Link table None of the above
6 The expression builder is an access tool that controls an expression ____ for entering an expression. Table Box cell palette
7 A __ name must be unique within a data base. Table Field Record Character
8 You can set a controls border type to make the border invisible Transparent Invisible <div>Dot not display</div> No border
9 The button on the tool box display data from a related table Sub form sub report Relationships Select objects More control
10 To duplicate a controls formatting you can use. Manager Wizard Painter Control
11 The ______ operator will cause record to be selected only if tow or more conditions are satisfied. Or If Or Range And
12 You can automatically include all of the field in a table in a query by_____ a strike that appear list box in query design view. Clicking Right clicking Double clicking None of above
13 The two form layout types will display multiple records at one time are tabular and. Columnar Justified Data sheet Pivot table
14 Both condition display on the same row in the design grid when ____ operator is in use. OR IN LIKE AND
15 A search value can be an exact value or it can be. Logical operator Relationship Wild card character Comparison operation
16 If you write criteria values vertically it will mean OR Conditions AND Conditions NOT condition None
17 In one -to-many relationship the table in one side is called _____ and on many side is called. Child , parent Parent, child Brother , sister Father , son
18 What do you mean by one to many relationship between student and class table. One student can have many classes One class may have many student Many classes may have many student Many students may have manu classes.
19 What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table. A relationship is created Edit relationship dialog box appears Error occurs Nothing happens
20 While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into. A doctor's sign Thin + Sign Outline rectangle None
Download This Set

Is this page helpful?