Training tools online

In the world of creating and using databases using Microsoft Access is one that is rather simple to learn, but provides some great tools and data manipulation for most users. If you need of brushing up on your knowledge or learning some new skills then getting Microsoft Access training online should be a top priority. These are MS Access certified trainers, so you can be assured that you are getting genuine advice and learning. Companies can also brochure printing services at UPrinting to help provide hard copy materials for those that attend the online training. You will want to take notes and having a hard copy outline will help in the overall training and retention. We use Access in some of our daily database management tools to create and maintain some of our customer  data. I originally taught my self on MS Access about two years ago, reading through the larger books and picking out different scripting language to build and customize some of our databases. I then tried to search and find video conference applications where you can watch live webinars or recorded sessions to see the hands on application. I started off using some of the basic tables, and forms fields to create and manage customer interactions. We also piped in Excel spreadsheets for orders and service requests. These all rolled into weekly and monthly reports that we used to help identify certain hot topics and problems across our services.

brochure printing

After taking some of the actual onsite courses, I was amazed at just how much more I could do without having to rely on outside programmers. While there is no substitute for live training where you can interact with others to answer questions and provide real life scenarios using video conference to help train is becoming more popular. The instructors we had were great in their ability to make the content real life and not as technical. This was helpful, when idea to capture certain data, or have a certain report run, I no longer had to wait on others to get the proper coding done. I was even able through some of the advanced online learning’s, get a handle and successfully implement SQL queries and improve on our relational databases.

Access makes it very easy for those that do not wish to create SQL language, by allowing simple to follow features, such as the table look up feature. We found this helpful when joining several tables that actually had to look up themselves to relate the data for different subsets.It is very important to name the tables with the extension such as “tblcustomers”, “frmscustomers”, as a good naming technique. We found this out early on a certainly saves a lot of time when cross referencing tables to forms, so we knew which were which.

Another key learning we got through our Microsoft Access training was that when using Access online we needed to make sure that we regularly optimized our databases to reduce the load on the server, and make sure there was minimal lag time in processing the customers request. Some of our earlier attempts created too many links and references so the table and lookups were not very efficient causing some serious lag time for our customers. So choosing function over fashion was definitely a lesson well learned. Here are some the pointers that have helped us streamline our tables:

1)Try and use several long tables rather than one wide (many fields) table.

2) Try to avoid AutoNumber fields when creating Primary Keys for a table. But rather use one or more data fields for this purpose.

3) Use Lookup lists with a link to lookup table linked to the main table for text fields.

Leave a Reply

Your email address will not be published. Required fields are marked *