NEW
Font size
WorksheetsBIS Workshop W9
Total questions: 10
Worksheet time: 8mins
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
