Access Intermediate

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)

access intro2

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

• 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

• 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