Quiz Maker LogoMake your own QuizCopy & Edit
Make your own quizManage my QuizzesPlans / FeaturesGuides and HelpContactPrivacy & Security

Intro to Access - 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
Which of the following is NOT a data type in Microsoft Access?
Text
Number
Date/Time
Boolean
Image
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
OR
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
Which of the following is NOT a valid data type for a field in Access?
Currency
Memo
Attachment
Image
Hyperlink
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
Which of the following is NOT a valid query type in Access?
Select
Update
Delete
Insert
Append
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
Which of the following is NOT a valid macro action in Access?
OpenForm
RunQuery
CalculateField
SetValue
CloseDatabase
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
Which of the following is NOT a valid query parameter type in Access?
Text
Number
Date/Time
Boolean
Image
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
Which of the following is NOT a valid data type in Microsoft Access?
Text
Number
Date/Time
Boolean
Image
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
OR
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
Which of the following is NOT a valid data type for a field in Access?
Currency
Memo
Attachment
Image
Hyperlink
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
{"name":"Intro to Access - take the quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is the purpose of a primary key in a database table?, Which of the following is NOT a data type in Microsoft Access?, What is the maximum number of characters that can be stored in a Text field in Access?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

More Quizzes

Can you guess the fairy tale? 8.A
14716
Fact or Fiction?
630
Josephine's Quiz 1
6325
Audiocodes - SBC 7.0 - Essentials & Configuration - Oct07 2016 - Exam
24120
Yôkai de Japón
1580
Ninjago knowledge test
1059
How well do you know me?
1367
Grammar revision
241226
QUIZ DEL GIORNO #4 POKEMON EDITION
630
"Nos han dado la tierra"
14725
Hogwarts would you rather
630
How much do you know Harrison Manolovitz
20100
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker