Course Outline
1. Introduction:
- What are relational databases
- When and why you should consider using them
- Why Access is such an attractive database
2. Support for existing databases Accessa:
- Discussion of basic concepts related to databases
- Opening and closing the database
- Basic database objects and dependencies between them (tables, queries, forms and reports)
- Operations on records (adding, deleting, modifying)
- Record searching, sorting and filtering
- Support for existing forms
- Compacting and repairing the database
3. Tables:
- Designing new tables
- Types of fields and criteria for their selection
- The role of the primary key
- Modification of the structure of tables containing data
- Data import to and from Excela
4. Relationships:
- Links as a way of creating relationships
- Create relationships in the Relationships window
- Relationships: one-to-one, one-to-many, many-to-many
- Defining referential integrity
5. Queries
- Creating queries using the wizard
- Creating queries in Design view
- Creating queries based on one table and many tables connected by relationships
- Types of couplings and their role
- Data grouping and query calculations
- Different types of queries (select, append, create tables, update, delete, crosstab)
- A few words about the syntax and meaning of the language SQL
- Formatting the results
- Query parameters
- Setting properties and formatting query results
- Creating complex queries
- Presentation of potential problems and ways to avoid mistakes
6. Cooperation between Exceland Accessem
- Exporting, importing and combining data
- Creating reports in Excelu based on data from Accessa
7. Forms and reports
- Creating simple forms and reports using wizards
8. Work automation
- Introduction to creating macros
Testimonials (7)
Organization and a Practical Approach to the Topic
Adam Cedrowicz - Unilever Poland Services sp. z o.o
Course - Access - podstawy
Machine Translated
Expertise of the lecturer, atmosphere
Patrycja Kosa - Martyna Mazurek-Sitarz
Course - Access - podstawy
Machine Translated
individual approach to each participant and willingness to address every problem that arose during the tasks performed
Judyta Kozlowska
Course - Access - podstawy
Machine Translated
IF ANYBODY HAD A PROBLEM, TRAINER ALWAYS HELPED.
ANNA JAGIELKA
Course - Access Basics
throughout the training, the trainer ensured that no one got lost and that everyone stayed up-to-date
Anna Krupa
Course - Access - podstawy
Machine Translated
Tempo of the training, structure
Katarzyna Kempinska
Course - Access - podstawy
Machine Translated
Pace and level of training tailored to participants, assistance in case of problems, detailed answers to all questions.
Aneta Lugowska
Course - Access - podstawy
Machine Translated