Master the fundamentals of Microsoft Access the quick way on this 2-day introductory Access training course.
Microsoft Access is a very popular database programme. It allows data to be analysed and sorted, specific information to be searched for, and the results to be used to produce reports, lists and more very easily.
Led by a certified Access trainer this course involves a number of hands-on exercises so that you can experiment with what you are being taught and plenty of time to ask questions.
By the end of this training course, you will be a confident, independent Access user.
You 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 learn how to:
This course does not assume any prior knowledge of Microsoft Access so don’t worry if you haven’t used it before.
It only assumes that you have experience of working with Windows and the Microsoft Office.
Our courses run from 9.30am to roughly 4.15pm with refreshments and biscuits throughout the day and a break for a tasty, freshly prepared lunch.
We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet.
Also, you’ll receive:
✔ A full-colour manual covering everything in the course for future reference.
✔ A USB stick so that you can take the exercises home with you and practice in your own time.
✔ A Certificate of Attendance.
This session is focused on database design. Before creating a database it is critical to design it correctly for it to function efficiently. This session explained the different datatypes that Access can store before leading delegates though the process of designing and refining a database design.
The key topics trained include:
Having designed a database the next step is to actually create. it. This session leads delegates through that process. So how. to create. a new file and then the table (or tables) within it. It then looks at creating and defining primary keys for the table created. The next part focuses on working with a multiple table database. It explains how relationships are defined, managed and created. Finally it shows you how to review the relationships within a database.
The key topics trained in this session are:
Once you have created your database the next step is to define the datafield that are held within each of your tables. This session gives delegates a thorough overview of defining and working with table field properties.
The key topics trained include:
The relationships between tables are critical in an Access database. This session focuses on all aspects of those relationships. It explained how they work, how to view them and then how to create and edit table joins which are defined by table relationships. It finishes by showing you how to create a report that shows the relationships within a database.
The key topics trained include:
Having established a database which contains a number of linked tables and in which the fields have been established it is time to start using your database to store data. This session focuses on entering data into a database. It shows you how to manually enter records, how to create and use a form to make data entry and how to save that form for future use. It finishes by showing you how to import data into Microsoft Access from Excel.
The key topics trained include: