MS Access - Tables And ForMS
This is a quick quiz to test your basic knowledge of MS Access forms, tables and data types.
- 1.
A database is- A.
A piece of computer software
- B.
Microsoft Access
- C.
Data kept in a logical structure of records and fields
- D.
A place to keep information
- 2.
A piece of data is kept in
- A.
A paddock
- B.
The hard drive
- C.
A field
- D.
A cell
- 3.
A record is
- A.
An old-school way of listening to music but it's coming back
- B.
Information about a person
- C.
A row of data that relates to a single object
- D.
Found online
- 4.
Every record must have a primary key number / identifier
- A.
True
- B.
False
- 5.
Design view
- A.
Lets us enter data into our table
- B.
Helps to create the table's structure
- C.
Is only for forms
- D.
Is for searching our data
- 6.
To enter data into a table we need to be
- A.
Connected to the internet
- B.
Using every field
- C.
Creating a primary key
- D.
In datasheet view
- 7.What is a data type in databases?
- A.
Types of data including: date, currency, autonumber & text
- B.
A yes or no option
- C.
The unique identifier for a record
- D.
A special font
- 8.
This is an example of
- A.
A table
- B.
A form
- C.
A database
- D.
Book Information
- 9.To make sure people enter only clean data we
- A.
Lock the database
- B.
Create validation rules
- C.
Make forms
- D.
Make sure that we only use text as our data type
- 10.
Which one of these is not an example of a form design view?
- A.
Layout View
- B.
Design View
- C.
Form View
- 11.
This is an example of
- A.
A table
- B.
A form
- C.
A database
- D.
Book Information
- 12.Which of these is not a sufficient reason for creating forms?
- A.
Forms help with accurate data input
- B.
Forms display record by record
- C.
Forms can have pictures on them
- D.
Forms provide a user-friendly way to manage Databases.
- 13.
In order to shift my fields and boxes around I need to be in
- A.
Form view
- B.
Layout view
- C.
Design view
- 14.
Which option is the best option for creating a form from the data you already have?
- A.
Form
- B.
Form Design
- C.
Blank Form
- D.
Form Wizard
Questions: 10 | Attempts: 380 | Last updated: Mar 22, 2022
-
Sample QuestionBelow are the benefits from access permission, EXCEPT
Questions: 50 | Attempts: 144 | Last updated: Mar 15, 2022
-
Sample QuestionWhat is the Patient Protection and Affordable Care Act (PPACA)?
Questions: 12 | Attempts: 135 | Last updated: Mar 20, 2022
-
Sample QuestionA DATABASE IS MADE UP OF
Back to top