Category
ICT
Course Type
Microsoft
Price Per Delegate
£495 +VAT
Public Scheduled Course
Price Per Course
£1,395 +VAT
On-Site at Customer Premises, Max 10 Delegates
Duration
2 Days
Full/Part Time
Part Time
Provider
Book courseThis course is intended 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.
Objectives: By the end of the course the user will be able to develop databases which include automated features such as macros and command buttons and utilise complex queries, forms and reports using grouping tools and including calculations.
Prerequisites: 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.
- Understanding Normalisation
- Relationship Join Types
- Changing the Join Type in a Query
- Find Unmatched Queries
- Find Duplicates Query
- Crosstab Queries
- Multiple Table Reporting
- Sorting & Grouping Report Data
- Performing Calculations on Reports
- Creating Custom Report Pages
- Bound & Unbound Controls
- Creating a Calculated Control
- Toggle Buttons, Options & Check Boxes
- Option Groups
- List Boxes and Combo Boxes
- Page Tabs
- Forms & Reports using the Chart Wizard
- Creating a Global Chart
- Creating a Record Bound Chart
- Formatting Charts
- Using PivotChart View
- Creating a Macro
- Running a Macro
- Macro Examples
- AutoExec Macros
- Designing & Creating Navigation Forms
- Designing Application Menus
- Startup Options & Defaults
- Storing Databases on a Network
- Shared Databases
- Setting Database Passwords
- Backing Up a Database
- Compacting & Repairing a Database
- Front End & Back End Databases
- Database Documenter
Enquire about a course
Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.
