Review and practice Database Concepts

What is a database?

• A database is an organized collection of data that can be easily accessed, managed, and updated.

• A database is a collection of random files without structure.

• A database is a physical storage device for files.

• A database is a type of software used for graphic design.

Why is it important to create an appropriate database structure?

• It is important to create an appropriate database structure to ensure data integrity, optimize performance, and facilitate efficient data retrieval.

• To make the database visually appealing.

• To reduce the size of the database files.

• To ensure all data is stored in a single table.

What are the steps to create a table in Access?

• Open Access and delete an existing database.

• 1. Open Access and create a new database. 2. Go to 'Create' tab and select 'Table Design'. 3. Define fields and data types. 4. Set primary key if necessary. 5. Save the table.

• Go to 'Home' tab and select 'Import Data'.

• Define fields and data types in Excel before importing.

How do you define primary keys in a table?

• Primary keys are optional for every table.

• A primary key is a column that can contain duplicate values.

• A primary key can be any column in a table.

• A primary key is a column or set of columns that uniquely identifies each row in a table.

What is the purpose of relationships in a database?

• To eliminate the need for data normalization.

• To store data in a single table only.

• To create visual representations of data without structure.

• The purpose of relationships in a database is to connect and organize data across different tables, ensuring data integrity and facilitating efficient data retrieval.

How can you enter data into a table in Access?

• Use SQL queries to add data to the table.

• Enter data by importing from an Excel file.

• Create a new table and copy data from another database.

• Open the table in Datasheet View and enter data directly into the cells.

What is the difference between importing and entering data?

• Importing data is only for large datasets.

• Entering data requires special software tools.

• Importing data is always faster than entering data.

• Importing data is bulk transfer from external sources, while entering data is manual input.

How do you create a data entry form in Access?

• Select the Table Design view to create a data entry form.

• Import a data entry form from Excel to Access.

• Use the Form Wizard in the Create tab to create a data entry form.

• Use the Query Builder to create a data entry form.

What are the benefits of using forms for data entry?

• Forms eliminate the need for any data validation.

• Forms are only useful for collecting payments.

• Using forms slows down the data entry process.

• Benefits of using forms for data entry include improved data accuracy, consistency, user guidance, and efficiency.

How can you manipulate data in Access?

• Access does not support any programming languages.

• Use queries, forms, reports, macros, and VBA.

• Use only tables to store data.

• Data cannot be manipulated in Access.