Access 2010 Developers training course (3 days)
Have you got to create a new Access database, or make changes to an existing one? This is the course for you! Beginning with the oh-so-important principles of database design, the course explains step by step how to create a database, create queries, design forms and reports and write the Visual Basic code that you need to link all of this together. Note that it takes a long time to learn Access, so this course should be seen as a first step - it will save you weeks of learning time, but there is still no substitute for experience.
Access 2010 Developers training - Course Contents
The contents of our Access 2010 Developers course are as follows (any items marked with a * will be covered if time allows):
Designing a database
- Identifying the tables
- What are relationships?
- Setting a primary key
- Using multivalue fields
Creating tables
- Defining fields
- The types of field
- Entering data
Different field types
- Creating attachments
- Rich text format fields
- Date fields (using calendars)
- Calculated fields
Importing data
- Importing from Excel
- Making tables from Excel
Table rules (*)
- Record-level validation
- Basic triggers
Drawing relationships
- Creating relationships
- Referential integrity
Creating queries
- The query design grid
- Sorting
- Setting criteria
- Combining criteria
Advanced queries
- Grouping and totalling
- Creating expressions
- Parameter queries
Joins
- Creating ad hoc joins
- Types of join
|
Crosstab queries (*)
- Columns, rows and values
- Overriding column headings
Action queries (*)
- Making tables
- Updating records
- Appending records
- Deleting records
Creating forms
- Layout and design view
- Using the form wizard
- Split forms
- Creating controls
Advanced controls (*)
- Webbrowser controls
- Navigation bars
- Multitabs
Creating reports
- Using the report wizard
- The group, sort and total pane
- Report design
Creating subforms
- Multiple item forms
- Creating subforms
- Tidying up subforms
Basic VBA coding
- Creating modules
- Using Project Explorer
- Writing comments
- Indenting code
Uses of VBA
- Form validation
- Criteria forms
- A simple menu system
|
Click on any link above to show free exercises for the topic in question. You do not need to have used Access before to attend this course, although you should be a confident computer user. There will be a maximum of 6 people on each course, and each person will have their own computer.
