Quiz | Croma Campus

How do you make a field required in Access?

By setting a default value
By setting a validation rule
By setting a field property
By using a macro

Mark for review

What is the maximum number of characters allowed in a Text field?

Mark for review

What is the purpose of a primary key in a table?

To identify duplicates
To link tables
To sort records
To filter data

Mark for review

How do you define relationships between tables in Access?

By creating a form
By using relationships
By writing SQL code
By creating queries

Mark for review

How can you automatically update records in Access?

By using a macro
By using a report
By using a form
By using an update query

Mark for review

What is the default sort order when sorting a column in Access?

Ascending
Descending
By date
By alphabetical order

Mark for review

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

Query
Form
Report
Table

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

What is the purpose of a data macro in Access?

To perform calculations
To automate tasks
To manage data
To create forms

Mark for review

What is the function of a subform in Access?

To calculate values
To display related records
To generate queries
To sort records

Mark for review

What is a query in Access?

A form layout
A method for data entry
A tool for searching data
A report format

Mark for review

How can you add a new field to an existing table?

By using SQL
By modifying the form
By altering the table structure
By creating a new table

Mark for review

Which Access object is used to store and manage data?

Form
Query
Table
Report

Mark for review

Which of the following is a valid Access data type?

Picture
Memo
Hyperlink
Currency

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

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

Text
Number
Currency
Date/Time

Mark for review

Which Access object is used to create user interfaces?

Table
Query
Form
Report

Mark for review

How do you create a new database object in Access?

By using the ribbon
By using SQL
By creating a macro
By using a form

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

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 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

What is the purpose of the 'Export' feature in Access?

To save a backup
To move data to another format
To create a new table
To update records

Mark for review

Which of the following is an example of a database object in Access?

Spreadsheet
Document
Table
Image

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

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 feature helps to ensure that data entered into a field is correct?

Validation Rule
Lookup Field
Default Value
Input Mask

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 Access object is best for managing related data?

Query
Table
Form
Report

Mark for review

Which object would you use to calculate totals in Access?

Table
Query
Report
Form

Mark for review

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

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

Mark for review

Online Exam Quiz

Online

Did you like this Question

Get a 1:1 Mentorship call with our Career Advisor