Voir toutes les formations AFFIX FORMATION
- Durée : N.C.
- Type : En centre
- Diplôme : Autre
- Prix : 600.00 €
Objectifs
provide students with an overview of MS Access queries
Plus d'infos sur le site de l'organisme
- Programme :
- 1. 1. Designing a database
- 1. Identifying the tables
- 2. What are relationships?
- 3. Setting a primary key
2. 2. Creating tables
- 1. Defining fields
- 2. Types of field
- 3. Entering data
3. 3. Drawing relationships
- 1. Creating relationships
- 2. Referential integrity
4. 4. Importing data
- 1. Importing from Excel
- 2. Linking to Excel spreadsheets
- 3. Problems with importing
5. 5. Creating queries
- 1. The query design grid
- 2. Sorting
- 3. Setting criteria
- 4. Combining criteria
6. 6. Advanced queries
- 1. Grouping and totalling
- 2. Creating expressions
- 3. Parameter queries
7. 7. Joins
- 1. Creating ad hoc joins
- 2. Types of join
8. 8. Creating forms
- 1. Using the form wizard
- 2. Using forms to enter data
- 3. Form design
- 4. Creating controls
9. 9. Creating reports
- 1. Using the report wizard
- 2. Using print preview
- 3. Report design
- Session(s):
-
| Date(s): |
Lieu(x): |
|
Du 10/04/2008 au 10/04/2008 |
(75) Paris |
|
Du 15/05/2008 au 15/05/2008 |
(75) Paris |
|
Du 05/06/2008 au 05/06/2008 |
(75) Paris |
|
Du 04/07/2008 au 04/07/2008 |
(75) Paris |
|
Du 07/08/2008 au 07/08/2008 |
(75) Paris |
|
Du 04/09/2008 au 04/09/2008 |
(75) Paris |
|
Du 09/10/2008 au 09/10/2008 |
(75) Paris |
|
Du 06/11/2008 au 06/11/2008 |
(75) Paris |
|
Du 10/11/2008 au 10/11/2008 |
() |
|
Du 04/12/2008 au 04/12/2008 |
(75) Paris |
|
Du 08/12/2008 au 08/12/2008 |
() |
Plus d'infos sur le site de l'organisme
Transférer à un ami
Kelformation vous conseille
