Microsoft Access MCQ Question and Answer
Microsoft Access MCQ Question and Answer
71. What is the propose to a sub datasheet?
- To provide a hierachial view of related tables or queries in a single window
- To display grouped data in a report
- To display summarized data.
- All of the above
72. Which of the following is not a selection technique ?
- To select a word, double click the word
- To select an entire table click the empty bosx to the left of the field names
- To select row, click the record selector box to the left of the row
- to select a column, double click anywhere in the column
73. How can you display Pivt Table report summary data in a currency format ?
- Use custom calculation
- Type in the currency symbol
- Modify the field settings
- None of the above
74. What method can you use to add a new table to your database ?
- Use Design View to create a table
- Enter data directly by using a datasheet
- Both of above
- All of the above
75. Which action do you use in a a macro to automatically send a report shanshot in an email message ?
- Use mail
- Send object
- Run macro
- All of the above
76. How can you display sales grouped by country, region and salesperson, all at the same time ?
- Use the Sort Descending Command.
- use the Pivot table view command
- Use the find command on specified groups
- All of above
77. The Checking operation performed on input dta is called the
- Validation of data
- Verification of data
- Cross check
- Control of data
78. A form defines
- Where data is placed on the screen
- The width of each field
- Both (A) and (B)
- All of the above
79. The following method you can use to add a new table to your database
- Use Design View to create a table
- Enter data directly by using a datasheet
- Both of above
- All of the above
80. The following you can use in a macro to automatically send a report snapshot in an email message
- Use mail
- Send object
- Run macro
- All of the above