Maker LogoSuper Survey Maker
Survey MakerSurvey TemplatesContactPrivacy & 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 Surveys

How do you feel about The Pattern of Life?
6328
Md
201027
Comprehensive Computer, Network, Security and Support Checklist
75380
INDIVIDUALIST VS COLLECTIVISM
13615
More discord Text Channels?
320
360 Assessment-David
10515
7Bit Casino Quick Info - Dollar Deposits, Mobile Compatibility
210
Book Dit 30 Minutters Webshop Strategi Opkald (10.000kr Værdi)
1780
Make your own Survey
- it's free to start.
Super Survey Logo
Powered by
Super Survey Maker | Super Templates Make your own Survey