Learn with this course to create databases using Microsoft Access 2016. In this course you will create a database from scratch, you will discover the importance of the design of the tables and how to carry it out. You will import and export data and other objects, and you will carry out the most frequent work
This product is no longer in stock
Learn to create databases using Microsoft Access 2016. In this course you will create a database from scratch, you will discover the importance of the design of the tables and how to carry it out. You will import and export data and other objects, and you will carry out the most frequent work with them: filter, search, show and hide fields. Briefly discover what queries are and understand what a relational database is, applying what you have learned through practical examples.
In this chapter we will see how to create and open a database, the different parts that compose it, how to create a table, the views of the different objects and the peculiarities that Access presents over other Office programs.
What is Access 03:51
Basic operations in Access 2016 03:57
Databases with wizard and templates in Access 2016 05:22
Objects of the database in Access 2016 03:06
Access against Excel 01:39
Open in exclusive mode a database in Access 2016 02:19
Maintenance and database options in Access 2016 02:57
Customize the toolbar in Access 2016 04:15
In this chapter we will see how we create the design of a table, the types of data there are, the properties of the text fields, since they are the most used, and the differences between a short text field and long text
Creation of tables in Access 2016 02:43
Types of data in the Access 2016 tables 03:58
Data views in Access tables 2016 02:19
Properties of the Short Text fields in Access 2016 08:46
More properties of the Short Text fields in Access 2016 06:59
Properties and usefulness of Long Text fields 02:53
In this chapter we will see how are the properties of non-text fields, we will see more carefully what each of the types and the particular properties of each of these types of data.
Properties of Number-Currency fields in Access 2016 07:23
Properties of the Date and Time fields in Access 2016 07:41
Properties of the Autonumber fields in Access 2016 05:02
Properties and usefulness of the Yes / No fields in Access 2016 02:58
Object Fields, Attachments and Hyperlink in Access 2016 08:24
Properties of the calculated fields in Access 2016 05:28
Properties of the Access Search Wizard 2016 07:30
Creation of indexes and main key, requirements and utility 03:33
Other table design options in Access 2016 04:48
In this chapter we will see how we can import, export and link data from both Access and other programs that work with databases. We will also analyze the differences between linking and importing, and how we can save these processes.
Import objects in Access 2016 04:03
Link tables in Access 2016 02:53
Differences between importing and linking tables in Access 2016 01:48
Export data in Access 2016 05:39
In this chapter we will see how we can format the data of the tables, how we want to visualize them and, above all, the options we have to sort and filter the data to clearly see the required information.
Data format and use of grids in Access 2016 03:21
Formatting fields in the Data Sheet view in Access 2016 03:23
Other options of the Access 2016 data view 07:45
Cut, copy and paste into tables in Access 2016 04:11
Applying filters in tables in Access 2016 06:11
Advanced filters in the tables in Access 2016 08:22
Print options in the tables in Access 2016 03:14
In this chapter we are going to see what are the relationships of tables, why we have to use relationships, what requirements have to meet the tables we want to relate and how we can create those relationships.
Why use relationships in Access 2016 01:58
Requirements to relate two tables in Access 2016 05:38
Understanding the relations of a database in Access 2016 04:21
Create relationships from 0. Create tables with Access 2016 04:38
Optimization of the design of tables with Access 2016 06:27
Creating relationships between Access tables 2016 03:31
In this chapter we will make an introduction to the queries, we will see what they are for, what types of queries are there, what is behind the queries, why the queries are better than the filters and how to obtain information from several tables.
What they are and what are the queries in Access 2016 05:03
Introduction to queries in Access 2016 06:06
Dismissal of the Access 2016 course essential 01:44
Size: 416 MB
Formators: Francisco José Carrasco Gómez
Content: 43 Videos
Duration: 3:18 hours
Software: Office, Office 2016, Access, Access 2016
Base Files: If it contains
Date of publication: Feb 23, 2017
Totally free of viruses and malicious software, so do not wait any longer to download it now.
Do not forget to give us an opinion about the program, to improve the content.
If you like or help this article. Support the developers by buying this material.
NOTE: Do not forget to follow us on our facebook and twitter social networks so that you become part of our community and receive the notification every time we post something new, so you will not miss anything.
NO registration required!
1 Question(s) answered
If the question you have has not yet been answered here, use the form below to ask something about this addon.