Curso de Access 2016. 3. Crear una tabla.

The video introduces how to create a table in Access 2016, defining its fields and assigning a primary key. It starts by opening an existing database.

This section explains creating a table directly from the data entry view. It shows how to add fields, define their data types (e.g., currency, short text), and rename them. It also demonstrates entering data and explains the auto-incrementing ID field.

The video moves on to the table design view, which offers more comprehensive field definitions, including descriptions. It showcases creating fields like 'Code' (AutoNumber), 'Book Title' (Short Text), and 'Purchase Date' (Date/Time), along with properties for each data type.

This part details how to save the newly created table (named 'Books') and addresses the prompt about defining a primary key. It demonstrates how to manually assign a primary key to a chosen field (e.g., 'Code') and emphasizes its importance for table relationships.

Finally, the video shows how to switch to the datasheet view to enter data into the newly designed table. It illustrates populating fields like 'Title' and 'Purchase Date' using the calendar tool, and concludes with a reminder about additional free computer courses.