PPSC Computer Science Full Book test With Answers

PPSC Computer Science Full Book test

Sr. # Questions Answers Choice
1 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
2 The expression builder is an access tool that controls an expression ____ for entering an expression. Table Box cell palette
3 A __ name must be unique within a data base. Table Field Record Character
4 You can set a controls border type to make the border invisible Transparent Invisible <div>Dot not display</div> No border
5 The button on the tool box display data from a related table Sub form sub report Relationships Select objects More control
6 To duplicate a controls formatting you can use. Manager Wizard Painter Control
7 The ______ operator will cause record to be selected only if tow or more conditions are satisfied. Or If Or Range And
8 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
9 The two form layout types will display multiple records at one time are tabular and. Columnar Justified Data sheet Pivot table
10 Both condition display on the same row in the design grid when ____ operator is in use. OR IN LIKE AND
11 A search value can be an exact value or it can be. Logical operator Relationship Wild card character Comparison operation
12 If you write criteria values vertically it will mean OR Conditions AND Conditions NOT condition None
13 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
14 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.
15 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
16 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
17 Which of the following is not a type or relationship that can be applied in Access data base. One to one One to many Many to Many All of above
18 To tables can be linked with relationship so that the data integrity can be enforced where can you fine relationship command. File menu View menu Data base menu Tool menu
19 Which of the following statement is true. Reports can be used to return data from tables and calculate Queries can be printed in well formatted manner any presented as the information Queries can include calculated fields that do not exist in table. Reports and form are similar but forms are use to print the report to display on screen only.
20 What is a form in MS Access It is a printed page where users will write their data to fill it up It is an input screen designed to make the viewing and entering Data easier This is an important part of Data Base used by analysis to draw conclusions All of above
21 What does the show check box in query design windows indicate. If indicates whether the field is to be sued or not. It indicates whether the field is to be displayed in Query result or not. It indicates whether the field names to be displayed in query result or not. None
22 Name of the fields field type and size Tables with fields and relationships between tables Criteria Sorting check boxes
23 To create queries in Access You can drag and drop fields on query builders. You can type the Sl command in Sl view You can query wizard or design view All above
24 Queries in Access can be sued as. View, change and analyze data indifferent ways A source of records for forms and reports Only A Both A and B
25 To sort records in a table. Open table click on the field on which the sorting is to be done then click sort button on data base toolbar. Open table click sort button on data base tool bar, choose field based on which to sort click ok Click the field heading to sort it ascending or descending All of above
26 A small button with three dots usually displayed at the right of field properties box. Make button Expression button Build button None
27 How can you define a field so that when entering data for that field it will display instead of actual typed text. input Mask Validation rule Indexed IME mode
28 When entering fields Name How many characters you can type in maximum. 60 64 68 Any number of character
29 Which field tye can store phots. Hyper link Ole Both of these can be used Access tables can't store photos
30 Which field type will you select when creating a new table if you require to enter long text in that field. Text Memo currency Hyper link
Download This Set

Is this page helpful?