1) Which kind of query that displays its own dialog box prompting you for entering information before executing ? a. Select Query b. Crosstab Query c. Parameter Query d. Dialog Query
|
||||
2) What is a form that we can create in MS Access ? a. It is used to take printout of a form from Access Tables. b. It is an input screen for viewing and entering data. c. It is used for storing special data other than text (e.g photo) d. It is optional. We can use Report instead of Form
|
||||
3) What Cascade Delete option is used for ? a. It is used to delete all the records of all tables in a database b. It repeats the recent delete operation to all the records of current table c. It ensures that all the related records will be deleted automatically when the record from parent table is deleted. d. It is used to delete all the records of related tables in a database
|
||||
4) Which operator is used to filter and display rows when all (two or more) conditions are satiesfied ? a. RANGE b. IN c. ALL d. AND
|
||||
5) The_____________ button on the tool box display data from a related table a. Sub form sub report b. Relationships c. Select objects d. More controls
|
||||
6) Thecommandcenter of Access File thatappearswhen wecreateor open the MSAccess databaseFile. a. Database Window b. Query Window c. Design View Window d. Switchboard
|
||||
7) While creating relationship using mouse, how the the mousepointer looks like? a. A thick plus sign b. A thin plus sign c. An outlined rectangle d. Arrow with Plus sign
|
||||
8) The columns in a microsoft access table are also called _______ a. Rows b. Records c. Fields d. Columns
|
||||
9) how can you define a field so that when entering data ##### is displayed? a. Input Mask b. Validation Rule c. Indexed d. Ime Mode
|
||||
10) In the context of Microsoft Access, which of the following statement is true? a. Reports are used to retrieve andcalculate data from tables b. Queries can be printed and presented as the information c. Queries can include calculated fields that do not exist in table d. Reports and forms are similar but forms are use to print but reports to display on screen only
|