database

A quick way to find data in a database is to use _____.

• queries
• quandries
• questions
• file folders

Data _____ helps ensure that an incorrect entry isn't made.

• validation
• checks
• accuracy
• integrity

What is the name of the a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools?

• MS Access
• MS Word
• MS Excel
• MS PowerPoint

Chloe is creating a database for several customers. What is the data type for the field total sales?  

•  Yes/No
•   Data 
•  Number
•   Currency

A relational database consists of a collection of

• Field
• Record
• Table
• Keys

which one of the following cannot be taken as a primary key?

• ID
• RegistrationNo
• DepartmentID
• Street

Which software program do we use to create a database

• Microsoft Excel

• Microsoft Word

• Microsoft Access

• Microsoft Publisher

If we are running a query and looking for all records with a date before 1999, we type what into the criteria?

• >1999

• >01/01/1999

• <01/01/1999

• <1999

• SELECT genre, year FROM movies WHERE genre = 'action' ORDER BY year ASC LIMIT 11;
  
• SELECT genre, year FROM movies WHERE genre = action ORDER BY year DESC LIMIT 11;
  
• none of these
• SELECT genre, year FROM movies WHERE genre = 'action' ORDER BY year DESC LIMIT 11;
  

A query is used to

• Sort the database in alphabetical order

• Search the database

• Delete records

• Create a form