Logo Picture

Tel: 0330 333 9 230 (Local Land Line Call Rate)

Powerpoint Intermediate2

Access Intermediate

This comprehensive course in Access is designed for participants who have completed the Access Introduction course or have the relevant business experience. The course teaches participants how to create, modify and manipulate the elements of a database, namely queries, forms, reports, etc.

Who Should Attend

This course is designed for any participants who have completed the Access Introduction course or have the relevant industry experience. The course is designed to give participants the ability to manipulate and modify a database.

Course content

Course content

• Table Relationships

 

• Queries using wildcards

 

• Using queries to find a range of data

 

• Using parameter queries

 

• Group queries

 

• Cross tab queries

 

• Creating & formatting a calculation field

 

• Action Queries

 

• Creating a new form using the form wizard

 

• Adding new fields to a form

 

• Moving and selecting multiple fields

 

• Aligning and Resizing fields

 

• Horizontal and vertical spacing

 

• Amending the tab order

• Adding text labels

 

• Adding lines and rectangles

 

• Adding unbound fields

 

• Calculations in unbound fields

 

• Creating a form based on a query

 

• Using a form to display data

 

• Form properties

 

• Using buttons to open/close forms

 

• Using the report wizard

 

• Modifying a reports design effectively

 

• Sorting and grouping data

 

• Adding unbound fields to reports

 

• Using calculations to total data

 

• Using calculations to find the average

 

• Using subtotals and a grand total

access intro2 Booking Form Online Enquiry

Duration: 1 day course

Venues: At your own offices or our luxury training venues in Cardiff,Newport (Nr Celtic Manor), Bristol or Swindon (Please state your choice of venue when booking)

ONSITE TRAINING

FROM

£650 + VAT