26. Which file format is used to save a Microsoft Access database?
- A) .mdb or .accdb
- B) .xls or .xlsx
- C) .doc or .docx
- D) .ppt or .pptx
27. What does the "Lookup Wizard" do in Microsoft Access?
- A) Creates a drop-down menu to select predefined values
- B) Encrypts data
- C) Creates tables automatically
- D) Analyzes data relationships
28. Which Access feature is used to find duplicate records in a table?
- A) Find & Replace
- B) Query Wizard
- C) Duplicate Query
- D) Crosstab Query
29. Which of the following objects is used to automate database tasks?
- A) Forms
- B) Macros
- C) Queries
- D) Reports
30. In Access, what is a "Module"?
- A) A collection of macros
- B) A piece of VBA code
- C) A query type
- D) A table relationship
31. What does the "Form Wizard" help you create in Access?
- A) Queries
- B) Reports
- C) User-friendly data entry forms
- D) Tables
32. In Access, a "subform" is:
- A) A smaller form embedded in another form
- B) A type of query
- C) A relationship between two tables
- D) A type of report
33. What is a Crosstab Query used for in Microsoft Access?
- A) Displaying summarized data in a table format
- B) Creating a new table
- C) Editing form properties
- D) Encrypting sensitive information
34. Which of these features allows you to restrict access to a Microsoft Access database?
- A) Password protection
- B) Data validation
- C) Relationships
- D) Design View
35. In Access, what does the "AutoNumber" data type do?
- A) Automatically generates a unique sequential number
- B) Sorts numbers in a table
- C) Converts text into numbers
- D) Automatically deletes duplicate numbers
36. What is the purpose of the "Relationship" window in Access?
- A) To define connections between tables
- B) To generate reports
- C) To create queries
- D) To design forms
37. In Access, what does the "Input Mask" property do?
- A) Controls how data is entered in a field
- B) Sorts data automatically
- C) Validates user input against a query
- D) Protects data from being edited
38. Which tool is used to summarize and analyze data in Access?
- A) Reports
- B) PivotTables
- C) Forms
- D) Queries
39. Which of the following is NOT a valid Access database object?
- A) Form
- B) Macro
- C) Slide
- D) Query
40. In Access, what is the purpose of the "Expression Builder"?
- A) To write formulas or expressions
- B) To create tables
- C) To modify relationships
- D) To validate data input
41. Which Access object is primarily used to create a user-friendly interface for data entry?
- A) Table
- B) Form
- C) Query
- D) Report
42. How can you enforce uniqueness in a table field in Access?
- A) By setting the field as a Primary Key
- B) By using a Validation Rule
- C) By enabling Input Mask
- D) By using a Foreign Key
43. Which type of query is used to update records in a table?
- A) Update Query
- B) Select Query
- C) Append Query
- D) Make-Table Query
44. What is the purpose of the "Navigation Pane" in Access?
- A) To display and manage database objects
- B) To create new database objects
- C) To edit database relationships
- D) To write SQL queries
45. In Access, which data type should you use for storing monetary values?
- A) Currency
- B) Number
- C) Text
- D) AutoNumber
46. How can you ensure that a field in Access is always filled?
- A) Set the "Required" property to "Yes"
- B) Use a Default Value
- C) Apply an Input Mask
- D) Set the field as a Foreign Key
47. Which of these is a type of form view in Microsoft Access?
- A) Datasheet View
- B) Layout View
- C) Print View
- D) Web View
48. What does the "Filter by Selection" feature in Access do?
- A) Filters records based on the currently selected field
- B) Deletes duplicate records
- C) Modifies data in a field
- D) Highlights duplicate values
49. In Access, what is an "Attachment" data type used for?
- A) Storing files like images or documents
- B) Storing hyperlinks
- C) Storing large amounts of text
- D) Storing foreign key values
50. Which of these is NOT a property of a field in Microsoft Access?
- A) Validation Text
- B) Input Mask
- C) Default Value
- D) Chart Type
Answers:
- A) .mdb or .accdb
- A) Creates a drop-down menu to select predefined values
- C) Duplicate Query
- B) Macros
- B) A piece of VBA code
- C) User-friendly data entry forms
- A) A smaller form embedded in another form
- A) Displaying summarized data in a table format
- A) Password protection
- A) Automatically generates a unique sequential number
- A) To define connections between tables
- A) Controls how data is entered in a field
- B) PivotTables
- C) Slide
- A) To write formulas or expressions
- B) Form
- A) By setting the field as a Primary Key
- A) Update Query
- A) To display and manage database objects
- A) Currency
- A) Set the "Required" property to "Yes"
- B) Layout View
- A) Filters records based on the currently selected field
- A) Storing files like images or documents
- D) Chart Type
