Learnit Training
Course Access Basics
  • Learn how to access and display data using Access
  • Suitable for Access versions 2007, 2010, 2013 and 2018
  • Very experienced teacher with a broad knowledge
  • Small group with a lot of personal guidance
  • Laptop and lunch we provide

In two days you will learn the complete basics of Access in this training. From creating a simple table to retrieving data with filters and queries, creating useful forms and finally presenting the information in reports.

Yes, I want to know more

"Good course that is easy to apply in everyday use."-Rating: 9.3

learnit Access Base

Course Access Basics

Retrieving information from databases for analysis and reporting can quickly become complex, but with the training Access this is fortunately within everyone's reach. In This training you will get to work with your database and the retrieval of information with filters and queries is explained and extensively practiced.

In the training we will discuss the structure of databases and you will learn how to access them with Access. You will learn how to retrieve data using filters and queries and how to display it in reports. Not only does it cover data retrieval and editing, it also teaches you how to define your own tables and how to create handy forms.

One advantage of following the training is that you greatly increase your knowledge and understanding of the structure databases in general, so that you also understand the structure of other databases in addition to MS Access databases.

Topics

  • Getting acquainted with databases
  • Designing tables in a Database
  • Change table Formatting
  • Change, add, and delete data
  • Sorting and searching data
  • Filters
  • Index
  • Using primary keys
  • Retrieving from tables by using queries
  • Working with more tables
  • Labels
  • Create forms so that someone can fill in data without knowledge of Access
  • Filter and Selection Filter form
  • Customize Form Design
  • Using reports to create a clear report from the data in the tables

The Trainer

You will be supervised by a social and skilled trainer during the training. The trainer discusses at the beginning of the training what your entry level is and what you want to get out of the training, so that you can focus on subjects and exercises that are important to you.

What version? 2007, 2010, 2013, 2016 and 2019.

During the registration you can fill in the version you are using. Our planners will ensure that you can follow the training in the correct software version with the material that is written for this version.

After

At the end of the training, you can access databases by accessing and know how to query and filter information. You have mastered the key features of Access, such as creating queries, forms, and reports. In addition, you have a general understanding of the structure of databases with the corresponding terminology.

Prior knowledge

No experience with Access is required for this training. However, some experience with Windows is a pre. The training Windows base can be the basis.

Note

This training can be followed in different versions. Please indicate whether you are using Access 2007, 2010, 2013, 2016 or 2019.

Lesvorm

This training is offered on the basis of our Open learning form-teaching method. This means that under the active supervision of our trainer, you are working independently to make your own substance. You can achieve your learning goals at your own pace without being bothered by a faster or slower pace of your fellow students. The trainer will ensure that you stay on track and achieve your learning goals. This form of learning offers space for customised work. You will have the opportunity to create examples from your own practice and IT environment that will make you more specific. more...

Language

The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.

Investment

Mentioned prices are per person, including course material. Lunch is included in the training on location.

On location Online
Duration 2 days 4 sessions of three hours
Price per day, excl. VAT € 325,- € 240,-
Total, incl. VAT € 786,50 € 580,80

Certificate

After completing the training, a LEARNIT certificate will be issued as proof of participation.


Online

We also organize this training online. For this we use Webbex or Zoom. Logging in with Skype is also possible. On request this training can also be organized with Microsoft Teams.

The training lasts 4 sessions of 3 hours, spread over 4 weeks.

  • Until one year after the training you can participate for free.
  • Against payment of the catering costs you can also participate in a classroom training.

References

The Access Basic course has been assessed with an average of 8.4.

"the Access 2010 Basis training is good to do, even for people who don't yet have Access experience. You work in 2 days quietly the book Access part 1 by his questions can ask you and will be explained to you personally, for the more advanced who leafs through the book part 1 faster and with part 2 can make his floor money again, you have questions they will be explained to you again 1 on 1. a fun and educational course." - Rating: 8.0

S. van der Vliet, Rijksdienst voor Ondernemend Nederland - Access Base

"Good course that's easy to apply in everyday use." - Assessment: 9.3

R. Fiks, Achmea Care and Health - Access Base

"A training you can do at your own pace. It starts with the basics and slowly leads you to be able to build a simple database yourself. In my opinion, you do need a thorough basic knowledge of Excel. But overall an excellent course that I can recommend to anyone". - Review: 7.8

W. B. Vermeulen, Theodoor Gilissen Bankiers N.V. - Access Base

"I followed the Access Basic training, after attending the training I am able to extract the reports needed for our organisation from our client registration system and present them in a professional way. Nice that the exercises you make in the training are easy to translate into what is needed in your own organization". - Rating: 10.0

R. Borkent, St. VO Rosa Manus - Access Base

"Especially taking this course. Individual coaching works super well. Highly recommended." - Assessment: 8.3

W. van Pelt, Ericsson Telecommunicatie B.V. - Access Base

"Access base is much more than just understanding the layout and buttons, with the base you can already do a lot with access which is enough for me to get started with". - Assessment: 9.4

M. Ronokarijo, Total Nederland N.V. - Access Base

"Excellent way to get acquainted with Access." - Assessment: 8.3

I. Dzambo, CBS - Access Base

"On the basis of the Access 2007 basic course, I would like to indicate to interested parties that they are interested in joining Learnit if you want to learn Access, Excel or PowerPoint well. The subject matter is well explained in the book and any questions the teacher answers immediately". - Rating: 8.0

S. Polak, Schouten Insurance - Access Base

"Even if you've never worked with Access before, you can get started in a good and fun way with the textbooks." - Review: 7.9

L. Pattikawa, Transcom - Access Base

"good course, a lot of learning." - Assessment: 8.2

P. van der Struijs, NRG - Access Base

"Training Access Basic which I have followed through learnit is provided with very clear and well-organized teaching material, which is further explained and explained by a very experienced teacher. - Rating: 8.0

R. Bell, CEVA Logistics - Access Base

"I have a very good impression of the course through Learnit. The most appealing thing is that you can go through the fabric at your own pace. So you're not dependent on fellow students. A professional and very friendly teacher is available for any questions". - Rating: 8.0

M. Salman, RSA Netherlands - Access Base

"I'm satisfied with the training I've had and will definitely recommend Learnit to others or follow other training in the future. Because the teaching material can be taken with me, I have a good basis and reference of what I have learned". - Rating: 8.0

E. de Brouwer, BMW Financial Services B.V. - Access Base

"To the point training where your own learning goals come first." - Assessment: 8.4

Floor Frederiks, Kennemer Gasthuis - Access Base

"In a short period of time I've learned a lot that I can directly apply in practice." - Assessment: 8.1

Gert Lems, Safe region South Holland - Access Base

"I'm very positive about Learnit. The training is very clear, the course material is extensive, step by step through the material. The environment is pleasant, quiet, the group is pleasantly small and the guidance is one-on-one and focused on individual needs. I learned a lot in two days and now apply it in my work. I warmly recommend Learnit." - Review: 7.7

R. van Nimwegen-Anbeek, Christian Lyceum Veenendaal - Access Base

"Very clear teaching material and teacher; an instructive course and experience!" - Review: 7.6

K. Heeringa, Conscious Hotel Vondelpark. - Access Base

"Easy to follow training through step-by-step explanations and exercises. In case of ambiguities the trainer can give further explanations after which the exercises in the book (2 pieces) can be completed independently". - Review: 7.6

J. Japenga, SNS Bank - Access Base

"Clear teaching material that you can finish at your own pace." - Assessment: 8.1

H.G.G. Houx, Rabobank Netherlands - Access Base

"Excellent buildup. Directly applicable. Recommended!" - Assessment: 8.2

J. Joanknecht, Joanknecht Holding b.v. - Access Base

"Nice teaching material, nice to be able to work at your own pace and a trainer who is ready to help you. Fine way to take the fabric to you. We work in small groups." - Rating: 8.6

R. Westerink, Spectrum, partner with Elan - Access Base

"Followed the Access beginner course in Heerenveen. Small group, good guidance. Course material is pleasant to work with and is well-organised. Learned a lot in two days!" - Assessment: 8.2

G. Koster-Storteboom, Trustus Capital Management - Access Base

"I took the Access Basic course. The teacher is very knowledgeable and takes all the time to help you. Knows how to create a very pleasant atmosphere." - Rating: 8.0

J. de Graaf, Incotec Group B.V. - Access Base

"The subject matter offered is clear and it's nice that you can work at your own pace. Teacher is pro-active and expert. Good facilities. Recommender" - Rating: 8.6

D. Thijssen, CEVA Logistics - Access Base

"For me, the great advantage was that the teaching material is very clear. This allows you to follow the training without the stress of what they mean. I have been very positively surprised. I have to say that I already had some knowledge of access."

- Access Basic

"Great course. Learned a lot. Exercises are very good. Many of these can be used for their own applications." - Rating: 8.0

J. Rensen, Shell Pensioenbureau Nederland B.V. - Access Base

"This training and trainer has made clear to me what I can and especially what I cannot do with Access. Great result." - Assessment: 7.4

H. Hulsink, MailFactory - Access Base

"The Access Basics course fits in very well with practice. It contains very useful things. The course material fits in perfectly with the learning objectives and you can work at your own pace. A next course I would definitely do again at Learnit". - Review: 7.6

M.A. Wildenberg - Access Base

"I came to Learnit to be able to make my work easier by applying some extra skills. This will certainly succeed after this instructive and interactive course". - Assessment: 8.4

M. Karens, De Persgroep - Access Base

"The Basic Access course is a very useful course if you are unfamiliar with the program. It starts from the basics, and even if you have very little experience with computers, it is still good to do. The study book describes step by step and in great detail how to work with the program". - Rating: 9.0

R. Stolker, Deliflor Chrysanthemum B.V. - Access Base

"Instructive and clear course. Also for people who are less interested in computer programs. The days flew by." - Rating: 9.0

P. Thomas, Ministry of Defence - Access Base

"To get acquainted with SQL in a pleasant way under the guidance of a skilled and driven instructor." - Review: 7.9

E.C. van Herwaarden-Boekweit, Achmea Care and Health - Access Base

"My experience with Learnit Training has been very positive. Good communication, clear agreements. Contents and execution of the training are fine." - Rating: 8.0

M. Oostland-Meles, Education Executive Agency (DUO) - Access Base

"Clear course. Textbooks fit in perfectly with the training. the subject matter described in the textbooks is more than clear. Assignments are clear and easy to carry out with the explanation that can be found in the book. Trainer is on a level that no question remains unanswered. answers are clear." - Rating: 9.0

M. Schins, AMC - Access Base

"A training where time is taken to learn." - Assessment: 9.3

A. de Rop, CEVA Logistics - Access Base

"For me, the great advantage was that the teaching material is very clear. This allows you to follow the training without the stress of what they mean. I have been very positively surprised. I have to say that I already had some knowledge of access."

- Access Basic

"Very good training that perfectly matches the practical needs of developing and maintaining a database in Access." - Rating: 9.0

H. de Jong, Diamond Genetics - Access Continued

"The training is based on a variety of levels, both beginners and advanced. The teacher responds very well to this and you immediately feel at home in the group despite the level differences. I can really recommend the training." - Review: 8.7

F. Bergsma, Rent Committee - Access Continued

"Very complete training, with, in my case, a very knowledgeable teacher. Pre-knowledge of Access is certainly required, otherwise the training would be too complicated. A special advantage is the possibility to bring your own practical examples on a USB stick etc. so that you can work on this or discuss specific issues with the instructor. I have experienced the open learning form as pleasant because you can work at your own pace and have the freedom to skip parts (because you already know how to apply something) or to choose your own order of material to be treated". - Assessment: 8.7

T. Sassen, Cromaflo Technologies B.V. - Access Continued

"Very good training to learn and deal with Access 2003 Basics." - Assessment: 9.1

Marco Kruijt - Access 2003 Basic

"To get acquainted with SQL in a pleasant way under the guidance of a skilled and driven instructor." - Review: 7.9

E.C. van Herwaarden-Boekweit, Achmea Care and Health - Access Base

"I took the Access Basic course. The teacher is very knowledgeable and takes all the time to help you. Knows how to create a very pleasant atmosphere." - Rating: 8.0

J. de Graaf, Incotec Group B.V. - Access Base

"Access base is much more than just understanding the layout and buttons, with the base you can already do a lot with access which is enough for me to get started with". - Assessment: 9.4

M. Ronokarijo, Total Nederland N.V. - Access Base

"The impression I have of Learnit is good, you can go through the lesson material at your own pace and consult the teacher if you have any questions. - Assessment: 8.4

G.J. Scholten, Nijland B.V. - Access Continued

"Very complete training, with, in my case, a very knowledgeable teacher. Pre-knowledge of Access is certainly required, otherwise the training would be too complicated. A special advantage is the possibility to bring your own practical examples on a USB stick etc. so that you can work on this or discuss specific issues with the instructor. I have experienced the open learning form as pleasant because you can work at your own pace and have the freedom to skip parts (because you already know how to apply something) or to choose your own order of material to be treated". - Assessment: 8.7

T. Sassen, Cromaflo Technologies B.V. - Access Continued

"It's nice to be able to work independently with the subject matter and all sorts of exercises. The expert teacher is always at your disposal if you have any questions". - Assessment: 9.1

I.K. Geuzenbroek, TU Delft - Access Continued

"Learnit offers a good training, which is given in a relaxed and thorough way. The instructor will make sure that you receive appropriate support on your own practical questions". - Assessment: 8.6

Rene Friederichs, Municipality of Arnhem - Access 2002 Basic

"the Access 2010 Basis training is good to do, even for people who don't yet have Access experience. You work in 2 days quietly the book Access part 1 by his questions can ask you and will be explained to you personally, for the more advanced who leafs through the book part 1 faster and with part 2 can make his floor money again, you have questions they will be explained to you again 1 on 1. a fun and educational course." - Rating: 8.0

S. van der Vliet, Rijksdienst voor Ondernemend Nederland - Access Base

"Nice teaching material, nice to be able to work at your own pace and a trainer who is ready to help you. Fine way to take the fabric to you. We work in small groups." - Rating: 8.6

R. Westerink, Spectrum, partner with Elan - Access Base

"Clear course. Textbooks fit in perfectly with the training. the subject matter described in the textbooks is more than clear. Assignments are clear and easy to carry out with the explanation that can be found in the book. Trainer is on a level that no question remains unanswered. answers are clear." - Rating: 9.0

M. Schins, AMC - Access Base