MS ACCESS
1. What is the primary purpose of Microsoft Access?
A) To create complex financial reports
B) To store and manage data in databases
C) To design graphics for websites
D) To create presentations
Answer: B) To store and manage data in databases
2. In Microsoft Access, which of the following is used to store data?
A) Query
B) Report
C) Table
D) Form
Answer: C) Table
3. Which of the following is NOT a type of relationship in MS Access?
A) One-to-one
B) One-to-many
C) Many-to-one
D) Many-to-many
Answer: C) Many-to-one
4. Which of the following is the correct way to sort data in a table in MS
Access?
A) Click on the 'Design View' and set the sort order
B) Click on the 'Sort' button in the toolbar
C) Right-click the column header and select 'Sort Ascending/Descending'
D) Use a query to sort the data
Answer: C) Right-click the column header and select 'Sort Ascending/Descending'
MS ACCESS
5. In MS Access, which of the following data types is used for storing large
text data?
A) Memo
B) Text
C) Date/Time
D) Currency
Answer: A) Memo
6. Which of the following objects in MS Access is used for data entry and
display in a user-friendly manner?
A) Query
B) Table
C) Form
D) Report
Answer: C) Form
7. Which SQL command is used to retrieve data from a table in MS Access?
A) DELETE
B) SELECT
C) UPDATE
D) INSERT
Answer: B) SELECT
8. In Access, what is the use of a "Primary Key"?
A) To ensure data consistency
B) To allow duplicate entries in a table
C) To uniquely identify each record in a table
D) To link two tables together
Answer: C) To uniquely identify each record in a table
MS ACCESS
9. Which of the following is the correct method to create a new query in MS
Access?
A) Right-click on a table and select "New Query"
B) Use the 'Query Design' option under the 'Create' tab
C) Click on the "Table" icon and select "Create Query"
D) Use "Forms" to design the query
Answer: B) Use the 'Query Design' option under the 'Create' tab
10. What does the 'Normalization' process do in MS Access?
A) Increases the size of the database
B) Reduces redundancy and ensures efficient data storage
C) Makes data entry easier
D) Generates reports automatically
Answer: B) Reduces redundancy and ensures efficient data storage
11. Which of the following operators is used in MS Access to find records
where a field's value starts with a particular string?
A) LIKE
B) IN
C) BETWEEN
D) NOT
Answer: A) LIKE
12. What is the default view for a table in MS Access?
A) Data Sheet View
B) Design View
C) Form View
D) Report View
Answer: A) Data Sheet View
MS ACCESS
13. Which of the following is a valid method to filter data in MS Access?
A) Using a query
B) Applying a filter in the table view
C) Sorting records in ascending/descending order
D) All of the above
Answer: D) All of the above
14. In MS Access, what is a "Foreign Key"?
A) A primary key in another table that establishes a relationship between two tables
B) A key used to store sensitive data
C) A key that identifies duplicate records
D) A password for accessing tables
Answer: A) A primary key in another table that establishes a relationship between two
tables
15. In Microsoft Access, what is a "Report" used for?
A) To update records
B) To display data in a printable format
C) To design a new table
D) To enter data into forms
Answer: B) To display data in a printable format