Database Design: Creating Relationships and Forms
12 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the primary key of the "productos" table?

  • nombre_producto
  • codigo (correct)
  • doc_identidad
  • n_factura

Which field is calculated automatically in the "detalle" table?

  • cantidad
  • importe (correct)
  • precio
  • n_factura

What is the relationship between the "productos" and "detalle" tables?

  • Many-to-many
  • One-to-many (correct)
  • Many-to-one
  • One-to-one

What is the purpose of the form created using the "facturar" and "detalle" tables?

<p>To display data by facturas (D)</p> Signup and view all the answers

How many records were entered into the "productos" table?

<p>3 (B)</p> Signup and view all the answers

What is the data type of the "precio" field in the "detalle" table?

<p>Currency (C)</p> Signup and view all the answers

¿Cuál es el propósito de crear una base de datos llamada 'ventas' en Microsoft Access?

<p>Crear una base de datos para gestionar las ventas y almacenar información de productos, facturas y detalles.</p> Signup and view all the answers

¿Cuántos campos tiene la tabla 'facturar'?

<p>Cuatro campos: fecha, n_factura, doc_guion_guion_bajo y clientes.</p> Signup and view all the answers

¿Qué tipo de campo es el campo 'importe' en la tabla 'detalle'?

<p>Campo calculado.</p> Signup and view all the answers

¿Qué relación se establece entre las tablas 'productos' y 'detalle'?

<p>La clave principal 'con' en la tabla 'detalle' se relaciona con la clave principal 'col' en la tabla 'productos'.</p> Signup and view all the answers

¿Qué tipo de campo es el campo 'nombrado' en la tabla 'productos'?

<p>Tipo texto corto.</p> Signup and view all the answers

¿Cómo se configura el formulario para visualizar los datos?

<p>Se configura para visualizar los datos por facturas y mostrar el detalle en una hoja de datos.</p> Signup and view all the answers

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.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

Description

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'.

More Like This

Database Concepts Quiz
10 questions

Database Concepts Quiz

WorthChrysocolla avatar
WorthChrysocolla
Relational Database Fundamentals
10 questions
Use Quizgecko on...
Browser
Browser