Font size
WorksheetsMicrosoft Access Practice Quiz
Total questions: 15
Worksheet time: 12mins
Date of birth is considered to be which data type?
short text
long text
Data type: Which of these is an integer?
2.5
7
1/4
0.99
Ava is managing a large dataset for her company's sales records. Why might she prefer using a database over a spreadsheet?
easier to create charts and graphs
more efficient handling of inter-related data
simpler user interface
better for quick calculations
SELECT is a database query that can be used to open a particular record.
True
False
True/False: Microsoft Access is considered to be a database management system.
True
False
In a survey about high school student activities, which of the following is an example of data that could be stored in either character or binary format?
What grade level is the student in?
How many extracurricular activities does the student participate in?
What is the student's GPA?
Has the student completed any volunteer hours?
Data mining is typically done (a) ,
What will the following SQL query return? SELECT * FROM customers WHERE age = "21" AND gender = "male"
an error
all customers who are not 21 years old or male
all customers who are 21 years old and male
all customers who are over 21 and male
Once a database field has been created, it can be difficult to change the format of the field.
True
False
You run the query "SHOW TABLES." The database query will return all tables that are part of a database.
True
False
Which Microsoft Office application shares similar data organization features with Access?
Word
Excel
Outlook
PowerPoint
Nora is working on a database query. To get the results of the query, she needs to (a) the query.
command
return
overwrite
Detail > Modify are commands that bring a user to a screen in the Access Query Wizard that will allow them to add criteria for a query.
True
False
Charlotte is learning how to manage databases. She wants to learn how to import and export a database file. Importing and exporting can be done by using the Open and Save As commands under the File menu.
True
False
Luna is working on a project and needs to choose a software tool for managing databases. Which LibreOffice application is free and is similar to Microsoft Access?
Cabinet
Base
Data
Balance
