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 (5)
The situation was atypical because an intensive training for developers was to be conducted with non-developers. Lukasz took up this challenge with empathy and a lot of humour. Through his intelligent and flexible manner, he was able to ensure that a concrete learning gain was achieved for everyone. I enjoyed this very much and would gladly take a seminar with Lukasz again.
Christoph - Honda Bank GmbH
Course - MERN Fullstack Development
perfect level of knowledge transfair
Pascal - Diehl
Course - Access Advanced
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 - Universal-Investment-Gesellschaft mit beschränkter Haftung
Course - Access Intermediate
Los ejemplos claros que presentó el instructor
José Ernesto Cruz Pineda - Datavision digital
Course - SAP ASE for Database Administrators
Training Room and quite location and all the stuff.