Access Advanced Course 2016 Queries

CURS-197

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.

Description


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


Share inquiries
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

Technical data:

Format: .MP4
Resolution: 1280x720p
Size: 202 MB
Spanish Language
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
Company: Video2Brain


See Intro


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.

Download area



Contraseña/Password: www.intarcesoft.com.ve

Author's Website


Pagina Principal

If you like or help this article. Support the developers by buying this material.

Follow us on our social networks


  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.

OS Windows XP o superior
RAM 256 MB
License Freeware
Language Only Spanish
File Size 188 MB
Developer Video2Brain
Grade 
06/09/2017

Excelente

Gran curso

Write your review!

Write a review

Access Advanced Course 2016 Queries

Access Advanced Course 2016 Queries

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.

Ask a question

NO registration required!

If the question you have has not yet been answered here, use the form below to ask something about this addon.

(optional)
*(Required to be notified when an answer is available)

If the download link redirects to another product that is not described in the article or is broken, report it using our Reporting Form

RelatedProducts