Formation : Introduction to MS Access
Se former avec
AFFIX FORMATION
- Renseignements :
- Durée : 3 Jours
- Type : En centre
- Diplômant : Oui
-
Prix H.T. € :1800.00
- Objectifs :
- provide students with an overview of MS Access querie
- 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. Action queries
- 1. Making tables
- 2. Updating records
- 3. Appending records
- 4. Deleting records
9. 9. Crosstab queries
- 1. Columns, rows and values
- 2. Overriding column headings
10. 10.SQL Queries
- 1. Union queries
- 2. Passthrough
11. 11.Creating forms
- 1. Using the form wizard
- 2. Using forms to enter data
- 3. Form design
- 4. Creating controls
12. 12.Creating subforms
- 1. Creating tabular forms
- 2. Merging forms and subforms
- 3. Tidying up subforms
13. 13.Creating reports
- 1. Using the report wizard
- 2. Using print preview
- 3. Report design
14. 14.Basic VBA macros
- 1. Creating macros
- 2. Using Project Explorer
- 3. Writing comments
- 4. Indenting code
15. 15.Uses of macros
- 1. Form validation
- 2. Criteria forms
- 3. A simple menu system
16. 16.The VBA code editor
- 1. Two ways to create modules
- 2. Using Project Explorer
- 3. Basic subroutines and comments
15/12/2008 au 17/12/2008 ()
01/07/2008 au 2009 (75)
17/11/2008 au 19/11/2008 ()
02/06/2008 au 2009 (75)
01/12/2008 au 2009 (75)
12/05/2008 au 2009 (75)
03/11/2008 au 2009 (75)
07/04/2008 au 2009 (75)
06/10/2008 au 2009 (75)
01/09/2008 au 2009 (75)
04/08/2008 au 2009 (75)
