12 Questions
What is the primary key of the "productos" table?
codigo
Which field is calculated automatically in the "detalle" table?
importe
What is the relationship between the "productos" and "detalle" tables?
One-to-many
What is the purpose of the form created using the "facturar" and "detalle" tables?
To display data by facturas
How many records were entered into the "productos" table?
3
What is the data type of the "precio" field in the "detalle" table?
Currency
¿Cuál es el propósito de crear una base de datos llamada 'ventas' en Microsoft Access?
Crear una base de datos para gestionar las ventas y almacenar información de productos, facturas y detalles.
¿Cuántos campos tiene la tabla 'facturar'?
Cuatro campos: fecha, n_factura, doc_guion_guion_bajo y clientes.
¿Qué tipo de campo es el campo 'importe' en la tabla 'detalle'?
Campo calculado.
¿Qué relación se establece entre las tablas 'productos' y 'detalle'?
La clave principal 'con' en la tabla 'detalle' se relaciona con la clave principal 'col' en la tabla 'productos'.
¿Qué tipo de campo es el campo 'nombrado' en la tabla 'productos'?
Tipo texto corto.
¿Cómo se configura el formulario para visualizar los datos?
Se configura para visualizar los datos por facturas y mostrar el detalle en una hoja de datos.
Study Notes
- A new database named "ventas" is created to demonstrate creating relationships between tables.
- Three tables are created: "productos", "facturar", and "detalle".
- The "productos" table has two fields: "codigo" (short text, primary key) and "nombre_producto" (short text).
- The "facturar" table has four fields: "fecha" (date/time), "n_factura" (number, primary key), "doc_identidad" (number), and "cliente" (short text).
- The "detalle" table has five fields: "codigo" (short text), "n_factura" (number), "cantidad" (number), "precio" (currency), and "importe" (calculated field, multiplying "cantidad" and "precio").
- The relationships between the tables are established, with the "codigo" field in "productos" related to the "codigo" field in "detalle", and the "n_factura" field in "facturar" related to the "n_factura" field in "detalle".
- Data is entered into the "productos" table, including three records with codes "001", "002", and "003".
- A form is created using the "facturar" and "detalle" tables, with fields selected from both tables.
- The form is designed to display data by facturas, with a subform for the detalle records.
- The form is used to enter new records, with automatic calculations for the "importe" field in the "detalle" table.
Learn how to create a database with relationships between tables, including designing forms for data entry and calculation. This quiz covers the creation of a database named 'ventas' with three tables: 'productos', 'facturar', and 'detalle'.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
