Intermediate Microsoft Access 2010 Training Courses
Short course
In Twickenham
Description
-
Type
Short course
-
Location
Twickenham
-
Duration
1 Day
-
Start date
Different dates available
This course aims to give delegates a greater understanding of MS Access 2010.
Facilities
Location
Start date
Start date
About this course
On completion of the course delegates will have improved their skills in using Microsoft Access 2010. They will be able to:
Use field properties for protection
Understand table relationships and referential integrity
Create multi-table queries
Use calculations in a query
Design custom entry forms
Design custom reports
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 14 years
Subjects
- Access
- Design
- Database training
- Database
- Report Design
- Form Design
- Microsoft Access
- Query Design
- Table Relationships
- Fields
- Hyperlink
- Currency
- Editing
- Multiple values<br /> <br /> <br /> <br />
Course programme
The Navigation pane, customising the Navigation pane
Database display
Table design - fields
Applying and modifying data types such as text, memo, hyperlink, currency, date and time in a field
Understanding the consequences of modifying data types such as text, memo, hyperlink, currency, date and time in a field
Creating and editing a lookup in a field
Creating and editing a validation rule in a field
Creating and editing an input mask in a field
Applying and modifying default values in a field
Setting a mandatory field
Fields with multiple values
Table Relationships
Understanding the basis for creating a valid relationship
Creating a one-to-one or a one-to-may relationship between tables
Understanding and modifying a many-to-many relationship between tables
Applying inner, outer and self joins
Applying and using referential integrity
Applying automatic deletion of related records
Relating or joining data when designing records
Adding fields to tables
Field templates
Microsoft Access Query design
Grouping information in a query
Using a crosstab query
Using wildcards in a query
Using arithmetic and logical expressions in a query
Form design
Using bound and unbound controls
Creating and editing a combo box, list box, check box and option groups
Inserting a data field to appear within form header or footer on the first page or all pages
Stacked and tabular layout controls
Report design
Inserting a data field to appear within report header or on footers on the first page or all pages
Forcing page breaks for groups on reports
Importing, exporting and linking data
Importing text, Excel, csv, dBASE or Paradox documents into an Access 2010 database
Exporting data in Excel, txt, dBASE and Paradox formats
Linking external data to an Access 2010 database
Additional information
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT
Intermediate Microsoft Access 2010 Training Courses