S3 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

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

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

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

Robert needs to create a database of all his friends. In a table, what is last name considered?

• Field

• Record

• Table

• Cell Address