Access Training
£375 + VAT for most venues (£495 + VAT for London)
1 day
This one-day course is aimed at people who don't know how to use Access, but have a database that they want to interrogate. The course explains the principles underlying your corporate database (if you bring a copy in, we'll do much more than this), then shows how to create queries to get at the data it contains. Learn how to select data, how to aggregate it and how to create expressions, then at the end of the course see a brief introduction to how forms and reports work.
We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking (or consider an onsite Access training course).
Identifying the tablesWhat are relationships?Setting a primary keyUsing multivalue fieldsDefining fieldsThe types of fieldEntering data
If time
Creating relationshipsReferential integrityThe query design gridSortingSetting criteriaCombining criteriaGrouping and totallingCreating expressionsParameter queries
If time
Creating ad hoc joinsTypes of joinLayout and design viewUsing the form wizardSplit formsCreating controlsUsing the report wizardThe group, sort and total paneReport design
No more than 6 people per classProper restaurant lunch included572 references viewable onlineFree USB stick containing course filesGenuine Wise Owl trainers onlyUnbelievably good coursewareJoanne Proctor (ATS Euromaster Ltd)
Arron Bhandal (ReAssure UK Services Limited)
Julie Loomes (AQA Education Limited)
Claire White (DFDS Seaways)
Alexandra Russell (Pearson)
There are lots more where these came from (or just refresh this page to change the quotes shown).
You should already be a confident Windows user to attend this course, but do not need to have used Access before. Note that most people find Access harder to learn than Excel.
View Access VBA or Access 2010 exercises
View Access skills assessment skills assessment tests
View Access or VBA macros blogs
