In this course you will create queries both to visualize data and to modify the data of the tables, and you will see that behind the queries there is a language, SQL, which is standard in the database programs.
This product is no longer in stock
Information of: Access 2016 advanced: Consultations
View and modify data with queries in Access 2016
The queries are an important part of Access 2016. In this course you will create queries both to visualize data and to modify the data of the tables, and you will see that behind the queries there is a language, SQL, which is standard in the base programs of data. In this course you will also see how to work with the data resulting from a query and the six types of queries that you can create through the design or with the help of the assistant. Selection queries, among others, are fundamental to be able to collect information from several tables and from that data source, to be able to create reports or forms.
Queries to visualize data
In this chapter we will see what a query is, how we make queries for one or more tables, what types of queries are there, how we can modify a query, which is SQL, the different views of a query.
Introduction to consultations 04:48
Using the selection query wizard 04:12
Queries of selection of a table 06:51
Queries of selection of several tables 02:38
Advanced filters: parameters 03:51
Totals button 04:58
Numeric calculated fields, date and text 05:46
Create a cross-reference query with the assistant 02:49
Create a cross-reference query in the design 03:54
In this chapter we will see that it is a query of actions, which are the queries of actions, which make the queries of actions and execute the query that is really important in the queries of actions.
Differences between consultations of actions and the others 03:45
Table creation queries 04:58
Update consultations 09:32
Generator of expressions 03:42
Deletion inquiries 02:29
Append attachments 04:13
Other options of the design of the consultations 02:40
Work with the data
In this chapter we will see how we can format the data of the tables, how we want to visualize the tables and especially the options that we have to sort and filter the data to clearly see the required information.
Data format and use of grids 03:07
Format of fields in the data sheet view 03:08
Other options to work in data view 04:37
Applying filters 01:55
Print options 03:44
Dismissal of advanced Access 2016 course: Consultations 01:50
Size: 202 MB
Formators: Francisco José Carrasco Gómez
Content: 22 Videos
Duration: 1:29 hours
Software: Office, Office 2016, Access, Access 2016
Base Files: If it contains
Date of publication: Feb 27, 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!
If the question you have has not yet been answered here, use the form below to ask something about this addon.