Summary
Highlights
The video starts by welcoming viewers and explaining that the tutorial will focus on creating tables in an existing Access database. It references a previous video on database creation and emphasizes a more detailed approach to table creation.
The instructor opens an already created Access database. It shows a previously created table and its design view, highlighting fields, data types, and an existing record. The goal is to create new tables in a more structured way.
The video presents two ways to create tables: directly clicking 'Table' or using 'Table Design.' The instructor prefers 'Table Design' for its detailed control over field names, data types, and descriptions, making it visually more appealing and organized.
The tutorial begins creating a 'Professors' table. The first field, 'ID Profesor,' is set as an auto-incrementing primary key to ensure unique identification. The importance of using numerical IDs over names for primary keys is explained, as names can be repeated.
The fields 'Nombre' (Name) and 'Apellido' (Last Name) are added with 'Short Text' data type and a field size of 50 characters. Both are marked as 'Required.' For 'Fecha Nacimiento' (Date of Birth), the 'Date/Time' data type is selected, and the 'Short Date' format is chosen for presentation.
A 'Teléfono' (Phone) field is created as 'Short Text' with a size of 15. A crucial feature, the 'Input Mask,' is demonstrated to guide users on the phone number format (e.g., '0000-0000'). The 'Teléfono' field is made optional. Lastly, 'Especialidad' (Specialty) is added as 'Short Text' with a size of 50 and set as optional.
The 'ID Profesor' field is designated as the primary key. The table is then saved with the name 'Profesores'. This sets up the structure for entering professor data.
The video demonstrates how to switch to datasheet view and insert a sample record for a professor. It highlights how the auto-incrementing ID works and how the date picker and input mask assist in data entry for 'Fecha Nacimiento' and 'Teléfono' fields, respectively. The record is then saved.
A new table named 'Asignaturas' (Subjects) is created using 'Table Design.' 'ID Asignatura' is set as an auto-number primary key, and 'Nombre de la Asignatura' (Subject Name) is defined as 'Short Text' with a size of 50 and marked as required. The table is saved, and a sample subject, 'Ciencias Naturales,' is added.
The video concludes by showing the three created tables ('Tabla1,' 'Profesores,' 'Asignaturas') in the database. The instructor hints at the next video, which will cover establishing relationships between these tables. A call to action for likes, subscriptions, and notifications is made.