Access Database Concepts and Practices

This video tutorial guides students through tasks one and two of the January 2022 exam, focusing on creating a relational database. It covers the importance of reading the exam's information page, using naming conventions, normalizing data, establishing relationships, and entering data with validation. The tutorial emphasizes minimizing data duplication and ensuring data integrity.

What is the first step you should take when you open the exam paper?

• Check the time remaining for the exam.

• Read the information to students page.

• Skip to the last question.

• Start answering questions immediately.

Which prefix is typically used for naming tables in Access?

• table_

• t_

• tab_

• tbl_

What is the purpose of normalization in database design?

• To minimize data duplication and ensure data integrity.

• To make the database more complex.

• To increase data redundancy.

• To create a flat file database.

Why is a joining table necessary in a many-to-many relationship?

• To eliminate the need for primary keys.

• To simplify the database design.

• To allow one-to-many relationships instead.

• To increase data redundancy.

What data type should be used for a primary key in Access?

• Number

• Short Text

• AutoNumber

• Date/Time

How can you ensure that a field in Access does not accept null values?

• Use a combo box for the field.

• Set the field size to zero.

• Use a validation rule that specifies 'Is Not Null'.

• Leave the field type as default.

What is the purpose of an input mask in Access?

• To change the data type of a field.

• To format how data is displayed and entered.

• To increase the size of the database.

• To create a new table.

What should you do if you encounter a problem with data entry in Access?

• Ignore the problem and continue.

• Delete the table and start over.

• Re-enter the data without changes.

• Check the table design and validation rules.

How can you verify that relationships between tables are correctly established?

• By reviewing the relationship diagram.

• By deleting all data and re-entering it.

• By checking the data entry form.

• By using a different database software.

What is the benefit of using a composite primary key?

• It allows for duplicate entries.

• It creates a unique identifier using multiple fields.

• It simplifies the database structure.

• It eliminates the need for foreign keys.