Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
14 Hours
Testimonials (2)
IF ANYBODY HAD A PROBLEM, TRAINER ALWAYS HELPED.
ANNA JAGIEŁKA
Course - Access Basics
The training started for the early beginners, so everybody could get to know what all is about.