MS Access MCQs | MCQs Questions and Answers

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Share on reddit
Share on whatsapp

SHARE THIS

The Microsoft Access is important as it potentially decreases the amount of time required to exchange information between Microsoft Office applications.
MS Access MCQs

MS Access MCQ

The Microsoft Access is important as it potentially decreases the amount of time required to exchange information between Microsoft Office applications. Here on MCQs.Club we have designed MS Access MCQ questions and answers that are easily understood. Moreover, Microsoft Access benefits includes database management functionality for novice end users and it is highly extensible with enterprise systems by professional developers.

  1. __________database can be open at one time in Access.
    1. Unlimited
    2. Three
    3. Only one
    4. None
  1. If a database is already open, Access _________ when you open a new database.
    1. Closes it
    2. Opens a new in addition to already opened
    3. Replaces the already opened
    4. None
  1. Access is a ___________ database.
    1. Limited user
    2. Multi-user
    3. Only one user
    4. None
  1. In Microsoft Access, a multi-user database, means that ______________ person can open an Access database at the same time.
    1. Only two
    2. More than one
    3. Only three
    4. None
  1. In Microsoft Access, two people trying to edit the same thing at the same time — Access _________________.
    1. Locks out the second person until the first person is done with the edit.
    2. Allows both to edit the same thing at same time.
    3. Crashes and closes the database
    4. None
  1. In Microsoft Access The Ribbon has _______ tabs that always appear, and additional tabs appear when particular objects are open.
    1. 10
    2. 8
    3. 6
    4. 5
  1. In Microsoft Access, The tabs that always appear includes all of the following except:
    1. Create
    2. External Data
    3. View
    4. Database Tools

  1. In Microsoft Access to Minimize the Ribbon:
    1. Double-click the active tab.
    2. Press Ctrl+F1.
    3. Click the Minimize the Ribbon button (the upward pointing caret above the right end of the Ribbon).
    4. All of the above.
  1. Which of the following is an option under Navigation pane menu?
    1. Custom
    2. Object type
    3. Tables and Related views
    4. All of the above
  1. Which of the following statement is correct?
    1. You can create your own custom groups using the Navigation Options dialog box.
    2. Custom groups cannot be created in the Navigation Pane
    3. You can sort objects within a group in the Navigation pane
    4. Both A&C
  1. Navigation Options dialog box is be opened by:
    1. Right-clicking the title bar of the Navigation pane and then choose Navigation Options.
    2. Right-clicking the empty space at the bottom of the Navigation pane and then choose Navigation Options.
    3. Both A&B
    4. None
  1. You can configure the Navigation pane to show:
    1. object names
    2. icons, or more information about each object
    3. Both A&B
    4. None
  1. The ‘Details’ option in the View By menu tab of Navigation options Displays:
    1. The name of the object
    2. The type of object
    3. The date it was created, and the date it was last modified.
    4. All of the above
  1. Objects can be sorted in the Navigation pane from the Sort By menu as:
    1. Ascending or descending
    2. By Name, Type
    3. Created Date, or Modified Date
    4. All of the above

  1. Identify the kinds of objects that make up an Access database:
    1. Tables, queries,
    2. Forms, reports,
    3. Macros, VBA modules
    4. All of the above
  1. What are the two options for viewing multiple objects in Access:
    1. Overlapping windows and Tabbed documents
    2. Overriding windows and Double documents
    3. Web layout and Read Mode
    4. None
  1. After you have opened an object, you can look at it in a different view. Identify the method:
    1. Right-click the object tab and choose the view you want
    2. Click one of the View shortcuts at the right end of the status bar. There’s a button for each possible view.
    3. Click the icon on the View button at the left end of the Home tab on the Ribbon.
    4. All of the above
  1. Which of the following statement is correct?
    1. You can create, delete and rename an object
    2. You can copy and print an object
    3. Both A & B
    4. None
  1. To rename an object:
    1. Click the name of the object and press F2
    2. Right click the name and choose Rename
    3. Both A & B
    4. None
  1. In Microsoft Access you can view tables in:
    1. Datasheet view
    2. Design view
    3. Both A & B
    4. None
  1. The Datasheet view is similar to:
    1. Microsoft Excel Spreadsheet
    2. Microsoft PowerPoint slide
    3. Microsoft word blank page
    4. None

  1. The Datasheet view displays the data in:
    1. Linear form
    2. Rows and Columns
    3. Center of sheet
    4. None
  1. In MS Access after creating a table you can:
    1. Enter data
    2. Create fields
    3. Rename fields
    4. All of above
  1. When entering or editing data or to see where you are on the datasheet, Microsoft Access:
    1. uses the Pencil icon
    2. italicizes the data in the active cell
    3. shows the column outlined in yellow
    4. All of above
  1. The shortcut key Shift+F2 is used to:
    1. see the contents of the cell in the Zoom box
    2. find text or other content
    3. Add a table
    4. None
  1. Microsoft Access has _______ methods for adding additional fields.
    1. Three
    2. Five
    3. Only One
    4. Unlimited
  1. Which of the following methods is used to create and define fields?
    1. By entering data
    2. By using buttons in the Add & Delete section of the Fields tab.
    3. By defining each field, yourself in Table Design view.
    4. Any of above or a Combination of above.

  1. Which of the following are not a Quick Start fields option found on the More Fields list in the Add & Delete group of the Fields tab?
    1. Address, Category, Name
    2. Payment type, Phone, Priority
    3. Serial, Currency, Rate
    4. Start and End dates, Status, Tags
  1. Fields are defined as Hyperlink fields as:
    1. start Web links with http:// to have Access recognize them as hyperlinks
    2. Define the field in Design view with the Hyperlink data type
    3. Either A or B
    4. None
  1. To display the Insert Hyperlink or Edit Hyperlink dialog box:
    1. Right-click the Hyperlink field and choose Hyperlink
    2. Click in the field or tab to the field and press CTRL+K
    3. Either A or B
    4. None
  1. Which of the following options always appear in the Insert Hyperlink dialog box, no matter what you end up linking to:
    1. Text to Display
    2. Target Frame
    3. Some way to define the object that you’re linking to (address or name of the object)
    4. ScreenTip
  1. In Microsoft Access the following is correct for field (column):
    1. Insert a generic field (column)
    2. Hide Columns
    3. Freeze Columns
    4. All of above
  1. What steps to be followed to create a table in Design view?
    1. Click the Table Design button in the Tables group on the Create tab of the Ribbon.
    2. Click the Table button in the Tables group on the Insert tab.
    3. Click create Table button on the Design tab.
    4. None

———more to come soon———

Read more
Read more
Read more
Read more

Leave a Reply

Sign up for Free MCQs

Success is awaiting for you

JOIN US

MCQsClub login

Welcome to the Club

Log in to continue. IT'S FREE

OR