AnswersDRHS-Business and Tech BLOCK 07.4410030Designing a Relational Database

Designing a Relational Database Answers

11 verified answers1 views
1
Free Preview

What happens if data is entered in a field without meeting the validation rule?

A
The record is saved to a new table without rules.
B
An error appears, and the record cannot be saved.
C
The record is separated from the rest of the table.
D
An error appears, and a copy of the record is made.
2
Free Preview

3. On the Data tab of the , make a number of choices.

A
Control
B
Lookup
C
Property Sheet
3

4. For the Row Source Type, choose .

A
Value List
B
Manual List
C
Field Source
4

5. For Limit to List, select .

A
No
B
Yes
C
Alternating
5

What should the expression include for validation when allowing for an empty field?

A
a null value
B
a true value
C
a false value
D
an error value
6

How can a user see the properties attached to a field in a database?

A
Use the Design view, and click the data type.
B
Use the Design view, and click the field name.
C
Use the Datasheet view, and click the data type.
D
Use the Datasheet view, and click the field name.
7

What are examples of templates provided by the Input Mask Wizard? Check all that apply.ZIP codespie chartsbar graphsphone numbersSocial Security numbers

A
ZIP codes
B
pie charts
C
bar graphs
D
phone numbers
E
Social Security numbers
8

Which options are available when using a combo box rather than a list box? Check all that apply.A user can type in the values.A user can search for a record.The combo box can sort through records.A user can get values from another query.The combo box includes drop-down menus.A user can retrieve values from another table.

A
A user can type in the values.
B
A user can search for a record.
C
The combo box can sort through records.
D
A user can get values from another query.
E
The combo box includes drop-down menus.
F
A user can retrieve values from another table.
9

What are input masks most useful for in data validation?

A
moving data from one field to another
B
hiding parts of a value that are unnecessary
C
identifying duplicate values in different records in a table
D
ensuring consistent formatting of values in a specific field
10

What is one advantage of using the Option Group Control for data validation?

A
It works best with fields that use the date data type.
B
It alerts the user when the database is about to close.
C
It applies to numeric fields only, eliminating text errors.
D
The data entry is restricted to specific fields, reducing errors.
11

2. Select Change To in the drop-down menu, then select .

A
Value List
B
Validation
C
Combo Box
D
Limit to List

Did you find these answers helpful?

More from this Course

Instruction
14 verified answers

Instruction

Instruction
14 verified answers

Instruction

Assignment
8 verified answers

Designing a Relational Database