Course Access Basics
The Access Basics course is intended for all interested participants who want to become familiar with a database program, learn about its functional possibilities and create their own database.
Minimum input knowledge
Standard ability to work with a computer.
Course dates Access Basics
Course price: 250.00 / 307.50 EUR
without VAT / incl. VAT
Training syllabus Access Basics
Characteristics and Use of Access
- Getting familiar with the relational database model.
- Basic description of the program working environment (tables, queries, forms, print reports, pages, macros, modules).
Working with a Table in Microsoft Access
- New table, data types, data entry, editing a table.
- Inserting and deleting data.
- Sorting records.
- Filtering records.
Relationships Between Tables
- Relationship settings and properties.
- Types of relationships.
- Primary and foreign key.
Working with Query Creation Wizards
- Query design.
- Working with queries.
- Filter criteria.
- Grouping.
- Working with query creation wizards.
- Query design.
- Working with queries.
- Filter criteria.
- Grouping.
- Basic functions for working with strings, numbers, date and time.
Use and Modification of Join Types in a Query
- LEFT, RIGHT and INNER JOIN.
Working with Queries
- Make-table queries.
- Delete queries.
- Update queries.
- Append queries.
- Processing and evaluating data in PivotTable and PivotChart view.
- Use of functions.
Forms
- Working with a form.
- Using forms.
- Form design.
- Form properties.
- Basic form controls and their properties.
- Using a wizard.
Reports
- Report templates.
- Report controls.
- Using sections and page breaks.
- Using expressions in reports.
- Sorting and grouping.
- Group header and footer.
Working with Help
- Discussion.
Output knowledge
Mastering operation of Microsoft Access, gaining skills in defining and creating one's own database, as well as in evaluating database data.
Show all courses from category Vypnuté kurzy
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Access Basics
Average rating