Microsoft Access Questions and Answers

Practice Mode
Showing 10 of 94 questions
Q71
What is the propose to a sub datasheet?
  • A To provide a hierachial view of related tables or queries in a single window
  • B To display grouped data in a report
  • C To display summarized data.
  • D All of the above
Answer: Option A
Q72
Which of the following is not a selection technique ?
  • A To select a word, double click the word
  • B To select an entire table click the empty bosx to the left of the field names
  • C To select row, click the record selector box to the left of the row
  • D to select a column, double click anywhere in the column
Answer: Option D
Q73
How can you display Pivt Table report summary data in a currency format ?
  • A Use custom calculation
  • B Type in the currency symbol
  • C Modify the field settings
  • D None of the above
Answer: Option C
Q74
What method can you use to add a new table to your database ?
  • A Use Design View to create a table
  • B Enter data directly by using a datasheet
  • C Both of above
  • D All of the above
Answer: Option C
Q75
Which action do you use in a a macro to automatically send a report shanshot in an email message ?
  • A Use mail
  • B Send object
  • C Run macro
  • D All of the above
Answer: Option B
Q76
How can you display sales grouped by country, region and salesperson, all at the same time ?
  • A Use the Sort Descending Command.
  • B use the Pivot table view command
  • C Use the find command on specified groups
  • D All of above
Answer: Option B
Q77
The Checking operation performed on input dta is called the
  • A Validation of data
  • B Verification of data
  • C Cross check
  • D Control of data
Answer: Option A
Q78
A form defines
  • A Where data is placed on the screen
  • B The width of each field
  • C Both (A) and (B)
  • D All of the above
Answer: Option C
Q79
The following method you can use to add a new table to your database
  • A Use Design View to create a table
  • B Enter data directly by using a datasheet
  • C Both of above
  • D All of the above
Answer: Option C
Q80
The following you can use in a macro to automatically send a report snapshot in an email message
  • A Use mail
  • B Send object
  • C Run macro
  • D All of the above
Answer: Option B
Questions and Answers for Competitive Exams Various Entrance Test