Intro to Access - take the quiz | Take the Quiz

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

To uniquely identify each record

To sort the records alphabetically

To calculate mathematical functions

To store large amounts of data

What is the maximum number of characters that can be stored in a Text field in Access?

255

1000

500

10,000

Which operator is used to combine multiple conditions in an Access query?

AND

NOT

XOR

What is the purpose of a foreign key in a database table?

To establish relationships between tables

To sort the records in a table

To calculate mathematical functions

To store large amounts of data

What is the purpose of an index in a database table?

To improve the performance of queries

To sort the records alphabetically

To calculate mathematical functions

To store large amounts of data

Which of the following is NOT a valid relationship type in Access?

One-to-One

One-to-Many

Many-to-Many

Self-Referential

What is the purpose of a query in Access?

To retrieve and manipulate data from one or more tables

To create forms and reports

To design the user interface

To store data in a database

What is the purpose of a form in Access?

To provide a user-friendly interface for entering and viewing data

To perform calculations on data

To store data in a database

To generate reports

Which of the following is NOT a valid form view in Access?

Datasheet View

Design View

Split Form View

Report View

What is the purpose of a report in Access?

To present data in a formatted and organized manner

To perform calculations on data

To store data in a database

To create relationships between tables

Which of the following is NOT a valid report view in Access?

Print Preview

Layout View

Design View

Form View

What is the purpose of a macro in Access?

To automate repetitive tasks or actions

To perform calculations on data

To store data in a database

To create relationships between tables

What is the purpose of a module in Access?

To write custom code or functions

To perform calculations on data

To store data in a database

To create relationships between tables

Which of the following is NOT a valid programming language in Access?

Visual Basic for Applications (VBA)

SQL

JavaScript

Python

What is the purpose of a query parameter in Access?

To prompt the user for input when running a query

To sort the records alphabetically

To calculate mathematical functions

To store large amounts of data

What is the purpose of a backup in Access?

To create a copy of the database for safekeeping

To sort the records alphabetically

To calculate mathematical functions

To store large amounts of data

Which of the following is NOT a valid method for creating a backup in Access?

Using the built-in backup feature

Manually copying the database file

Exporting the database to another format

Using a third-party backup tool

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

To uniquely identify each record

To sort the records alphabetically

To calculate mathematical functions

To store large amounts of data

What is the maximum number of characters that can be stored in a Text field in Access?

255

1000

500

10,000

Which operator is used to combine multiple conditions in an Access query?

AND

NOT

XOR

What is the purpose of a foreign key in a database table?

To establish relationships between tables

To sort the records in a table

To calculate mathematical functions

To store large amounts of data

What is the purpose of an index in a database table?

To improve the performance of queries

To sort the records alphabetically

To calculate mathematical functions

To store large amounts of data

Which of the following is NOT a valid relationship type in Access?

One-to-One

One-to-Many

Many-to-Many

Self-Referential

Unlock and Upgrade

Remove all limits from your Quizzes

Intro to Access - take the quiz

More Quizzes