|
|
|
MSAC107 - 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.
Who the course is forThis course is assigned for users, who have never
worked with Access database.
What we teach youYou learn how to create simple relational databases,
work with them and create simple applications.
Required skillsBasics of work with computer and Microsoft Windows
system.
Teaching methodsProfessional explanation with practical samples and
examples.
Teaching materialsGopas company course handbook, according to the
course curriculum.
Course syllabus
Introduction to relational databases
Viewing datasheet
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
Recommended prior courses
PCWI - PC and Windows – For Beginners
NRD - Designing Relational Databases
Recommended subsequent courses
MSACPT - Microsoft Access 2007 – Advanced Techniques
MSAC2a - Microsoft Access – Application Development
Catalog price of course and handbook
| Praha |
14500 Kč
|
--
|
0 items
|
| Brno |
13500 Kč
|
--
|
0 items
|
Course dates
|
