#1
In Microsoft Access, what is the purpose of a primary key?
To uniquely identify each record in a table
ExplanationEnsures each record has a unique identifier for proper data organization.
#2
Which object in Microsoft Access allows users to input, edit, and view data in a database?
Form
ExplanationFacilitates user interaction by providing a platform to input, edit, and view data.
#3
What is the purpose of a query in Microsoft Access?
To retrieve and manipulate data
ExplanationAllows retrieval and manipulation of data based on specified criteria.
#4
Which feature in Microsoft Access allows you to enforce data integrity by restricting the type of data entered into a field?
Validation Rules
ExplanationMaintains data integrity by imposing restrictions on entered data.
#5
In Microsoft Access, what is the purpose of a parameter query?
To retrieve data based on user input
ExplanationRetrieves data based on user-specified parameters for customized results.
#6
Which function in Microsoft Access is used to count the number of records in a query result?
Count()
ExplanationCalculates and returns the count of records in a query result set.
#7
What does SQL stand for in the context of Microsoft Access?
Structured Query Language
ExplanationA standardized language for interacting with and managing databases.
#8
Which of the following data types is not available in Microsoft Access?
String
ExplanationContrary to common data types, 'String' is not available in Microsoft Access.
#9
What is the purpose of the 'Lookup Wizard' in Microsoft Access?
To create a table lookup field
ExplanationFacilitates the creation of table lookup fields for efficient data referencing.
#10
Which property in Microsoft Access allows you to define how data is displayed in a form or report?
Format
ExplanationDetermines the visual representation of data in forms or reports.
#11
What is the purpose of a macro in Microsoft Access?
To automate repetitive tasks
ExplanationAutomates repetitive tasks by recording and executing a series of actions.
#12
Which object in Microsoft Access is used to present data in a structured format for printing or viewing?
Report
ExplanationPresents data in a structured format for effective printing or viewing.
#13
What is the purpose of a subform in Microsoft Access?
To create a form within another form
ExplanationEnables the creation of a form within an existing form for enhanced data presentation.
#14
What is the purpose of the 'Cascade Update Related Fields' option in a relationship in Microsoft Access?
To automatically update related fields if the primary key changes
ExplanationAutomatically updates related fields when the primary key changes for consistency.
#15
What is the purpose of the 'After Update' event in a Microsoft Access form?
To trigger an action after a record is updated
ExplanationInitiates specified actions after a record in a form is updated.
#16
What is the purpose of a parameterized query in Microsoft Access?
To prompt users for input when the query is run
ExplanationPrompts users for input at runtime to customize query results.
#17
What is the purpose of the 'Not In List' event in a Microsoft Access combo box?
To handle user input not found in the list
ExplanationManages user input not found in the predefined list of a combo box.