Microsoft Access 2010 Advanced
SmartStyle
Duration: 2 Days
£250
(Exc VAT per delegate on a public scheduled course)
Detailed information
| Type: | Training |
|---|---|
| Method: | In a classroom |
| Accreditation: | N/A |
| Prepares for: | Users who need to develop databases which have complex structures or require an easy to use interface for a team or organisation to use. |
| Geared towards: | Practical work based skills in Microsoft Access |
| Requirements: | Users must be able to confidently design and develop multiple table Access databases. Users will require a good understanding of relationships and the four core elements of Microsoft Access, i.e. tables, queries, forms and reports. |
| Internship: | N/A |
| Students per class: | 10 |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Normalisation & Relationships
Understanding Normalisation
Relationship Join Types
Advanced Query Features
Changing the Join Type in a Query
Find Unmatched Queries
Find Duplicates Query
Crosstab Queries
Advanced Report Features
Multiple Table Reporting
Sorting & Grouping Report Data
Performing Calculations on Reports
Creating Custom Report Pages
Advanced Form Features
Bound & Unbound Controls
Creating a Calculated Control
Toggle Buttons, Options & Check Boxes
Option Groups
List Boxes and Combo Boxes
Page Tabs
Creating & Modifying Charts
Forms & Reports using the Chart Wizard
Creating a Global Chart
Creating a Record Bound Chart
Formatting Charts
Using PivotChart View
Macros & Database Automation
Creating a Macro
Running a Macro
Macro Examples
AutoExec Macros
Designing & Creating Navigation Forms
Designing Application Menus
Startup Options & Defaults
Multi User Databases
Storing Databases on a Network
Shared Databases
Setting Database Passwords
Database Management Tools
Backing Up a Database
Compacting & Repairing A Database
Front End & Back End Databases
Database Documenter
Understanding Normalisation
Relationship Join Types
Advanced Query Features
Changing the Join Type in a Query
Find Unmatched Queries
Find Duplicates Query
Crosstab Queries
Advanced Report Features
Multiple Table Reporting
Sorting & Grouping Report Data
Performing Calculations on Reports
Creating Custom Report Pages
Advanced Form Features
Bound & Unbound Controls
Creating a Calculated Control
Toggle Buttons, Options & Check Boxes
Option Groups
List Boxes and Combo Boxes
Page Tabs
Creating & Modifying Charts
Forms & Reports using the Chart Wizard
Creating a Global Chart
Creating a Record Bound Chart
Formatting Charts
Using PivotChart View
Macros & Database Automation
Creating a Macro
Running a Macro
Macro Examples
AutoExec Macros
Designing & Creating Navigation Forms
Designing Application Menus
Startup Options & Defaults
Multi User Databases
Storing Databases on a Network
Shared Databases
Setting Database Passwords
Database Management Tools
Backing Up a Database
Compacting & Repairing A Database
Front End & Back End Databases
Database Documenter
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- 2nd Floor Orleans House, Edmund Street - L3 9NGCity and Borough of Liverpool (England)
SmartStyle
Recognised as one of the UK’s leading providers in the field of learning and development, SmartStyle ensure that organisations get the most from their people, their technology and their investment in both.
Delivering bespoke and “off-the-shelf” IT, business skills and professional development training, SmartStyle provide organisations across all sectors, a one stop solution for their learning and development needs, from our centres in Bradford and Liverpool.
Working in partnership with our clients, we identify real needs, aligned with organisational objectives and match innovative learning interventions to those needs - getting the right skills to the right people and delivering maximum return on investment.
Delivering bespoke and “off-the-shelf” IT, business skills and professional development training, SmartStyle provide organisations across all sectors, a one stop solution for their learning and development needs, from our centres in Bradford and Liverpool.
Working in partnership with our clients, we identify real needs, aligned with organisational objectives and match innovative learning interventions to those needs - getting the right skills to the right people and delivering maximum return on investment.
