This 4-hours course discuss how to work with database.
The topics of this 4-hours instructor-led course include:
- Theory of relational databases
- Table formatting
- Data search and replacement and tables and forms.
- Display of information in proper order by application of sorting and filtering.
- Data input and editing.
- Creating of selecting queries using wizard.
- Modification of queries in design view using data selecting and sorting.
- Creating of forms and reports automatically or using wizard.
- Printing.
- Creating of a database on basis of a template using wizard.
This 12-hours course discuss how to design and build your own database.
The topics of this 12-hours instructor-led course include:
- Creating tables using wizard and in design view
- Data types and field properties
- Data formatting
- Input mask
- Import and linking tables
- Creating of queries of different types
- Creating of forms
- Protecting data in forms
- Creating multitable forms
- Creating and editing reports
- Creating macros
- Creating switchboard forms
- Startup parametres tuning
|
EC “Networking Technologies”™ started to deliver trainings in 1997. Since then several thousands of leading Ukrainian and international companies' members have been trained. Among these companies are Procter&Gamble Ukraine, TetraPak Ukraine, Metro Cash&Carry, Gillette Ukraine and others.
All trainings can be delivered in three languages: Russian, Ukrainian and English.
The training plan is adapted to the requirements of the international certification program MOS (Microsoft Office Specialist).
All trainings are delivered by the certified MOS trainers.
Microsoft Office Word
Microsoft Office Excel
Microsoft Office PowerPoint
Microsoft Office Outlook
Microsoft Office Access
Microsoft Office Project
Internet Explorer
|
