BIS Workshop W9

Primary key must be __________ in a database.

• unique

• duplicated

• common

• constantly changing

The four main objects in Access are:

• Tables, charts, fields, buttons

• Tables, fields, cells, forms

• Forms, queries, cells, charts

• Queries, forms, tables, reports

Which can be used to alter data type of fields in Access?

• User view

• Layout view

• Design view

• Datasheet view

Which of the following statements is TRUE regarding Lookup Wizard?

• Lookup Wizard can limit the number of characters entered for a field.

• Lookup Wizard can be created using 'hyperlink' data type.

• Lookup Wizard can be used to select values for Excel sheet.

• Lookup Wizard can be used to create drop down list.

Access buttons CANNOT

• Go to next record

• Save form

• Undo record

• Open report

Based on the given diagram, which of the following statement is true?

• One consultant can work with only one students.

• Each student can have many consultants.

• One consultant can be responsible for multiple students.

• The database model has 4 entities.

Tables are set up to contain columns and rows of information. In a database table, the columns are called:

• Fields

• Cells

• Record

• Criteria

Let's say our bakery wants to create a list of customer names and email addresses for customers who pre-ordered an item and picked it up during the month of December. The tables needed for the form are shown in this image. Which of the following statements is TRUE?

• The form is created from the Customers table with a subform.

• The only form layout for Orders table is tabular.

• The form is created from the Orders table with a subform.

• We cannot create a subform from these two tables.

Which object is used to create forms in Access?

• Tables only

• Queries and reports

• Tables and queries

• Tables an dreports

Which of the following is not a valid data type in Access?

• AutoNumber

• Currency

• Memo

• Picture