Database Concepts 1
10 Questions
| Total Attempts: 4788
Settings
Tests concepts of database and knowledge of MS Access
Questions and Answers
- 1.A single set of related data values is referred to as
- A.
Data value
- B.
Record
- C.
Field
- D.
Table
- 2.What is used to uniquely identify each record in a table?
- A.
Foreign key
- B.
Field
- C.
Datatype
- D.
Primary key
- 3.___________ data type stores date and time values between the years 100 through 9999.
- A.
Date
- B.
Time
- C.
Date/Time
- D.
Memo
- 4.The ______________ of a table is used to modify the design of a table, like modifying the name of a field or changing the data type of a field.
- A.
Datasheet View
- B.
Design View
- C.
Table View
- D.
Wizard View
- 5.You can select multiple fields of a table in design view by using the ________ key.
- A.
Alt
- B.
Spacebar
- C.
Shift
- D.
Tab
- E.
Ctrl
- 6.What does x represent in the figure?
- A.
Row Selector
- B.
Row Holder
- C.
Row Field
- D.
Row Data
- 7.What validation rule should be entered for a StudentID which should start with the letter "S"?
- A.
Like 'S*'
- B.
Like S*
- C.
Like "S"
- D.
Like "S*"
- 8.In the datasheet view of the Student table, the StudentAddress field needs to be displayed as Address. Which field property can be used to achieve this?
- A.
Caption
- B.
Validation Text
- C.
Required
- D.
Validation Rule
- E.
Default
- 9.
- A.
True
- B.
False
- 10.What is the purpose of forms?
- A.
It is used to store data
- B.
It provides a user-friendly interface for entering data into tables
- C.
It is used to retrieve data from tables
- D.
It is used to print or preview data in different formats
Back to top