#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
Which data type in Microsoft Access allows storage of images, documents, or other files?
Attachment
ExplanationEnables the storage of various file types, such as images or documents, in a database.
#8
What is the purpose of the 'Compact and Repair Database' function in Microsoft Access?
To optimize database performance
ExplanationEnhances database performance by compacting and repairing database files.
#9
In Microsoft Access, what is the purpose of a data macro?
To automate actions based on data changes
ExplanationAutomates specified actions in response to changes in database data.
#10
Which object in Microsoft Access is used to define how data is retrieved and displayed in a structured manner?
Query
ExplanationDefines the structure for retrieving and displaying data in a database.
#11
What does SQL stand for in the context of Microsoft Access?
Structured Query Language
ExplanationA standardized language for interacting with and managing databases.
#12
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.
#13
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.
#14
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.
#15
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.
#16
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.
#17
Which option in Microsoft Access allows you to group and summarize data in a query?
Group By
ExplanationEnables grouping and summarization of data in query results based on specified criteria.
#18
What is the purpose of a calculated field in Microsoft Access?
To perform mathematical calculations on data
ExplanationPerforms mathematical calculations on data dynamically within a database.
#19
What is the purpose of a validation rule in Microsoft Access?
To restrict the type of data entered into a field
ExplanationLimits entered data to specified criteria, ensuring data accuracy.
#20
Which object in Microsoft Access is used to automate tasks by combining multiple actions into a single operation?
Macro
ExplanationCombines multiple actions into a single operation for task automation.
#21
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.
#22
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.
#23
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.
#24
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.
#25
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.