Microsoft Access Training – Introduction / Intermediate
Details
This introductory Microsoft Access training course will teach you the fundamentals of using Access.
Microsoft Access is a popular database programme enabling the user to manipulate data in a number of ways. Data can be analysed and sorted, specific information can be searched for, and the results can be used to produce reports, lists and more.
This course is instructor led, involves the use of a number of examples and exercises in a workshop environment to bring the classroom teaching to life. The course is led by an experienced Access trainer.
Our two day Microsoft Access Introduction / Intermediate course will equip you with the skills to create your own databases to manage your information more effectively. By the end of this training course, students will be able to describe and create databases, access, view and process data using queries, produce forms for data entry and view data in report format. You will be a confident user of Access.
At the completion of this course you should be able to:
understand how Access is used and how to navigate around it
- design a database with lookup tables
- create a database structure using Access
- modify the structure of an existing table
- set table relationships and join tables together
- add records to a new table
- add transactional records to a lookup database
- use various data validation features in Access to protect data
- work with the records in a database table
- format the data in a table
- sort and filter records in a table
- export records to and import records from a wide variety of sources and applications
- create simple and effective queries
- perform more advanced queries using a variety of querying techniques
- create queries based on one or more tables
- create and use parameter queries
- create calculated queries
- create meaningful reports from tables
- create and use forms.
It is assumed that delegates have little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment
WHAT'S INCLUDED
- A full colour introduction to MS Access manual or book.
- The exercises that you have worked on during your course to allow you to practice afterwards.
- USB stick to take the exercises away (where relevant).
- Freshly prepared lunch in our onsite cafeteria.
- Refreshments though out the day.
- Training in fully air conditioned facilities from an experienced Access instructor.
- Free parking at our Guildford training centre.
Founded in 2002, Acuity is focused on building long-term business relationships by offering high quality, interactive training that works.
Our trainers have years of experience working within commerce and industry, designing and delivering training programmes for all sorts of organisations. Most importantly, they really love what they do.
With class sizes limited to a maximum of 8 delegates (but typically running with between 2-6) our training courses are able to incorporate numerous hand’s on exercises to consolidate the learning and delegates are assured of detailed personal attention, with plenty of time to ask questions and tackle issues that are relevant to them. Each of our delegates receives a full colour manual and copies of the relevant course exercises to take away with them so that they can review the course material in their own time after the course.
Here are just a few reasons why our customers say they keep coming back to us:
•Easy booking procedure.
•Passionate, highly experienced trainers.
•Small, personal classes.
•Relaxed and highly supportive learning environment.
•Relevant and up-to-date training programmes.
•Proven track record, from SMEs to large government departments and multinationals ...