Briefly about the course Microsoft Access

  • 20 hours (30 academic hours)
  • 10 days
  • Start training - as agreed
  • Education in your office or on Skype
  • Cost - from 5800 Kč per person

Enroll in a course!

Information about the computer course Microsoft Access

Computer course is designed for students with elementary theoretical and practical skills of work on the personal computer as user. Applicant must be able to work on the keyboard and to know the file system (disks, folders and files).

The Database Management System (DBMS) of the Microsoft Access, which has appeared in 1992, quickly won popularity among users of programs of office direction. Microsoft Access DBMS allows increasing labor productivity by operation with large volume of tabular data and helps to make more successful business decisions in business. For dataful operation and the friendly interface difficult databases even to nonprofessionals allow to create a big set of new convenient tools quickly.

Microsoft Access 2010/2013 by operation with large volume of tabular data and helps to make more successful business decisions in business. For dataful operation and the friendly interface difficult databases even to nonprofessionals allow to create a big set of new convenient tools quickly.

Tight integration with other Microsoft Office allows you to easily share data, in particular with Microsoft Word, Microsoft Excel, Microsoft PowerPoint, as well as with those of other types.

Microsoft Access can be used to create a user interface, as well as for the preparation of printed documents - reports, stickers, charts.

The course DBMS Microsoft Access does not cover programming in Visual Basic for Applications, and is considered simple tool automation - macros.

The course DBMS Microsoft Access based on concrete examples and solutions, many of which you will be able to successfully use in their future practice.

DBMS Microsoft Access can be seen as preparation for passing the test certified Microsoft Certified Application Specialist, which is a world standard test to assess the skills of the user experience with business applications Microsoft Office.

Instructor: Marina Tkachenko

 

Our advantages:

  • Individual training
  • The possibility of learning in your office
  • Convenient time employment
  • The course optimized for your tasks
  • Certified teachers
  • Free advice on the best bunch of programs to achieve maximum effect from training
  • Certificate of training center of CGClass

Cost of training

On Skype

Individually in your office

Corporate Training
in your office (per person)

6200 Kč

7500 Kč

2–10 persons — 6400 Kč
over 10 persons — 5800 Kč

The program of the computer course MS Access

Class

Introduction in the database theory.
General information about databases. Differenses between Access DBMS and the electronic spreadsheets Excel. Steps of database design. Data models, relational data model.
Relational Database.
Design of relational database. Relational database MS Access.

Class

DBMS MS Access.
General information about Microsoft Access DBMS 2010/2013. Structure of a window, menu, shortcut menus, toolbars and properties of a database. Database creation. Templates of databases. Objects in Access DBMS. 
Tables. Methods of creation of tables. Datasheet view. Design view: structure of a window, menu and toolbar. Data types, properties of fields.

Class

Table design.
Tool for tables. Lookup, input mask. Data entry in tables. Change of appearance of tables. Operations with tables.
Import and export of data by operation with tables. Import and export of data, communication with Microsoft Office. External binding – dataful link establishment from other sources (OLE objects, text files, spreadsheets MS Excel).

Class

Change of structure of the table and available operations with data.
Change of appearance of tables. Sorting, search and data filtering. Structure of a window of the table, subdatasheet. Creation of junction tables. Table properties.
Organization of relationships. Relationships, 3 types of relationships. Enforce referntial integrity, the cascading update and delete. Join types.

Class

Database queries.
Types of queries. Methods of creation of queries. Queries views. Design view: structure of a window, menu and toolbar.
Select queries (one-table and multi-table, with use of a design view and Query Wizard). Criteria in queries. Special operators.
Additional opportunities of queries.
Queries with parameters. Crosstab queries. Creation of expressions with Expression builder. Group operations, statistical functions and their use.

Class

Change queries.
Creation of Append queries, Update queries, Delete queries, Make table queries.
SQL language bases. SQL statement. Select clause. Operators, keywords. Examples.

Class

Forms.
Forms design. Types of forms. Tools for creation of forms. Design view: structure of a window, menu and toolbar. Panel of controls. Review of controls.
Operation with forms. Design of the form and its elements.
Operation with the form in the Form View (sorting, filtering, search of records). Creation of forms with the Wizard. Creation of buttons with the Wizard. Placement of controls on the form. Change of background color of the form and its elements. Change of a background figure of the form.

Class

Use of objects on forms.
Properties of the form and controls. Events and their processing. Creation of modal dialog forms.
Reports. Report design. Report Wizard. Design view: structure of a window, menu and toolbar. Operation with reports. Report structure. Sorting and grouping of data. Additional opportunities of reports: calculation in reports, printing, report pictures, mail stickers.

Class

Macros.
What are the macros? Macro Builder. Review of macro commands. Arguments of macro commands. Start of macros. Embedded macros. Examples of macros.
Setup of database options. Service programs. Start parameters. Setup of the user toolbars and menu.

Class

Preparation for examination.
Responses to questions.
Examination.

On computer courses Microsoft Access, we can offer you a personalized itinerary and corporate training.

We are waiting for you on the Microsoft Access courses in Prague!