Course code: MSAC107« Back

Microsoft Access 2007 – Basic Course

This course is assigned 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 simple applications.

This course is recommended to prepare for the ECDL certification Preparatory course for MOS certification This course has been removed from our portfolio
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department (__Klientskyservis@gopas.cz) or business department (__Obchod@gopas.cz).

AffiliateDurationCatalogue priceHandbook priceITB
Praha5 16 500 CZK included in course price 0
Brno5 15 500 CZK included in course price 0
Bratislava5 550,00 EUR included in course price 0

Who is the course for

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

What we teach you

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

Required skills

Basics of work with computer and Microsoft Windows system.

Teaching methods

Professional explanation with practical samples and examples.

Teaching materials

Gopas company course handbook, according to the course curriculum.

Course Outline

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

Pivot tables and Pivot charts

Database administration

Export and import

Innovations of Access version 2007

Příručka MS Access 2007 - základní kurzu [Cz/Cz]

Price:
included in course price
Příručka MS Access 2007 - základní kurz[Cz/En]

Price:
included in course price
The prices are without VAT.