NEW
Font size
WorksheetsBIS Quiz
Total questions: 10
Worksheet time: 3mins
What is the primary purpose of a Table in MS Access?
A. To write code
B. To perform calculations
C. To store and organize data
D. To make decisions
2. Which of the following is NOT a valid Data Type in MS Access?
A. Number
B. Image
C. Text
D. Currency
3. In a table, a Field refers to:
A. A record in the table
B. A category of data stored
C. A button on the toolbar
D. A page layout format
4. What is a Primary Key used for in a table?
A. To open the database
B. To sort records alphabetically
C. To uniquely identify each record
D. To create forms
5. What kind of relationship connects one record in a table to many in another?
A. Many-to-Many
B. One-to-One
C. One-to-Many
D. Self Relationship
6. Which field would be best to set as a Primary Key?
A. Address
B. Phone Number
C. Email
D. Student ID
7. What does a Foreign Key do in MS Access?
A. Creates a new record
B. Identifies duplicate data
C. Links to a primary key in another table
D. Deletes unwanted fields
8. In MS Access, a Form is primarily used to:
A. Display charts
B. Enter, view, and edit records
C. Backup data
D. Run calculations
9. What is a Secondary Key in MS Access?
A. A key that opens settings
B. A key used to create tables
C. A non-unique field used for sorting or searching
D. The key used for passwords
10. What must you define first when creating a relationship between two tables in MS Access?
A. The type of form
B. The primary and foreign keys
C. The color of the fields
D. The number of records
