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
Database Fundamentals
- Analysis of the current system
- Define database items
- Normalization
- Relations between the elements
- Naming standards
- Create a database
- Methods for creating arrays (Design View, Wizard, Inputting Data)
- Data types
- Field properties
Records and operations records
- Adding and editing a record
- setting the record
- Search record
- Copying tables
Create a relational database
- Keys
- Relations tables
- Dependencies
Queries
- Create queries
- Using the Query Wizard
- Operations on the results of the query
- criteria query
- Calculations and operators in queries
Forms and controls
- Types of controls
- Using AutoForm
- Using the wizard forms (Form Wizard)
- Properties of controls and forms
- Printing forms.
- Create a subform (Subform)
- Headers and footers
Reports
- Create reports.
- Using AutoReport
- Using the Report Wizard (Report Wizard)
- Sections
- Properties reports
Additional tools for forms and reports
- AutoFormat
- Special Effects
- Open a form at runtime database
- Adding graphics, spell check
- Switchboards
Exporting, importing and linking data
Security
- Passwords
- Database encryption
- Security Wizard
Backups
Requirements
Knowledge of Windows.
21 Hours
Testimonials (4)
Practical exercises with a trainer
Zuzanna Szczesniewska - Narodowy Fundusz Zdrowia
Course - Access - Data Base Designing
Machine Translated
Clear and understandable way of presenting content.
Ewa Potocka - Narodowy Fundusz Zdrowia
Course - Access - Data Base Designing
Machine Translated
I liked the way the training was conducted the most. It was not too fast, allowing everyone to take notes and learn everything.
Agnieszka Grzywa
Course - Access - projektowanie baz danych
Machine Translated
Commitment of the instructor
Sylwia Zokowska
Course - Access - projektowanie baz danych
Machine Translated
