TVL 3 - Programming

What software do you use to make databases?

• Access

• Excel

• PowerPoint

• Word

In your database, information is stored in the ...

• Table

• Report

• Query

• Form

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

• Record

• Garden

• Field

• Stage

Access offers different views of objects. Which view do you use to edit a table?

• Datasheet View

• Design View

• Table View

• Print View

Of the 4 Database Objects, which one does NOT include a wizard?

• Tables

• Forms

• Queries

• Reports

What are the best match for below data type description?

A simple alphanumeric data type such as names, titles, etc. which is limited to a maximum of 255 characters in length, which is controlled by field size.

• Short Text

• Long Text

• Number

• Currency

What are the best match for below data type description?

Data values for the years 100 through 9999.

• Short Text

• Long Text

• Date/Time

• Currency

What are the best match for below data type description?

Store data attachment files such as pictures, documents, spreadsheets, or charts in the database.

• AutoNumber

• Attachment

• Yes/No

• Hyperlink

A unique identifier used in creating a table that assures there will be no duplicate data.

• Primary Key

• Query

• Data Type

• Secondary Key

What are the best match for below data type description?

Boolean (true/false) data; Access stores the numeric value zero (0) for false, and -1 for true.

• AutoNumber

• Long Text

• Yes/No

• Currency