Font size
WorksheetsReview and practice Database Concepts
Total questions: 18
Worksheet time: 24mins
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.
What are some common data manipulation operations?
Transcribing, encoding, compressing
Storing, deleting, indexing
Filtering, sorting, aggregating, merging, reshaping
Calculating, visualizing, exporting
How do you establish a one-to-many relationship in Access?
Use a foreign key in both tables referencing each other.
Establish a relationship by merging the two tables into one.
Create a single table with multiple primary keys.
Create two tables, define a primary key in the primary table, and a foreign key in the related table that references the primary key.
Explain the difference between a database and a spreadsheet.
Match the following
Table
A collection of data organized.
Field
A single piece of data within a table.
Record
A set of fields that define a record.
Primary Key
A unique identifier for a record.
Foreign Key
A key that links two tables.
Drag the fields into the correct table category.
Name
Age
Address
Product Name
Price
Quantity
Click on parts of a given database structure diagram.
Look at the diagram and click on the following:
Primary Key
Foreign Key
Arrange the steps to create a database structure in the correct sequence.
Identify the tables needed based on data requirements.
Define the fields for each table.
Select a Primary Key for each table.
Establish relationships between tables.
Normalize the database to avoid redundancy.
Examine the diagram of the Form Design Interface below. Identify and label the following components:
Form Header
Ribbon
Detail Section
Layout View
Add New Record
