Access Intermediate
Corso
Online
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Metodologia
Online
-
Inizio
Scegli data
The course participants will learn the terminology of relational databases, acquire the skills to design database applications, know the basic principles of creating forms and reports.
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Profilo del corso
Knowledge of Microsoft Windows OS.
Basic knowledge of Microsoft Access database or other.
Opinioni
Programma
Microsoft Access
- Adapting the Access environment
- Microsoft Accessobjects
- Working with ribbon
- fields and records
- keys
- relationships
- normalization
- referential integrity
- type and size of fields selection
- indexes
- data validation
- required fields
- input mask
- quickparts
- calculated fields
- creating simple forms
- navigation in form
- switching between views of forms
- adding, editing and deleting records
- validation and undoing changes in the record
- sorting, filtering, and a search box
- combo box on a form
- importing data from other databases
- importing text files (CSV)
- importing Excel spreadsheets
- joining tables from other databases
- creating mail to collect information
- answers management
- select queries
- action queries review
- creating reports
- creating buttons for activating forms, reports, queries
- creating starting form
- separating data from applications
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Access Intermediate