Mastering MS Access Basics

What is the purpose of database design?

• To increase the complexity of data management.

• To eliminate the need for data storage.

• To ensure data is stored in a random manner.

• The purpose of database design is to organize data effectively for efficient storage, retrieval, and management.

Name one key element of database design.

• Data Mining

• Normalization

• Data Warehousing

• SQL Injection

What is a primary key in a database?

• A primary key is an optional field in a database.

• A primary key can be duplicated across records.

• A primary key is a type of foreign key.

• A primary key is a unique identifier for a record in a database.

How do relationships between tables enhance database design?

• Relationships between tables have no impact on database performance.

• Relationships between tables improve data integrity and reduce redundancy in database design.

• Relationships between tables complicate data retrieval.

• Relationships between tables increase data duplication.

What is normalization in database design?

• A technique for data encryption

• Normalization in database design is the process of organizing data to minimize redundancy and dependency.

• A way to merge multiple databases into one

• A method to increase data redundancy

What data type would you use for a person's name in Access?

• Long Text

• Number

• Date/Time

• Short Text

Which data type is best for storing dates in Access?

• Text

• Date/Time

• Number

• Boolean

What is the difference between a text field and a memo field?

• A text field can store images, while a memo field cannot.

• Both text and memo fields are used for the same purpose.

• A text field is for numeric input, while a memo field is for dates.

• The difference is that a text field is for short, single-line input, whereas a memo field is for longer, multi-line text.

How do you create a new table in MS Access?

• Right-click on the database, select 'Create Table', and choose a template.

• Open MS Access, go to 'Home' tab, select 'New Table', and enter data directly.

• Use the 'File' menu to import a table from Excel instead of creating a new one.

• Open MS Access, go to 'Create' tab, select 'Table Design', define fields, and save the table.

What is the function of the Design View in Access?

• To create and modify the structure of database objects.

• To run queries on the database.

• To input data into the database.

• To generate reports from the database.