Microsoft Access Practice Quiz

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)   ,

• by software or online tools
• by a human
• through manual analysis
• using traditional statistics

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