Microsoft Access Mastery: 50 MCQ Quiz

Microsoft Access Mastery Quiz

Test your professional database skills! This quiz covers 20 essential lessons from Access Basics to Advanced Queries and Reports.

Lessons 1-4: Access Basics & Objects

1. What makes Access a "Relational" database?
Correct Answer: B Explanation: A relational database stores data in separate tables that are linked (related) by common fields.
2. Which Access object is used to summarize and present data for printing?
Correct Answer: D Explanation: Reports are designed to format and present data in a printable and easy-to-read layout.
3. Where can you find all the open objects in an Access database?
Correct Answer: C Explanation: All currently open objects appear as tabs on the Document Tabs bar for easy switching.
4. Which part of the Access interface contains commands for managing the entire database file?
Correct Answer: B Explanation: Backstage view (accessed via the File tab) is used for opening, saving, printing, and closing databases.

Lessons 5-7: Working with Data

5. In a table, a horizontal row represents a ________.
Correct Answer: B Explanation: Each row in a table is a "Record," which contains all the information for one item (like one customer).
6. To quickly move to a specific record number, you should use the:
Correct Answer: C Explanation: Located at the bottom of the object, the Record Navigation bar allows you to move between or search for records.
7. Which feature allows you to hide records that don't meet specific criteria?
Correct Answer: B Explanation: Filtering hides data that doesn't match your criteria, while Sorting only changes the order of display.

Lessons 8-10: Running Queries

8. What is the main purpose of a Query?
Correct Answer: B Explanation: Queries are used to search for and compile data from one or more tables based on specific conditions.
9. When designing a multi-table query, what must exist between the tables?
Correct Answer: B Explanation: Multi-table queries require a relationship (link) between fields to join data correctly.
10. In Query Design view, which row allows you to specify that you only want customers from "London"?
Correct Answer: D Explanation: The Criteria row is where you enter the specific conditions to filter query results.

Lessons 11-12: Reports

11. Which tool provides a step-by-step guide to creating complex reports?
Correct Answer: B Explanation: The Report Wizard asks questions and creates the report based on your choices.
12. To see how a report will look on paper before printing, you should use:
Correct Answer: B Explanation: Print Preview shows exactly how pages will be divided and formatted for the printer.

Lessons 13-16: Database Design

13. Which data type should you use for a field that will store large paragraphs of text?
Correct Answer: B Explanation: Long Text (formerly Memo) can hold up to 65,535 characters, whereas Short Text is limited to 255.
14. What property prevents a user from entering a "Negative Number" in a Price field?
Correct Answer: C Explanation: Validation Rules (e.g., >=0) check data as it is entered to ensure it is valid.
15. What is the fastest way to build a functional database without designing every table from scratch?
Correct Answer: A Explanation: Templates provide pre-built tables, forms, and reports for common tasks like Inventory or Contact management.

Lessons 17-20: Advanced Tasks & Criteria

16. Which row would you add to a table or query to see the "Average" or "Total" of a column?
Correct Answer: B Explanation: The Totals row (Σ) allows you to perform mathematical functions on an entire column.
17. Which query type is used to find records with the same data in a field, such as two customers with the same email?
Correct Answer: A Explanation: A Find Duplicates Query is specifically designed to identify repeat data entries.
18. What kind of query asks the user for a search term every time it is run?
Correct Answer: B Explanation: Parameter queries use brackets in the criteria [Enter City] to prompt the user for input.
19. In Query Criteria, what does the asterisk (*) wildcard represent?
Correct Answer: B Explanation: Like "A*" will find Apple, August, and Art because * represents any characters following 'A'.
20. To search for names that do NOT start with 'B', you would use which criteria?
Correct Answer: B Explanation: "Not Like" is the standard Access operator to exclude specific patterns.

Detailed Practice (Lessons 1-20)

21. What happens if you double-click an object in the Navigation Pane?
Correct Answer: B Explanation: Double-clicking opens tables and queries in Datasheet view, and forms/reports in Form/Report view.
22. Which key is used to save the "Design" of an object?
Correct Answer: A Explanation: Ctrl + S saves changes to the structure (Design) of the object.
23. If you want to see data from "Orders" and "Customers" in one list, you use:
Correct Answer: B Explanation: Multi-table queries join related tables to provide a combined view of information.
24. What are "Command Buttons" in a form used for?
Correct Answer: B Explanation: Command buttons make the form user-friendly by letting users click to perform common tasks.
25. Which wildcard is used to match a "Single" character?
Correct Answer: B Explanation: In Access, the question mark (?) replaces exactly one character (e.g., "h?t" finds hot and hat).
26. "Short Text" character limit is:
Correct Answer: B Explanation: Short Text is designed for brief data like names or addresses, capped at 255 characters.
27. Which view allows you to see data while also making structural changes to a Report?
Correct Answer: B Explanation: Layout View is great for visual adjustments (like column width) while seeing live data.
28. What is a "Calculated Field"?
Correct Answer: B Explanation: Calculated fields store a formula instead of a static value.
29. In a Report, where would you find information that prints on the bottom of every page?
Correct Answer: B Explanation: The Page Footer is repeated on every single page of a report.
30. "Enforce Referential Integrity" ensures that:
Correct Answer: B Explanation: It prevents "orphan" records, like an order existing for a customer that was deleted.
31. Which view is used to enter new records into a Table?
Correct Answer: B Explanation: Datasheet view is the spreadsheet-style view for manual data entry into tables.
32. To change the overall color theme and font of a Form, you use:
Correct Answer: B Explanation: Themes provide a quick way to change colors and fonts across the whole form.
33. Which data type is best for storing prices or money?
Correct Answer: B Explanation: Currency data type prevents rounding errors and adds symbols automatically.
34. A "Primary Key" must be:
Correct Answer: B Explanation: Primary keys uniquely identify every record and cannot be empty.
35. "Sorting" a table means:
Correct Answer: B Explanation: Sorting organizes data alphabetically or numerically without removing any data.
36. What is the Navigation Pane used for?
Correct Answer: B Explanation: It is the central hub for seeing all Tables, Queries, Forms, and Reports in your file.
37. Which Criteria operator matches values between a range?
Correct Answer: B Explanation: "Between 10 And 20" finds all values from 10 to 20 inclusive.
38. To move a column in a Table's Datasheet view, you should:
Correct Answer: B Explanation: Clicking and dragging column headers allows you to reorganize the datasheet display.
39. What does the "Required" field property do?
Correct Answer: B Explanation: Setting Required to "Yes" ensures important data isn't skipped during entry.
40. To search for a specific word anywhere within a field, you use:
Correct Answer: B Explanation: Asterisks on both sides allow the word to appear at the start, middle, or end.
41. Where do you add a Logo to a Form so it appears in the top corner?
Correct Answer: B Explanation: The Form Header is the standard place for titles, logos, and navigation buttons.
42. How do you delete a record permanently?
Correct Answer: B Explanation: Access will usually ask for confirmation before permanently deleting a record.
43. What is "AutoNumber"?
Correct Answer: B Explanation: AutoNumber is the most common data type for Primary Keys.
44. To sort a query by "Price" from highest to lowest, you select:
Correct Answer: B Explanation: Descending order sorts from largest to smallest (Z to A or 100 to 1).
45. Which tab on the ribbon contains the "Compact and Repair" tool?
Correct Answer: C Explanation: Compact and Repair helps keep the database file healthy and small.
46. If you want to see all orders placed in "2023", which criteria is correct for a Date field?
Correct Answer: C Explanation: Dates in Access criteria must be enclosed in hashtags (#).
47. What does the "Σ Totals" button do in Query Design?
Correct Answer: B Explanation: This is essential for summary reports, like calculating total sales per city.
48. Which tool is used to export an Access table to Excel?
Correct Answer: B Explanation: The External Data tab manages both importing from and exporting to other software.
49. What is the shortcut key to close the current database object?
Correct Answer: C Explanation: Both Ctrl+W and Ctrl+F4 are standard Windows shortcuts to close the active tab or window.
50. Microsoft Access is primarily an RDBMS. What does RDBMS stand for?
Correct Answer: B Explanation: Relational Database Management System is the official category for software like Access.

You May Also Like

Loading...