37] Seen above are some of the numeric fields in the Employee database table design. In the space below, describe how to delete the HourlyRate field.
_________________________________________________________________________________________________
Signature _______________________
Data Types, Table Processing & Design Layouts Lab
Microsoft Access Database
Dr. Thomas E. Hicks
Computer Science Department
Trinity University
2] A(n) ________________________ is an individual sub-components of a record.
3] A record is _______________________________________________________________________________________
__________________________________________________________________________________________________
4] A database is _____________________________________________________________________________________
__________________________________________________________________________________________________
5] A database table is _________________________________________________________________________________
__________________________________________________________________________________________________
6] A database table field is _____________________________________________________________________________
__________________________________________________________________________________________________
7] A ___________________________ is the information related to one entity (one part, one client, or one student).
8] List the five major data types discussed in lecture. __________________________________________________________
__________________________________________________________________________________________________
9] The Numeric data types can be any one of the following: Byte________________________________________________
__________________________________________________________________________________________________
10] List at least two different ways in which next New
Years might be entered into a date field.
_________________________________________________ ________________________________________________
11] The primary goal of a DBMS is to ______________________________________________________________________
___________________________________________________________________________________________________
12] ____ A container is needed in which to store the number
of grains of sand on the earth; select the best data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
13] ____ A container is needed in which to
store a person's shoe size; select the best data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
14] ____ A container is needed in which to store
a person's anniversary; select the best data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
15] ____ A container is needed in which to store
a person's pay/hour ($); select the best data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
16] ____ A container is needed in which to store
a person's bowling score; select the best data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
17] ____ A container is needed in which to store
lots of character information about a person's family; select the best
data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
18] ____ A container is needed in which to store today's
temperature (degrees Fahrenheit); select the best data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
19] ____ A container is needed in which to
store the number of children; select the best data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
20] ____ A container is needed in which to store
Trinity University mail box numbers; select the best data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
21] ____ A container is needed in which to store
a person's birthday; select the best data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
22] ____ A container is needed in which to store
lots of character information about your friend; select the best data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
23] ____ A container is needed in which to store
the distance from one of our solar system stars to our sun; select the
best data type.
| a) Text - Char | d) Numeric [Byte] Data Type | g) Numeric [Single] Data Type |
| b) Date | e) Numeric [Integer] Data Type | h) Numeric [Double] Data Type |
| c) Memo | f) Numeric [Long Integer] Data Type | i) Logical - Y/N |
24] In the space below, describe how one opens/starts Microsoft Access.
_________________________________________________________________________________________________
_________________________________________________________________________________________________
25] When adding a new table to the database, we
have most commonly been asked to select which of the following:
| a) Datasheet View | d) Import Table |
| b) Design View | e) Link Table |
| c) Table Wizard | f) None of the above |
26] Which of the following field tokens would be most appropriate:
a. Marital Status27] The file extension for a Microsoft Access database is ______________________________________________________
b. maritalStatus
c. MaritalStatus
d. None of the above
28] A container is needed in which to store a person's home state; what size container would be appropriate? _____________.
29] _________ {T/F} When a field is Required, the user must either delete the record or enter data into that field prior to moving to another record.
30] _________ {T/F} Suppose you have just make some changes from the design view of the Customer table. These changes are always automatically stored each time you exit the design view.
31] __________ You have been hired by the Trinity University Library to create a database table, called Books. Which of the following would be the best field name for the Date Published? a) datepublished, b) Date Published, c) DatePublished, d) date, e) all of these are bad field names.
32] __________ You have been hired by the Trinity University Library to create a database table, called Books. Which of the following would be the best caption for the Date Published? a) datepublished, b) Date Published, c) DatePublished, d) date, e) all of these are bad field names.
33] You have been hired by the Trinity University Library to create a database table, called Books. In the grid below, complete the information for 3 text fields that you think should be part of that Books table.
|
|
Type |
Size |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
34] You have been hired by the Trinity University
Library to create a database table, called Books. In the grid below, complete
the information for 1 logical (Y/N) field that you think should be part
of that Books table.
|
|
Type |
|
|
|
35] You have been hired by the Trinity University
Library to create a database table, called Books. In the grid below, complete
the information for 1 numeric field that you think should be part of that
Books table.
|
|
Type |
Size |
Places |
|
|
|
36] You have been hired by the Trinity University
Library to create a database table, called Books. In the grid below, complete
the information for 1 date field that you think should be part of that
Books table.
|
|
Type |
|
|
|
|
37] Seen above are some of the numeric fields in
the Employee database table design. In the space below, describe how to
delete the HourlyRate field.
_________________________________________________________________________________________________
_________________________________________________________________________________________________
38] Seen above are some of fields in the Employee Database
table browse. In the space below, describe how to sort the records by the
State
field.
_________________________________________________________________________________________________
_________________________________________________________________________________________________
_________________________________________________________________________________________________
39] ___________ {T/F} When the Employee database is sorted by the State field, this reorder change occurs immediately!
40] ___________ {T/F} When the Employee database is sorted by the State field and saved, this reorder change occurs the next time the table is opened in the browse mode.
41] ___________ {T/F} When the Employee database may be sorted by any one of the fields.
42] ___________ {T/F} When the Employee database is sorted by the State field and saved; the table is re-opened in the browse mode. Records printed now appear in order by state.
43] ___________ {T/F} If someone is in the browsing mode, they can increase/decrease the width of the field width to most appropriately display the current information.
44] ___________ {T/F} The sorting operation in Microsoft Access ignores case sensitivity (i.e.. - "Tom Hicks" is sorted just like "tom hicks").
45] In the space below, describe why one would like to Freeze Columns.
_________________________________________________________________________________________________
_________________________________________________________________________________________________
46] ___________ {T/F} Frozen Columns do not remain
frozen when the records are printed.