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 (10)
Organizacja i praktyczne podejście do tematy
Adam Cedrowicz - Unilever Poland Services sp. z o.o
Course - Access - podstawy
Wiedza wykładowcy, atmosfera
Patrycja Kosa - Martyna Mazurek-Sitarz
Course - Access - podstawy
indywidualne podejście do każdego uczestnika oraz chęć rozwiązania każdego problemu jaki pojawiał się w trakcie wykonywanych zadań
Judyta Kozłowska
Course - Access - podstawy
IF ANYBODY HAD A PROBLEM, TRAINER ALWAYS HELPED.
ANNA JAGIEŁKA
Course - Access Basics
przez cały czas trener dbał o to, żeby nikt się gubił i wszyscy byli na bieżąco
Anna Krupa
Course - Access - podstawy
Tempo szkolenia, struktura
Katarzyna Kempińska
Course - Access - podstawy
Tempo i poziom szkolenia dostosowane do uczestników, pomoc w przypadku problemów, szczegółowe odpowiedzi na wszytskie pytania.
Aneta Ługowska
Course - Access - podstawy
Dostosowanie szkolenia do moich potrzeb
Paulina Jeziorska
Course - Access - podstawy
Kontakt trenera z uczestnikami i umiejętność wytłumaczenia nawet skomplikowanych zagadnień.
Paweł Malerz
Course - Access - podstawy
The training started for the early beginners, so everybody could get to know what all is about.