Quiz | Croma Campus

How can you prevent users from modifying data in a table?

By using a macro
By setting permissions
By using a form
By creating a query

Mark for review

How do you add a new record to a table in Access?

Use a macro
Enter data directly
Use a query
Create a report

Mark for review

What is a pivot table used for in Access?

To create forms
To analyze data
To generate queries
To manage records

Mark for review

What type of report shows data grouped by categories?

Detail Report
Summary Report
Group Report
List Report

Mark for review

Which Access object is used to store and manage data?

Form
Query
Table
Report

Mark for review

Which Access object would you use to generate a summary report?

Query
Form
Report
Table

Mark for review

How can you create a backup of an Access database?

By using a query
By copying the file
By creating a form
By setting permissions

Mark for review

How do you filter records to show only records that meet specific criteria?

Use 'Sort'
Use 'Find'
Use 'Filter'
Use 'Replace'

Mark for review

Which Access feature is used to validate data before entering it into a table?

Field Validation
Data Entry
Table Design
Form Design

Mark for review

What is the purpose of a form in Access?

To display data
To analyze data
To create tables
To generate queries

Mark for review

What type of query is used to update data in Access?

Select Query
Update Query
Append Query
Delete Query

Mark for review

How do you prevent duplicate records from being entered into a table?

By setting a primary key
By using a report
By using a macro
By creating a query

Mark for review

What feature helps to ensure that data entered into a field is correct?

Validation Rule
Lookup Field
Default Value
Input Mask

Mark for review

What is the use of the 'Group By' clause in an Access query?

To sort records
To calculate sums
To filter data
To group data

Mark for review

What is the use of the 'Foreign Key' in Access?

To encrypt data
To establish relationships
To generate reports
To format text

Mark for review

Which view allows you to design the layout of a form?

Datasheet View
Design View
Form View
Layout View

Mark for review

Which of the following is a valid Access data type?

Picture
Memo
Hyperlink
Currency

Mark for review

What is an Access Report used for?

To manage data
To print or view data
To enter new records
To create queries

Mark for review

How can you ensure data integrity between related tables?

By using primary keys
By using validation rules
By creating forms
By writing SQL code

Mark for review

What is the purpose of the 'Input Mask' property in Access?

To format data entry
To encrypt data
To validate data
To sort records

Mark for review

Which function is used to count the number of records in a query?

COUNT()
SUM()
AVG()
MAX()

Mark for review

What is the primary purpose of using a macro in Access?

To automate tasks
To create tables
To run queries
To design forms

Mark for review

Which object would you use to calculate totals in Access?

Table
Query
Report
Form

Mark for review

How do you create a one-to-many relationship in Access?

By linking tables
By creating a form
By using a query
By setting permissions

Mark for review

Which data type would you use for a phone number field?

Text
Number
Currency
Date/Time

Mark for review

What does the 'JOIN' keyword do in an SQL query?

Deletes records
Joins tables
Updates records
Creates tables

Mark for review

Which of the following is used to create a new table in Access?

Query Design
Table Design
Form Design
Report Design

Mark for review

What does the 'Sort Ascending' command do?

Sorts from Z to A
Sorts from A to Z
Sorts numerically
Removes duplicates

Mark for review

Which Access object is used to create user interfaces?

Table
Query
Form
Report

Mark for review

What is the default file extension for an Access database?

.xlsx
.accdb
.docx
.pptx

Mark for review

Online Exam Quiz

Online

Did you like this Question

Get a 1:1 Mentorship call with our Career Advisor