Microsoft Access 2016/2013 – Basic Course

This course is designed for users, who need to create relational databases in Microsoft Access, fill in data, analyse and execute it and create simple applications. You learn how to create simple relational databases, work with them and create [...]

MSAC1
Duration 5 days
0 ITK points
11 terms
Praha (16 500 Kč)

Brno (16 500 Kč)

Bratislava (700 €)
Intermediate

This course is suitable for users of every version of Microsoft Office products. Excel is a well-matured application and control of its interface has not changed significantly since the 2007 version. There will be 3 latest Excel versions installed in each classroom in case the users would like to work with the version they are accustomed to. The student‘s books of appropriate versions will also be available.

This course is assigned for users, who have never worked with Access database.

You learn how to create simple relational databases, work with them and create simple applications.

Basics of work with computer and Microsoft Windows system.

Introduction to relational databases

Viewing datasheet

User operations

Design view

Setting of properties of items

Filters

By selection, by form
Elementary syntax of expressions

Relations between tables

Setting properties of relations

Queries

Counted fields
Counting totals
Parametrical queries
Crosstab query
Action queries

Forms

Form sections
Editing source query or table
Form properties
Controls and its properties
Expressions in forms
Using charts, pictures and other objects

Reports

Templates of reports
Reports and controls
Using sections and page breaks
Using expressions in reports
Sorting and grouping, header and footer of group

Microsoft Access 2016/2013 – Basic Course

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details

Microsoft Access 2016/2013 – Basic Course

Previous courses

Next courses

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details