✅ Como CREAR una BASE DE DATOS en ACCESS Desde Cero 😉 (2013, 2016, 2019, etc)

Introduction to Database Creation in Access0:00:00

The video introduces a tutorial on creating a database in Access from scratch, emphasizing that the process is applicable across various Access versions (2013, 2016, 2019, and older). It defines a database as an organized set of data for later use, where information is stored in tables.

Creating a New Blank Database0:00:46

The first step is to open Access and select the option to create a 'blank database'. The user then provides a name for the database, such as 'Escuela' (School), and chooses a location to save it. After confirming the location, clicking 'Create' opens the Access interface with an initial, empty table.

Designing a Table with Field Properties0:01:44

Instead of using the default table view, the tutorial advises closing it and navigating to the 'Create' tab to use 'Table Design'. This method offers a more detailed way to define fields. Each field requires a name, a data type, and an optional description. Key field properties discussed include 'Field Size' for character limits and 'Required' to make data entry mandatory.

Defining Fields and Data Types for the 'Students' Table0:02:31

The video guides through creating several fields for a 'Students' table: 'ID_student' (AutoNumber for unique, sequential IDs), 'Name' (Short Text, size 50, required), 'Last Name' (Short Text, size 50, required), 'Residence' (Long Text, not required), 'Phone' (Short Text, size 15, not required), and 'Age' (Number, integer, required).

Setting a Primary Key and Saving the Table0:06:29

A crucial step is to establish a primary key for the table, which uniquely identifies each record. For the 'Students' table, 'ID_student' is selected as the primary key due to its AutoNumber property ensuring uniqueness. The field is selected, and 'Primary Key' is clicked. Finally, the table is saved with the name 'Students'.

Entering and Managing Records0:07:56

After saving, the table view is switched to 'Datasheet View' to allow data entry. The 'ID_student' field automatically assigns a number upon creation. The tutorial demonstrates entering a sample record, highlighting that 'Required' fields must be filled, while others can be left blank. It also shows how Access prevents saving if a required field is empty.

Conclusion and Next Steps0:09:51

The video concludes by summarizing the creation of the first database and table. It teases the next tutorial, which will cover creating more tables and exploring additional data types and properties to further enhance database design. The presenter encourages viewers to like, subscribe, and activate notifications.