N4/5 Admin - Databases

What is a database?

• something that holds data

• a program on a computer

• something that finds data

• something that sends data

In a TABLE, a column is known as a...

• Record

• Field

• Row

• Data

In a TABLE, a row is known as a...

• Information

• Column

• Data

• Record

The best data type to choose for a memberID would be

• Number

• Date/Time

• Text

• Currency

The best data type to choose for date of birth would be

• Number

• Date/Time

• Text

• Currency

The software that we use to create a database is

• Microsoft Publisher

• Microsoft Word

• Microsoft Excel

• Microsoft Access

In a database, a "form" allows you to...

• create a query
• enter data and edit it in a simple form that consists of the fields from a table

Keisha wants only Beyoncé songs from her database. What should she use to see and save them?

• Filter
• Form
• Query

Nick wants Access to assign an ID number to each record. What is this called?

• Data Type
• auto numbering
• Properties

The swim coach is looking for swim team purchase orders  that are greater than $200. What criteria would give her this info?

• >200 OR swimming
• >=200 OR swimming
• >200 AND swimming