I.T. Departments and Microsoft Access Thank you for reading this. My guess is that you are a hardworking, time poor, I.T. Support person with no desire to learn more about MS Access than you need to. You have probably been tasked with looking after, some mickey mouse database, that was created by a long-gone staffer, who wasn’t even a programmer, but the database is now mission critical to your organisation, or at least one department of it. You might have even been feed the usual garbage, by people who should know better, that Microsoft Access is a curse on the face of computers, and should ..read more

There are several valid reasons why I. T. Departments are reluctant to allow MS Access databases in their environment. There are equally valid reasons why users consider MS Access to be a good solution for their organisation. I should state that I do work with MS Access databases and have done for over 25 years. I have also worked in and managed I. T. Departments. That enables me to see both sides of the fence. I sympathise with both sides, and I appreciate each sides arguments. Herein is each sides arguments and a comprise solution which can appease both sides. The I. T. Departments view I.T ..read more

Speed up your Access Database on a network connection with these tried and tested techniques from a database professional with over three decades of experience. A slow Microsoft Access database on a network is painful for the staff who have to use the system. It makes using it, a tiresome, burdensome chore. Unnecessary slowness causes stress, which your staff could pass to your customers by way of expressing their bad feelings. How often have you waited at a counter while the staff member operating the computer firstly enters your name, then waits, while the screen loads, apologises to you fo ..read more

One to one, Microsoft Access Training in Launceston, Hobart, Devonport & Burnie Tasmania and National remote training. We provide professional one to one training, at your premises, on your computer, for less than the price of a place in a group course. Whatever your issues are, we can help. How can you get immediate Microsoft Access Training? Call I.T. Guaranteed on 1300 889 533 Microsoft Access Training Course Outlines Introduction to Microsoft Access part 1 ( 2 hours) First Looks Definitions Normalisation Review Database Rule No.1 Designing a Database Creating A Database Creating ..read more

Computer Training The computer training industry has a little secret that no-one wants you to know. Group trainers know it. Courseware developers know it. Industry experts know it, but they want to keep it a secret from you. Why? Because their very livelihood could be under threat. If this secret were to become known no-one would attend computer group training courses again. Before I tell you what this secret is let me explain group training. Standard Computer Training Qualified, professional and friendly trainer Six plus people in each group. Attend for 2 “days” Conducted at the group trai ..read more

Web apps can provide an alternative way to access your database   Launceston based, Software Development and Programming for Launceston, Hobart, Devonport & Burnie Tasmania and National remote support. Fast and friendly Programming and database development assistance, repairs, migration, upgrade to your application. Database help and design. Database sharing. Database Upgrades. Whatever your issues are, we can help. How can you get immediate Software Development and Programming Help? Call I.T. Guaranteed on 1300 889 533   Questions Are you searching for someone to quickly crea ..read more

I.T. Professionals and Microsoft Access This guide explains the software installation for all software in our catalog at I.T. Guaranteed, including Open Fleet®, NEPTA (Non-Emergency Patient Transport), Open Fleet®-CT, (Community Transport software), PETS (Photocopier Electronic Transaction System) and Easy Health Stats. Our software is completely portable and requires no administrative rights to install it.   Portable All our software is portable. It can be run from a USB or removable drive if required. It doesn’t need to be “installed” as other software, but can be copied from one fold ..read more

Now that your database is split into a back-end and a front-end, (if you haven’t then read this article) you should be getting frustrated having to delete all linked tables and re-link them. This will need to be done each time you need to connect to test data, or live data, or the back-end is moved.   It is even more problematic if the database is used by more than one organisation. Then when redistributing the front-end after changes, each front-end must be connected to a different back-end, in each of the client organisations. Some of the back-ends could be Microsoft Access databases ..read more

Splitting a Microsoft Access Database Splitting a databse is the third step in improving the speed of a Microsoft Access database. If you haven’t yet read or heard about splitting a Microsoft Access Database then either you are very new to databases or work in an I.T. department. Splitting a database is the process of separating the working bits from the data bits. That is separating the forms, reports, queries and programming from the data. The two separate databases are called a front end (forms, queries, etc) and the back end (data). Splitting the database only takes a couple of minutes ..read more