Course Access, Database Data Processing
The Access, database data processing course is intended for users who want to learn to work with Access for the purpose of processing and evaluating data from external sources.
Minimum input knowledge
Routine control of working with a computer.
Course dates Access, Database Data Processing
Course price: 270.00 / 332.10 EUR
without VAT / incl. VAT
The manual is included in the training price.
Training syllabus Access, Database Data Processing
Getting Familiar with the Relational Database Model in Access
Working with a Table in MS Access
- new, data types, data entry, table editing, inserting and deleting data, sorting records, filtering records
Creating Relationships Between Tables
- relationship settings and properties, types of joins, primary and foreign key
Working with Query Creation Wizards
- query design, working with queries, filter criteria, grouping, working with query creation wizards, query design, working with queries, filter criteria, grouping, basic functions for working with strings, numbers, date and time
Use and Modification of Join Types in a Query
- LEFT, RIGHT and INNER JOIN
Queries
- make-table queries, delete queries, update queries, append queries
Processing and Evaluating Data
- in pivot table and pivot chart view basic functions for working with strings, numbers, date and time
SQL Language Commands
- SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY
Aggregate Functions
- MIN, MAX, AVG, SUM, etc., composing a WHERE condition - AND and OR operators, LIKE operator
Importing Data into a Table
- linking, exporting data from a table (TXT, Excel, HTML, Access...) discussion
Output knowledge
Mastering the issues of importing, editing, evaluating and subsequently exporting data in Access.
Show all courses from category Vypnuté kurzy
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Access, Database Data Processing
Average rating