Microsoft Access MCQs (Multiple-Choice Questions)

1. What is Microsoft Access primarily used for?

1. Managing relational databases
2. Creating operating systems
3. Editing video files
4. Designing computer processors

Answer: A) Managing relational databases

Explanation:

Microsoft Access is a relational database application used to store, organize, retrieve, analyze, and present structured data.

2. Which of the following is a primary object used to store data in Microsoft Access?

1. Table
2. Report
3. Form
4. Macro

Answer: A) Table

Explanation:

Tables are the primary database objects that store data in rows and columns. Other Access objects such as queries, forms, and reports can work with data stored in tables.

3. In an Access table, what is a row generally called?

1. Record
2. Field
3. Query
4. Property

Answer: A) Record

Explanation:

A row in an Access table represents a record containing information about one instance of the subject represented by the table.

4. In an Access table, what is a column generally called?

1. Field
2. Record
3. Form
4. Report

Answer: A) Field

Explanation:

A field is a column in a table that stores one type of information, such as CustomerName, OrderDate, or PhoneNumber.

5. Which Access object is used to retrieve and manipulate data based on specified criteria?

1. Query
2. Form
3. Report
4. Module

Answer: A) Query

Explanation:

Queries can retrieve specific records, filter data, calculate values, summarize information, and perform operations such as updating or deleting records.

6. Which Access object provides a user-friendly interface for entering or editing data?

1. Form
2. Table
3. Query
4. Report

Answer: A) Form

Explanation:

Forms provide a user interface for viewing, entering, and editing records stored in tables or returned by queries.

7. Which Access object is primarily designed for formatted presentation and printing of data?

1. Report
2. Table
3. Query
4. Relationship

Answer: A) Report

Explanation:

Reports present data in a formatted layout suitable for viewing, summarizing, and printing.

8. What is a primary key in Microsoft Access?

1. A field or set of fields that uniquely identifies each record
2. A field that must contain duplicate values
3. A field used only for displaying reports
4. A field that stores only text

Answer: A) A field or set of fields that uniquely identifies each record

Explanation:

A primary key uniquely identifies records in a table. A table can have only one primary key, although that key can contain multiple fields.

9. How many primary keys can a single Access table have?

1. One
2. Two
3. Unlimited
4. One for every field

Answer: A) One

Explanation:

An Access table can have only one primary key. The primary key can consist of one field or multiple fields forming a composite key.

10. What is a composite primary key?

1. A primary key consisting of multiple fields
2. A primary key containing only text
3. A key used only for reports
4. A foreign key without a relationship

Answer: A) A primary key consisting of multiple fields

Explanation:

A composite key uses two or more fields together to uniquely identify each record. It is useful when no single field uniquely identifies the records.

11. Which data type automatically generates a unique value for each new record?

1. AutoNumber
2. Short Text
3. Currency
4. Date/Time

Answer: A) AutoNumber

Explanation:

The AutoNumber data type automatically generates a value when a new record is added. It is commonly used for primary key fields.

12. Which data type is appropriate for storing names and other short text values?

1. Short Text
2. Currency
3. AutoNumber
4. Date/Time

Answer: A) Short Text

Explanation:

Short Text is used for text values such as names, addresses, codes, and other relatively short character strings.

13. Which Access data type is appropriate for storing monetary values?

1. Currency
2. Short Text
3. Yes/No
4. AutoNumber

Answer: A) Currency

Explanation:

The Currency data type is designed for storing monetary values and provides appropriate precision for financial calculations.

14. Which Access data type is used to store true/false values?

1. Yes/No
2. Currency
3. AutoNumber
4. Hyperlink

Answer: A) Yes/No

Explanation:

The Yes/No data type stores Boolean-style values representing two states, such as Yes/No or True/False.

15. Which data type is used to store dates and times?

1. Date/Time
2. Currency
3. Short Text
4. Attachment

Answer: A) Date/Time

Explanation:

Date/Time is designed to store date and time information and supports date and time calculations.

16. What is a foreign key?

1. A field containing values that correspond to a primary key in another table
2. A field that must always be unique within its table
3. A field used only for formatting
4. A field that can contain only dates

Answer: A) A field containing values that correspond to a primary key in another table

Explanation:

A foreign key contains values that reference the primary key of another table and is commonly used to establish relationships between tables.

17. Which Access feature is used to define relationships between tables?

1. Relationships window
2. Report Wizard
3. Form Layout
4. Macro Builder

Answer: A) Relationships window

Explanation:

The Relationships window allows users to define and manage relationships between tables by connecting related fields.

18. Which relationship allows one record in one table to correspond to multiple records in another table?

1. One-to-many
2. One-to-one only
3. Zero-to-zero
4. Field-to-field

Answer: A) One-to-many

Explanation:

In a one-to-many relationship, one record on the parent side can be related to multiple records on the child side. For example, one customer can have many orders.

19. Which relationship is represented when one record in each table corresponds to one record in the other table?

1. One-to-one
2. One-to-many
3. Many-to-many
4. Many-to-zero

Answer: A) One-to-one

Explanation:

A one-to-one relationship associates a record in one table with at most one corresponding record in another table.

20. How is a many-to-many relationship commonly implemented in a relational database?

1. Using an intermediate junction table
2. Using one field in only one table
3. Using a report instead of tables
4. Using a form without relationships

Answer: A) Using an intermediate junction table

Explanation:

A many-to-many relationship is commonly implemented using a junction table that contains foreign keys referencing the related tables.

21. What is referential integrity used for in Microsoft Access?

1. Helping maintain valid relationships between related records
2. Formatting report headings
3. Changing field colors
4. Creating automatic charts

Answer: A) Helping maintain valid relationships between related records

Explanation:

Referential integrity helps ensure that foreign-key references remain valid and can prevent orphan records in related tables.

22. Which query returns records that satisfy specified criteria without modifying the underlying data?

1. Select query
2. Update query
3. Delete query
4. Append query

Answer: A) Select query

Explanation:

A Select query retrieves data that meets specified criteria. It can combine data from one or more tables or queries without directly modifying the source records.

23. Which query is used to change existing records?

1. Update query
2. Select query
3. Append query
4. Make Table query

Answer: A) Update query

Explanation:

An Update query modifies values in existing records according to the specified criteria.

24. Which query is used to remove records from a table?

1. Delete query
2. Update query
3. Append query
4. Select query

Answer: A) Delete query

Explanation:

A Delete query removes records that satisfy the specified criteria.

25. Which query adds records to an existing table?

1. Append query
2. Delete query
3. Update query
4. Crosstab query

Answer: A) Append query

Explanation:

An Append query adds records from a source table or query to an existing destination table.

26. Which query creates a new table from the results of a query?

1. Make Table query
2. Append query
3. Delete query
4. Update query

Answer: A) Make Table query

Explanation:

A Make Table query creates a new table using the records returned by the query.

27. What is a parameter query?

1. A query that requests input when it runs
2. A query that permanently changes table structure
3. A query that can only delete records
4. A query that creates forms automatically

Answer: A) A query that requests input when it runs

Explanation:

A parameter query prompts the user for information, such as a date, customer name, or other value, before executing the query.

28. Which query type summarizes data using categories in rows and columns?

1. Crosstab query
2. Delete query
3. Append query
4. Update query

Answer: A) Crosstab query

Explanation:

A Crosstab query summarizes data and displays aggregated values across row and column headings, making it useful for comparative summaries.

29. Which SQL clause is used to filter records in an Access query?

1. WHERE
2. ORDER BY
3. GROUP BY
4. FROM

Answer: A) WHERE

Explanation:

The WHERE clause specifies criteria that determine which records are included in a query result.

30. Which SQL clause is used to sort query results?

1. ORDER BY
2. WHERE
3. FROM
4. VALUES

Answer: A) ORDER BY

Explanation:

The ORDER BY clause sorts query results according to one or more specified fields, either ascending or descending.

31. Which join returns only records that have matching values in both joined tables?

1. Inner join
2. Left outer join
3. Right outer join
4. Cross join

Answer: A) Inner join

Explanation:

An inner join returns only rows where matching values exist in both joined data sources.

32. What does a left outer join return?

1. All records from the left table and matching records from the right table
2. Only records with matches in both tables
3. Only records from the right table
4. Only unmatched records from both tables

Answer: A) All records from the left table and matching records from the right table

Explanation:

A left outer join includes all rows from the left data source and matching rows from the right data source. Where no match exists, the right-side fields can contain Null values.

33. Which Access feature helps users create a query without manually writing SQL?

1. Query Design
2. VBA Editor only
3. Database Compact tool
4. Navigation Pane only

Answer: A) Query Design

Explanation:

Query Design provides a graphical interface for selecting tables, fields, joins, criteria, sorting, and other query properties.

34. Which view displays the records returned by a query in rows and columns?

1. Datasheet View
2. Design View
3. Layout View
4. Print Preview

Answer: A) Datasheet View

Explanation:

Datasheet View displays records in a tabular format and is commonly used to view the results of queries and the contents of tables.

35. Which view is commonly used to define fields and properties for an Access table?

1. Design View
2. Print Preview
3. Report View
4. Form View

Answer: A) Design View

Explanation:

Table Design View allows users to define field names, data types, primary keys, validation rules, and other field properties.

36. Which property specifies a value that Access automatically inserts when a new record is created?

1. Default Value
2. Validation Rule
3. Input Mask
4. Caption

Answer: A) Default Value

Explanation:

The Default Value property specifies a value that Access can automatically enter when a new record is created.

37. What is the purpose of a Validation Rule in Access?

1. To restrict values that can be entered into a field or record
2. To automatically create a primary key
3. To print a report
4. To establish a database connection

Answer: A) To restrict values that can be entered into a field or record

Explanation:

A Validation Rule defines a condition that data must satisfy before Access accepts it.

38. Which property specifies the message displayed when a validation rule is violated?

1. Validation Text
2. Input Mask
3. Caption
4. Format

Answer: A) Validation Text

Explanation:

The Validation Text property specifies the message Access displays when entered data does not satisfy the associated validation rule.

39. What is an input mask used for?

1. Controlling the format in which data is entered
2. Creating table relationships
3. Sorting records
4. Deleting duplicate tables

Answer: A) Controlling the format in which data is entered

Explanation:

An Input Mask can define a pattern for entering data, such as telephone numbers, dates, or other values that follow a specific format.

40. What is an index used for in Microsoft Access?

1. Helping speed up searches, sorting, and other operations involving indexed fields
2. Storing report layouts
3. Replacing all primary keys
4. Creating forms automatically

Answer: A) Helping speed up searches, sorting, and other operations involving indexed fields

Explanation:

Indexes can improve the performance of searches, sorting, and joins involving indexed fields, although excessive indexing can increase storage and update overhead.

41. Which Access feature provides a tree-like view of database objects?

1. Navigation Pane
2. Relationships window
3. Property Sheet
4. Query Grid

Answer: A) Navigation Pane

Explanation:

The Navigation Pane provides access to database objects such as tables, queries, forms, reports, and other objects.

42. What is a macro in Microsoft Access?

1. A collection of actions used to automate tasks
2. A type of database table
3. A primary key type
4. A relationship type

Answer: A) A collection of actions used to automate tasks

Explanation:

Access macros can automate tasks by executing predefined actions, such as opening forms, running queries, or displaying messages.

43. Which language is commonly used in Access for advanced programming and automation?

1. VBA
2. HTML
3. CSS
4. XML only

Answer: A) VBA

Explanation:

Visual Basic for Applications (VBA) is used to create procedures, automate tasks, and implement more advanced functionality in Microsoft Access.

44. What is a subform in Microsoft Access?

1. A form embedded inside another form
2. A query stored inside a table
3. A report converted into a table
4. A secondary database file

Answer: A) A form embedded inside another form

Explanation:

A subform is a form placed inside another form. It is commonly used to display related records, such as displaying multiple orders for a selected customer.

45. Which Access feature can display records from related tables in a parent-child arrangement?

1. Main form and subform
2. Only a crosstab query
3. Only a report footer
4. Only an index

Answer: A) Main form and subform

Explanation:

A main form and subform combination is useful for displaying related data, such as a customer in the main form and that customer's orders in the subform.

46. Which Access feature can create a drop-down list for selecting a value in a field?

1. Combo Box
2. Label
3. Image
4. Page Break

Answer: A) Combo Box

Explanation:

A Combo Box provides a drop-down interface that can allow users to select a value from a list or enter a value, depending on its configuration.

47. A Customers table has CustomerID as its primary key, while an Orders table contains CustomerID as a foreign key. Which relationship is most appropriate when one customer can have many orders?

1. One-to-many from Customers to Orders
2. One-to-one from Customers to Orders
3. Many-to-many without an intermediate table
4. One-to-one from Orders to Customers only

Answer: A) One-to-many from Customers to Orders

Explanation:

CustomerID uniquely identifies a customer in Customers, while the same customer ID can appear in multiple Orders records. Therefore, Customers is the one side and Orders is the many side.

48. Consider the following query:

SELECT CustomerName, City
FROM Customers
WHERE City = "Delhi";

What does this query return?

1. Customer names and cities for customers whose city is Delhi
2. All customers except those in Delhi
3. Only the City field for every customer
4. All records from every table in the database

Answer: A) Customer names and cities for customers whose city is Delhi

Explanation:

The SELECT clause requests CustomerName and City, while the WHERE clause restricts the result to records where City equals "Delhi".

49. A company has Customers and Orders tables. The Customers table contains CustomerID as its primary key, and Orders contains CustomerID as a foreign key. The company wants a query showing every customer, including customers who have placed no orders. Which join is appropriate?

1. Left outer join from Customers to Orders
2. Inner join from Customers to Orders
3. Cross join only
4. Right outer join from Customers to Orders

Answer: A) Left outer join from Customers to Orders

Explanation:

A left outer join keeps every record from the Customers table and includes matching Orders records when they exist. Customers without orders can therefore still appear in the results, with Null values for the unmatched Orders fields.

50. Consider the following Access database design:

Customers
---------
CustomerID   Primary Key
CustomerName

## Orders

OrderID      Primary Key
CustomerID   Foreign Key
OrderDate

A user wants to display the customer name together with each order date. What is the key operation needed to retrieve this information from both tables?

1. Join Customers and Orders using the related CustomerID fields
2. Sort both tables by CustomerName
3. Create a new primary key in the Orders table using OrderDate
4. Convert both tables into reports

Answer: A) Join Customers and Orders using the related CustomerID fields

Explanation:

CustomerName is stored in Customers while OrderDate is stored in Orders. Joining the tables through the related CustomerID fields allows a query to combine the customer information with the corresponding order information.