144
91.4k

540+ Microsoft Access (MS Access) Solved MCQs

These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: MCQ on Computer Softwares , Common Topics in Competitive and Entrance exams , Microsoft Office .

Take a Test
1.

In Access to open new database press

A. CTRL+N
B. CTRL+O
C. ALT+F4
D. None of these
Answer» A. CTRL+N
discuss
2.

In Access to open an existing database press

A. CTRL+N
B. CTRL+O
C. ALT+F4
D. None of these
Answer» B. CTRL+O
discuss
3.

In Access, to Exit Office Access 2007Access

A. CTRL+N
B. CTRL+O
C. ALT+F4
D. None of these
Answer» C. ALT+F4
discuss
4.

In Access press CTRL+N to

A. Open a new database
B. Open an existing database
C. Exit Office Access 2007Access
D. None of these
Answer» A. Open a new database
discuss
5.

In Access press CTRL+O to

A. Open a new database
B. Open an existing database
C. Exit Office Access 2007Access
D. None of these
Answer» B. Open an existing database
discuss
6.

In Access press ALT+F4 to

A. Open a new database
B. Open an existing database
C. Exit Office Access 2007Access
D. None of these
Answer» C. Exit Office Access 2007Access
discuss
7.

Press the following keys in Access to Print the current or selected object

A. CTRL+P
B. P or CTRL+P
C. S
D. C or ESC
Answer» A. CTRL+P
discuss
8.

Press the following keys in Access to Open the Print dialog box from Print Preview

A. CTRL+P
B. P or CTRL+P
C. S
D. C or ESC
Answer» B. P or CTRL+P
discuss
9.

Press the following keys in Access to Open the Page Setup dialog box from Print Preview

A. CTRL+P
B. P or CTRL+P
C. S
D. C or ESC
Answer» C. S
discuss
10.

Press the following keys in Access to Cancel Print Preview or Layout Preview

A. CTRL+P
B. P or CTRL+P
C. S
D. C or ESC
Answer» D. C or ESC
discuss
11.

Press the following keys in Access to Save a database object

A. CTRL+P
B. P or CTRL+P
C. CTRL+S or SHIFT+F12
D. F12
Answer» C. CTRL+S or SHIFT+F12
discuss
12.

Press the following keys in Access to Open the Save As dialog box

A. CTRL+P
B. P or CTRL+P
C. CTRL+S or SHIFT+F12
D. F12
Answer» D. F12
discuss
13.

In Access to Open a combo box

A. F4 or ALT+DOWN ARROW
B. DOWN ARROW
C. PAGE DOWN
D. F9
Answer» A. F4 or ALT+DOWN ARROW
discuss
14.

In Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box

A. F4 or ALT+DOWN ARROW
B. DOWN ARROW
C. PAGE DOWN
D. F9
Answer» D. F9
discuss
15.

In Access to Move down one page

A. F4 or ALT+DOWN ARROW
B. DOWN ARROW
C. PAGE DOWN
D. F9
Answer» C. PAGE DOWN
discuss
16.

When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters.

A. Report
B. Table
C. Query
D. Tools
Answer» C. Query
discuss
17.

In Access to Move down one line

A. F4 or ALT+DOWN ARROW
B. DOWN ARROW
C. PAGE DOWN
D. F9
Answer» B. DOWN ARROW
discuss
18.

In Access press…………………….to Move the selected control to the left (except controls that are part of a layout)

A. CTRL+C
B. CTRL+X
C. CTRL+V
D. None of these
Answer» D. None of these
discuss
19.

In Access press …………………….to Move the selected control to the right (except controls that are part of a layout)

A. CTRL+C
B. CTRL+X
C. CTRL+V
D. None of these
Answer» D. None of these
discuss
20.

In Access press …………………….to Paste the contents of the Clipboard in the upper- left corner of the selected section

A. CTRL+C
B. CTRL+X
C. CTRL+V
D. None of these
Answer» C. CTRL+V
discuss
21.

In Access press …………………….to Cut the selected control and copy it to the Clipboard

A. CTRL+C
B. CTRL+X
C. CTRL+V
D. None of these
Answer» B. CTRL+X
discuss
22.

In Access press …………………….to Copy the selected control to the Clipboard

A. CTRL+C
B. CTRL+X
C. CTRL+V
D. None of these
Answer» A. CTRL+C
discuss
23.

In Access press RIGHT ARROW or CTRL+RIGHT ARROW

A. Move the selected control to the right (except controls that are part of a layout)
B. Move the selected control to the left (except controls that are part of a layout)
C. Move the selected control up
D. None of these
Answer» A. Move the selected control to the right (except controls that are part of a layout)
discuss
24.

In Access press LEFT ARROW or CTRL+LEFT ARROW

A. Move the selected control to the right (except controls that are part of a layout)
B. Move the selected control to the left (except controls that are part of a layout)
C. Move the selected control up
D. None of these
Answer» B. Move the selected control to the left (except controls that are part of a layout)
discuss
25.

In Access press ALT+F11 to

A. Display the Control menu
B. Display the shortcut menu
C. Close the active window
D. None of these
Answer» D. None of these
discuss
26.

In Access press ALT+F11 to

A. Display the Control menu
B. Display the shortcut menu
C. Close the active window
D. Switch between the Visual Basic Editor and the previous active window
Answer» D. Switch between the Visual Basic Editor and the previous active window
discuss
27.

In Access press to Toggle the focus forward between controls in the wizard

A. TAB
B. ALT+N
C. ALT+B
D. ALT+F
Answer» A. TAB
discuss
28.

In access press to Move to the next page of the wizard

A. TAB
B. ALT+N
C. ALT+B
D. ALT+F
Answer» B. ALT+N
discuss
29.

In Access press UP ARROW to

A. Move up one line
B. Move up one page
C. Exit the combo box or list box
D. None of these
Answer» A. Move up one line
discuss
30.

In Access press PAGE UP

A. Move up one line
B. Move up one page
C. Exit the combo box or list box
D. None of these
Answer» B. Move up one page
discuss
31.

In Access press TAB

A. Move up one line
B. Move up one page
C. Exit the combo box or list box
D. None of these
Answer» C. Exit the combo box or list box
discuss
32.

In Access to find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only)

A. CTRL+F
B. CTRL+H
C. SHIFT+F4
D. None of these
Answer» C. SHIFT+F4
discuss
33.

In Access to open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)

A. CTRL+F
B. CTRL+H
C. SHIFT+F4
D. None of these
Answer» A. CTRL+F
discuss
34.

In Access to open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only)

A. CTRL+F
B. CTRL+H
C. SHIFT+F4
D. None of these
Answer» A. CTRL+F
discuss
35.

In Access to switch between Edit mode (with insertion point displaye(D)

A. F2
B. F4
C. F5
D. F6
Answer» A. F2
discuss
36.

In Access to switch to the property sheet (Design view in forms and reports in both Access databases and Access projects)

A. F2
B. F4
C. F5
D. F6
Answer» B. F4
discuss
37.

In Access to switch between the upper and lower portions of a window (Design view of queries, and the Advanced Filter/Sort window)

A. F2
B. F4
C. F5
D. F6
Answer» D. F6
discuss
38.

In Access to switch to Form view from form Design view

A. F2
B. F4
C. F5
D. F6
Answer» C. F5
discuss
39.

In Access press to Cycle through the field grid, field properties, Navigation Pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables)

A. F6
B. F7
C. F8
D. None of these
Answer» A. F6
discuss
40.

In Access press to Open the Choose Builder dialog box (Design view window of forms and reports)

A. F6
B. F7
C. F8
D. None of these
Answer» B. F7
discuss
41.

In Access press to Open the Visual Basic Editor from a selected property in the property sheet for a form or report

A. F6
B. F7
C. F8
D. None of these
Answer» B. F7
discuss
42.

In Access press to Switch from the Visual Basic Editor back to form or report Design view

A. F6
B. F7
C. F8
D. None of these
Answer» D. None of these
discuss
43.

Switch from the Visual Basic Editor back to form or report Design view in Access press

A. ALT+F11
B. SHIFT+F7
C. A and B both are true
D. None is true
Answer» C. A and B both are true
discuss
44.

In Access press to Move to the previous page of the wizard

A. TAB
B. ALT+N
C. ALT+B
D. ALT+F
Answer» C. ALT+B
discuss
45.

In Access press to Complete the wizard

A. TAB
B. ALT+N
C. ALT+B
D. ALT+F
Answer» D. ALT+F
discuss
46.

In Access press UP ARROW or CTRL+UP ARROW

A. Move the selected control to the right (except controls that are part of a layout)
B. Move the selected control to the left (except controls that are part of a layout)
C. Move the selected control up
D. None of these
Answer» C. Move the selected control up
discuss
47.

In Access press DOWN ARROW or CTRL+ DOWN ARROW

A. Move the selected control to the right (except controls that are part of a layout)
B. Move the selected control to the left (except controls that are part of a layout)
C. Move the selected control up
D. None of these
Answer» D. None of these
discuss
48.

In Access to Increase the height of the selected control

A. SHIFT+RIGHT ARROW
B. SHIFT+DOWN ARROW
C. DOWN ARROW or CTRL+DOWN ARROW
D. None of these
Answer» B. SHIFT+DOWN ARROW
discuss
49.

In Access press F11 to

A. Toggle the Navigation Pane
B. Cycle between open windows
C. Restore the selected minimized window when all windows are minimized
D. Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window
Answer» A. Toggle the Navigation Pane
discuss
50.

In Access press CTRL+F6 to

A. Toggle the Navigation Pane
B. Cycle between open windows
C. Restore the selected minimized window when all windows are minimized
D. Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window
Answer» B. Cycle between open windows
discuss

Done Studing? Take A Test.

Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.

Take a Test