MS Office MCQs

MS Access MCQs | MCQs Questions and Answers

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

More MCQs
HOME
Categories
Computer Science
Microsoft Office MCQs

» MS Word MCQs
» MS Excel MCQs
» MS PowerPoint 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.

__________database can be open at one time in Access.

1. Unlimited
2. Three
3. Only one
4. None

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

Access is a ___________ database.

1. Limited user
2. Multi-user
3. Only one user
4. None

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

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

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

In Microsoft Access, The tabs that always appear includes all of the following except:

1. Create
2. External Data
3. View
4. Database Tools

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.

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

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

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

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

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

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

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

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

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

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

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

In Microsoft Access you can view tables in:

1. Datasheet view
2. Design view
3. Both A & B
4. None

The Datasheet view is similar to:

1. Microsoft Excel Spreadsheet
2. Microsoft PowerPoint slide
3. Microsoft word blank page
4. None

The Datasheet view displays the data in:

1. Linear form
2. Rows and Columns
3. Center of sheet
4. None

In MS Access after creating a table you can:

1. Enter data
2. Create fields
3. Rename fields
4. All of above

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

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

Microsoft Access has _______ methods for adding additional fields.

1. Three
2. Five
3. Only One
4. Unlimited

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.

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

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

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

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

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

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———

MS Access MCQs | MCQs Questions and Answers

SHARE THIS

MS Access MCQ

Leave a Reply Cancel reply

Join us

Recent Post

Financial Ratios and Ratio Analysis MCQs

MCQs on Risk Management

MCQs on Strategic Control – Performance measurement

Follow us

Sign up for Free MCQs

MS Access MCQs | MCQs Questions and Answers

SHARE THIS

MS Access MCQ

Leave a Reply Cancel reply

Join us

Recent Post

Financial Ratios and Ratio Analysis MCQs

MCQs on Risk Management

MCQs on Strategic Control – Performance measurement

Follow us

Sign up for Free MCQs

Welcome to the Club

Log in to continue. IT'S FREE