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.
Testimonials
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
The own working, it helps a lot I think.
Krisztina BALOGH, Diehl
The trainer let us ask regarding our issues with our current projects. He explained really well what kind of approach we should choose.
Krisztina BALOGH, Diehl
perfect level of knowledge transfair
Pascal - Krisztina BALOGH, Diehl
I learned a lot of new things which will be useful for my tasks.
Zsolt - Krisztina BALOGH, Diehl
The trainings by our self
Andreas - Krisztina BALOGH, Diehl
I liked that all the neccessary topics have been explored.
Krisztina BALOGH, Diehl
Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.
Iwona - Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
complex introduction to queries, relationships. Useful tips in term of further using of Access as well as Access connection with different tools
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
Trainer has very broad knowledge, not only related to access. Impressive :)
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
starting from scratch and go further and further.
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
Kamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.
Christine Weiler
The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions
Daria Rudin
examples and the way he explained