S2 Databases Introduction

What program is used in class for Databases?

• MS Word

• MS Excel

• MS Access

• MS Powerpoint

Each row in a database is called what?

• A Record

• A Field

• An Entity

• A Table

Short Text, Number, and Date/Time are all examples of...

• Data Types
• Filters
• Sorts
• Validations

When you create your database table, it is important to remove what?

• Primary key

• Records
• Fields
• Indexes

True or False: It is important that field headings appear in the right order and are accurate.

• True

• False

Give one example of where a database could be used in real-life.

A query is...

• All the information included in a database

• How you input data into a database

• Another name for a 'record'

• A way to search for specific information

To start a query, you click on Create, and then Query '.......'.?

To sort the records in alphabetical order from A-Z, this is called:

• Sorting in random order.

• Sorting in descending order.

• Sorting in ascending order.

Give one reason why we sort information in a database.