Course Outline
1. Introduction:
- What are relational databases
- When and why to consider using them
- Why Access is such an attractive database
2. Managing Existing Access Databases:
- Discussing basic database concepts
- Opening and closing a database
- Basic database objects and their dependencies (tables, queries, forms, and reports)
- Record operations (adding, deleting, modifying)
- Searching, sorting, and filtering records
- Managing existing forms
- Compacting and repairing the database
3. Tables:
- Designing new tables
- Field types and their selection criteria
- The role of the primary key
- Modifying the structure of tables containing data
- Importing data to and from Excel
4. Relationships:
- References as a way to create relationships
- Creating relationships in the relationship window
- Relationships: one-to-one, one-to-many, many-to-many
- Defining integrity constraints
5. Queries
- Creating queries using the wizard
- Creating queries in design view
- Creating queries based on a single table and multiple tables connected by relationships
- Types of joins and their role
- Grouping data and calculations in queries
- Different types of queries (select, append, make table, update, delete, crosstab)
- A few words about the syntax and meaning of SQL language
- Formatting results
- Query parameters
- Setting properties and formatting query results
- Creating complex queries
- Presentation of potential issues and ways to avoid errors
6. Collaboration of Excel with Access
- Exporting, importing, and linking data
- Creating reports in Excel based on data from Access
7. Forms and Reports
- Creating simple forms and reports using wizards
8. Work Automation
- Introduction to macro creation
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