#1
In Microsoft Access, what is the purpose of a primary key?
To uniquely identify each record in a table
To format data for display
To calculate mathematical functions
To create relationships between tables
#2
Which object in Microsoft Access allows users to input, edit, and view data in a database?
#3
What is the purpose of a query in Microsoft Access?
To create relationships between tables
To input data into a database
To retrieve and manipulate data
To format data for display
#4
Which feature in Microsoft Access allows you to enforce data integrity by restricting the type of data entered into a field?
Input Masks
Validation Rules
Default Values
Indexes
#5
In Microsoft Access, what is the purpose of a parameter query?
To create relationships between tables
To retrieve data based on user input
To format data for display
To perform calculations on data
#6
Which function in Microsoft Access is used to count the number of records in a query result?
#7
What does SQL stand for in the context of Microsoft Access?
Structured Query Language
System Query Level
Sequential Query Logic
Structured Query Logic
#8
Which of the following data types is not available in Microsoft Access?
#9
What is the purpose of the 'Lookup Wizard' in Microsoft Access?
To create a table lookup field
To search for data within a database
To validate data entry
To perform mathematical calculations
#10
Which property in Microsoft Access allows you to define how data is displayed in a form or report?
Control Source
Record Source
Format
Control Layout
#11
What is the purpose of a macro in Microsoft Access?
To create user-defined functions
To define complex queries
To automate repetitive tasks
To format reports
#12
Which object in Microsoft Access is used to present data in a structured format for printing or viewing?
#13
What is the purpose of a subform in Microsoft Access?
To create a smaller version of a form
To create a form within another form
To add subscripts to data fields
To format data for printing
#14
What is the purpose of the 'Cascade Update Related Fields' option in a relationship in Microsoft Access?
To automatically delete related records
To automatically update related fields if the primary key changes
To sort related records in ascending order
To perform calculations on related fields
#15
What is the purpose of the 'After Update' event in a Microsoft Access form?
To trigger an action after a record is updated
To validate data entry
To perform calculations on data
To format data for display
#16
What is the purpose of a parameterized query in Microsoft Access?
To restrict access to certain data
To prompt users for input when the query is run
To automatically update records
To calculate aggregate functions on data
#17
What is the purpose of the 'Not In List' event in a Microsoft Access combo box?
To trigger an action when an item is selected from the list
To validate data entry
To format data for display
To handle user input not found in the list