Access 2010 Developers
Categories: Microsoft Access
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Access 2010 Developers 

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

 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration3 days
 
£695
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).