Overview

Microsoft Access is a desktop database programme that helps users store, manipulate and query data, perform calculations and produce reports. Advanced Tables • Good table design techniques Advanced Queries • Advanced query properties • Using advanced functions in criteria expressions and calculated fields • Joining tables and queries Advanced Form Controls • Designing Dialog Boxes and Switchboards Enhancing Reports • Modifying Advanced Design Properties Introduction To Macros • Creating Macros • Assigning Macros to Events • Conditional Macros • Macro Groups • Troubleshooting Macros Importing, Exporting And Linking Data • Linking to tables in other databases via ODBC Customising Applications • Creating Custom Toolbars and Menus • Designing Switchboard Forms • Setting Startup Options MDEs • Introduction to MDEs • Creating and Managing MDEs Security • Setting Database Passwords • Using the Security Wizard • Creating Users and Groups • Setting Permissions • Using Workgroup Information Files • Encrypting Databases Database Replication • Replicating A Database • Creating Additional Replicas • Synchronising Replicas • Resolving Replication Conflicts Database Utilities • Analysing Database Performance • Documenting Object Properties Database Design • Good database design • Naming conventions

Who is it for?

Delegates should be experienced in using both Windows and Access, and should have attended the Access Intermediate course or have the equivalent experience. They should also be familiar with the concepts of relational databases, methods for designing tables, querying data, and using forms and reports for data input and output.

What will i learn?

This two-day course, which builds on the Access Intermediate course, will enable delegates to enhance the presentation and analysis of data, create advanced queries, automate database operations; and secure the database.

How will i be assessed?

On completion of the course delegates will be given a certificate of attendance.

Address

First Stop Training Limited The Lansdowne Building 2 Lansdowne Road Croydon Surrey CR9 2ER T - 0844 561 1070 F - 0844 561 1061

Travel Information

By Road: FROM CENTRAL LONDON • Take the A23 south to Croydon. • Turn left into Epsom Road which leads into Duppas Hill Road (A232). • Follow the A232 over the Croydon flyover and turn left at the first roundabout onto Park Lane. • Stay in the right hand lane and go through the Croydon Underpass. • Continue past the Whitgift Center (on your left) in the right hand lane until you reach a set of traffic lights which allow you to turn right(near the large silver BT Building) • Turn right to double back onto the adjacent carriage way (Wellesley Road) in the opposite direction. • Stay in the left hand lane and take the first turning on the left, (signposted to Dingwall Road). • At the end of Sydenham Road turn right into Dingwall Road and continue to the roundabout. • Turn right (3rd exit) into Lansdowne Road. • The Lansdowne Building is located approximately 500 yards on the left opposite the Fairfield Hotel. FROM THE M25 • Take the A23 sign posted Croydon. • When you reach Croydon turn right into Stafford Road which leads into Duppas Hill Road (A232). • Follow directions above. CAR PARKING • There is underground and outside parking available on request. • The nearest public parking is 200 yards away. By Air: FROM GATWICK AND HEATHROW AIRPORTS • Road access is via the M25 motorway network. • Direct rail service from Gatwick to center of Croydon. By Public Transport: • East Croydon station is a Four minute walk away with services to Gatwick airport and central London. • From East Croydon station turn right then right again into Dingwall Road, walk to the end of the road and turn left at the roundabout, we are on the left hand side opposite Fairfield Hotel. • West Croydon station offers train services to popular residential suburbs and a bus route to Victoria station in central London.

Additional Notes

Please note we have various centre's across the Uk call us on 0844 561 1075 for more information.