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 The form displays multiple records one per row in the form window Data sheet Tabular Columnar Justified
2 This form displays data in a table layout with field name labels across the top of the page and the core spending data in rows and columns under each heading. Comumnar Justified Data sheet Tabular
3 This form display the field name labels down the left side of the column with the data for each field just to the right of its corresponding label. Tabular Justified Columnar Data sheet
4 If you make an invalid entry in the input mask wizard dialog box the will display to advise you that the entry is not coorect. Text eooro Validation error Literal error Entry error
5 In access this operation copies a backup file from the storage medium back on to the computer. Recreate Restore Copy Structure
6 In access this displays the result of a calculation in query Lookup field Calculated field Source field child field
7 When creating an input mask this character does not require an entry but if an entry is made it must be a letter from A-Z ? ! \@
8 Which of the following database object can be used if you need to mail the invoice to customers. A form A query A report A table
9 To create this you enter an expression in the design grid that instructs access to perform a calculation using the current field values. formulated field Numeric field Formula field Calculated field
10 A collection of related records in data base is known as a. Table Data base File None
11 What it is called to present information in a particular order based on numeric or alphabetical value. Sorting Searching Arranging cropping
12 Data base access levels are specified so as to define who can access what ina data base it is identified through. User ID Passwords Status None
13 Some rules are set in databases to check and permit only correct values What is the feature called. Data verification Auditing Data filtering Data validation
14 The operation of checking input data against specified criteria is known as. Data verification Data validation Cross check Data control
15 The filter by selection allows you to filter those records That match the selected field That match the criteria specified That meet any of several criteria specified All of above
16 This type of data base contains multiple tables that are connected to produce combined output from all tables. Bound Relational Linked Joined
17 Which of the following database object is created first before any other created Table Form Report Query
18 It is sign or symbol that specifies operator and values that product a result. Operator Query Expression None of the above
19 It is used to calculate and restructure data for easier analysis of your data it calculates the sum. Parameter Select cross tab Append
20 It is a query that when run displays its own dialog box prompting you for information such as. Select Crosstab Parameter Append
Download This Set

Is this page helpful?