Intermediate Microsoft Access 2013 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 2013.
Facilities
Location
Start date
Start date
About this course
On completion of the course delegates will have improved their skills in using Microsoft Access 2013. 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
- Form Design
- Microsoft Access
- Query Design
- Table Relationships
- Table design
- Displaying
- Report Design
- Option groups<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, etc, documents into an Access 2013 database
•Exporting data in Excel, txt, etc. formats
•Linking external data to an Access 2013 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 2013 Training Courses