Understanding Databases and Forms

What is a database?

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

• A database is a physical storage device for files.

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

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

What are the main types of databases?

• Relational, NoSQL, Object-oriented, Graph

• Hierarchical, Relational, Network, Spatial

• Object-relational, Multi-model, In-memory, XML

• Flat-file, Key-value, Document-oriented, Time-series

Define a form in the context of databases.

• A form is a type of database management system.

• A form is a method for encrypting database data.

• A form is a user interface for data entry and modification in a database.

• A form is a programming language for database queries.

What is an Access object?

• A programming language for web development.

• A component in Microsoft Access representing data or functionality, like tables or forms.

• A feature in Microsoft Word for creating documents.

• A type of database used for storing images.

List three common data types used in databases.

• Character

• Integer, String, Date

• Boolean

• Float

What is the purpose of a primary key in a database?

• To store large amounts of data efficiently.

• The purpose of a primary key in a database is to uniquely identify each record in a table.

• To define the data type of each column in a table.

• To group related records together in a table.

Explain the difference between a table and a form.

• A table is used for calculations, while a form is for displaying data.

• A table and a form are both used to display images.

• A table is a type of form that collects user input.

• A table displays data in rows and columns, while a form allows users to input data.

What is normalization in database design?

• A method to increase data redundancy in a database.

• Normalization in database design is the process of structuring a database to minimize redundancy and dependency by organizing fields and tables.

• A technique for encrypting sensitive data in tables.

• A way to combine multiple databases into one large database.

How do you create a form in Microsoft Access?

• Use the 'File' menu to create a new form

• Drag and drop tables directly onto the main screen

• Open the database, go to 'Create' tab, select 'Form Design' or 'Form Wizard', add fields, and save the form.

• Select 'Form Layout' from the 'Home' tab

What is a foreign key?

• A foreign key is a field that stores data from the same table.

• A foreign key is a type of primary key.

• A foreign key is a field that links two tables by referencing the primary key of another table.

• A foreign key is a unique identifier for a table.