Overview

Microsoft Access is a desktop database programme that helps users store, manipulate and query data, perform calculations and produce reports. Designing Databases • Database Definitions • Relational Database Concepts and Terminology • Basic Database Design Methodology Access Basics • Access Database Objects • Using Design View • Working with Data in Tables, Forms and Queries • Viewing Data in Reports Designing Tables • Creating Tables • Defining Field Data Types • Setting Field Sizes • Setting Format Properties • Setting Default Values • Setting the Input Mask Property • Setting Validation Rules • Creating Primary Keys Relating Tables • Creating and Modifying Relationships Between Tables • Enforcing Referential Integrity Querying Data • Filtering Data • Using Criteria • Designing Select Queries • Creating Summary Queries • Creating Calculated Fields • Creating Parameters Queries Creating and Customising Forms • Using AutoForms • Using Form Wizards to Create Forms • Applying AutoFormats • Resizing and Repositioning Controls • Modifying a Form’s Design • Using the Property Box • Adding Controls and Labels • Changing the Appearance of Controls and Sections • Creating Calculated Fields Creating Reports • Using AutoReports • Using Report Wizards to Create Reports • Sorting and Grouping Fields • Setting Control Properties • Creating Calculated Fields Printing • Printing the result of a query • Printing a form • Printing a report

Who is it for?

No prior knowledge of Access or databases is required. However, the course will be more beneficial to delegates with a working knowledge of at least one other Microsoft Office product e.g. Excel.

What will i learn?

On completion of this course, delegates will be able to explain the meaning of a relational database; create and modify tables, forms and reports; and query data from related tables.

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