Q101
Open questionAn Access database object that is used to enter, view or edit records
Select an option to see the answer and solution.
Computer Fundamentals · all questionsMS Access
MS Access
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
514
Questions
6/26
Page
Pick an option on a question to see the right answer and solution.
Q102
Open questionA- Press DOWN ARROW or CTRL+DOWN ARROW , B- Press SHIFT+LEFT ARROW: 1- Move the selected control down, 2- Reduce the width of the selected control.
Select an option to see the answer and solution.
Q103
Open questionQuery design window has two parts. The upper part shows
Select an option to see the answer and solution.
Q104
Open questionWhich of the following statements about tab order setting is NOT true?
Select an option to see the answer and solution.
Q105
Open questionWhen 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
Select an option to see the answer and solution.
Q106
Open questionwhat is a fast way to adjust the width of a column?
Select an option to see the answer and solution.
Q107
Open questionWhat type of relationship is created when you select a primary key in both related tables?
Select an option to see the answer and solution.
Q108
Open questionHow can you display Pivot Table report summary data in a currency format?
Select an option to see the answer and solution.
Q109
Open questionIn Access to switch to the property sheet (Design view in forms and reports in both Access databases and Access projects)
Select an option to see the answer and solution.
Q110
Open questionWhich data type is better to use for storing phone number in the following format "977-1-1234567"?
Select an option to see the answer and solution.
Q111
Open questionWhat is the keyboard shortcut to move to the last records in a table?
Select an option to see the answer and solution.
Q112
Open questionPress the following keys in Access to Print the current or selected object
Select an option to see the answer and solution.
Q113
Open questionWhich is not an option for Filter on a text field?
Select an option to see the answer and solution.
Q114
Open questionYou can keep the sum([Sales]) to calculate the totals for each month in
Select an option to see the answer and solution.
Q115
Open questionWhich of the following types of joins displays records with the same value in the common field?
Select an option to see the answer and solution.
Q116
Open questionWhich of the following type s of queries are action queries?
Select an option to see the answer and solution.
Q117
Open questionWhich of the following creates a drop down list of values to choose from a list?
Select an option to see the answer and solution.
Q118
Open questionA(n) ________ in the Record Selector indicates a new record.
Select an option to see the answer and solution.
Q119
Open questionThe 'filter by selection' allows you to filter those records
Select an option to see the answer and solution.
Q120
Open questionIt is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
Select an option to see the answer and solution.