When a report or query is run, the host computer, a mainframe or database server, does most of the calculating and sorting. Access simply requests such data and waits patiently to receive it. Still others might say that Access will clog the computer network with requests for mountains of data in far-away places. Access also uses something called scrollable cursors to retrieve data one screen-load at a time rather than the whole set at once. If your forte is system integration, you can use Access to test systems as you build them.
Access is an ideal tool for keying test data.
This is prone to errors and unwieldy, not to mention that doing this all day long would put your staff in a sour mood. Easy Data Conversion Access can convert dates to text, numbers to text, text to numbers, and so forth. This is easier to do than you might think. Access lets you fumble your way through writing code, pointing out spelling errors and correcting capitalization as you go. Debugging is easy, because you can stop a running program, add a new line of instructions, then let the program carry on.