Microsoft Access Database Basics

What are the key principles of database design?

• Data encryption

• Backup and recovery

• Data modeling, Normalization, Indexing, Data integrity, Query optimization

• Data validation

How does normalization help in database design?

• Normalization reduces data redundancy, improves data integrity, and enhances flexibility and scalability of the database structure.

• Normalization complicates data storage, reduces data consistency, and limits database scalability.

• Normalization has no impact on data redundancy, data integrity, or database structure flexibility.

• Normalization increases data redundancy, decreases data integrity, and limits flexibility of the database structure.

What is the primary key in a database?

• Unique identifier for each record

• Most frequently occurring value

• Randomly generated number

• Main value for each table

Explain the concept of data types in Microsoft Access.

• Data types in Microsoft Access are used to categorize data based on their color

• Data types in Microsoft Access determine the font style of the data stored in a field

• Data types in Microsoft Access define the size of the paper used for printing data

• Data types in Microsoft Access define the type of data that can be stored in a field, such as Text, Number, Date/Time, Memo, and Yes/No.

What are the different data types available in Microsoft Access?

• Image

• Boolean

• Decimal

• Character

• Text, Memo, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE Object, Hyperlink, Attachment, Calculated

Why is it important to choose the correct data type for a field in Access?

• To confuse users

• It is important to choose the correct data type for a field in Access to ensure data integrity, improve query performance, aid in data validation, save storage space, and prevent data conversion errors.

• To make the database slower

• To increase the chances of errors

What is the purpose of setting field properties in Access?

• To add animations to the field

• To change the font style of the field

• The purpose of setting field properties in Access is to define the characteristics and behavior of the data stored in those fields.

• To play music when the field is clicked

How can you ensure data integrity in a database?

• Implement constraints, perform regular backups, use transactions, and validate input data.

• Ignore data validation, use outdated software, rely solely on manual data entry

What is the difference between a text and memo data type in Access?

• Memo data type is used for numeric values, while text data type is for text only

• Text data type allows for unlimited characters, while memo data type has a character limit

• Storage capacity is the key difference between text and memo data types in Access.

• Text data type is used for storing images, while memo data type is for text data only

Explain the use of the number data type in Access.

• Number data type in Access is used for storing images

• Number data type in Access is only for dates

• The number data type in Access is essential for storing and manipulating numerical values in databases.

• The number data type in Access is used for storing text values