Get Stronger: Microsoft Access Basic Skills

1. What is the first step in creating a database in Microsoft Access?

A) Setting a primary key
B) Naming the database
C) Adding tables
D) Importing data

2. What should you consider when naming a database?

A) Using special characters
B) Using spaces in names
C) Keeping the name descriptive
D) Using uppercase letters only

3. What is a field in an Access table?

A) A type of query
B) A single piece of data
C) A collection of tables
D) A type of form

4. Which data type in Access is best for storing large amounts of text?

A) Short Text
B) Long Text
C) Number
D) Date/Time

5. What is the purpose of a primary key in a database table?

A) To store the data
B) To ensure that each record is unique
C) To create relationships between tables
D) To display data in forms

6. How do you set a primary key in Microsoft Access?

A) Right-click on the field and select “Set as Primary Key”
B) Double-click the field name
C) Enter the field properties
D) Delete all other keys

7. What is the default data type for a new field in Access?

A) Short Text
B) Number
C) Long Text
D) Date/Time

8. Which of the following is NOT a valid field property in Access?

A) Field Size
B) Validation Rule
C) Decimal Places
D) Field Count

9. When would you use the AutoNumber data type?

A) When you want to automatically generate a unique identifier for each record
B) When storing a combination of text and numbers
C) For date and time fields
D) For storing large text fields

10. What is an index in a database used for?

A) To reduce the size of the database
B) To improve the speed of data retrieval
C) To create relationships between tables
D) To display data in a specific format

11. What should you consider when designing field names?

A) They should be as short as possible
B) They should not include spaces or special characters
C) They should be written in all capital letters
D) They should match the database name

12. Which of the following is a valid data type for a field in Access?

A) Boolean
B) Formula
C) Hyperlink
D) Memo

13. What does the “Field Size” property control for a text field?

A) The number of records in the table
B) The length of data that can be entered
C) The display format of the field
D) The width of the field in forms

14. What is the maximum length of a Short Text field in Access?

A) 50 characters
B) 255 characters
C) 500 characters
D) Unlimited

15. What happens if you set a field as the primary key and it contains duplicate values?

A) Access automatically deletes the duplicates
B) Access will not allow you to set it as the primary key
C) Access will prompt you to remove duplicates
D) Access will set the first value as the key and ignore the rest