Overview

Microsoft Access is a desktop database programme that helps users store, manipulate and query data, perform calculations and produce reports. Planning a Database • Identify database purpose • Design a relational database • Normalising the data Tables • Revision of field properties • Creating Lookups • Single and multiple Fields indices • Importing and linking tables from other databases • Importing data from spreadsheets • Exporting data Queries • Parameter queries • Grouping and summary queries • Calculated fields • Join Properties • Update queries • Make-table queries • Append queries • Delete queries • Crosstab queries Form Design • Adding and modifying controls • Displaying data on sheet tabs • Calculated fields • Sub-forms • Adding pictures to records • Displaying data in a chart Report Design • Sorting and grouping • Calculated fields • Printing data in columns • Create mailing labels PivotTables and PivotCharts • Creating PivotTables • Modifying PivotTables • Working with PivotCharts Utilising Web Capability • Creating and using hyperlinks • Create a Data Access Page • Improve Presentation of Page • Viewing Data Pages with the Browser • Edit data using the Data Access Page Introduction to Macros • Overview of macro actions • Creating macros • Assigning macros to events Database Utilities • Compacting a database • Repairing a database • Backing up a database

Who is it for?

Knowledge of how to create tables, queries, forms and reports, as well as adjusting field properties is necessary. Completion of the 2-day introductory course, with some additional practice should allow delegates to attend at this level.

What will i learn?

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

How will i be assessed?

Once completed delegates will be given a certificate of attendance.

Address

First Stop Training Ltd The Lansdowne Building 2 Lansdowne Road Croydon Surrey CR9 2ER

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 please call us on 0844 561 1075 for more information.