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 relationships 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)
Prepared examples and techniques that I did not know
Magdalena - LKQ Polska Sp. z o. o.
Course - Advanced MS PowerPoint
Machine Translated
Showing examples, pictorial way of translating
Aneta - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
The instructor's interaction with the participants, knowledge, openness to discussion and ideas.
Paweł - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
practical examples
weronika josiek - Denso
Course - Advanced MS PowerPoint
Machine Translated
exhaustion of topics
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
Machine Translated
The pace of classes is perfect, not too fast, not too slow, lots of examples and exercises. Each participant could freely perform the exercises without any pressure to answer questions. Everyone could act in their own time, and in case of a failed attempt, you could catch up when the trainer showed the solution.
Anna - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
Machine Translated
I really was benefit from the real life practical examples.