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

Adaptability test
8437
How well do you know Lucy Rabuszko?
30150
Tier 3 Training Exam
422120
Check your knowledge about Computer and Technology.
520
The House of The Scorpion
10510
Hallowe'en Quiz
14711
NST Refresher
10522
UUmpire exam Test
210
Football
320
Which Beldon Sister are you?!?
136100
Sinkhole Quiz- How much do you know about sinkholes?
1050
210
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker