For example, you might want to associate inventory transactions with a particular salesperson. To do this without Access you would have to know what is meant by a view or, the more complex, SQL language. Some people might worry that Access will allow unauthorized access to tightly-controlled data. This is not true, because Access must follow security procedures just like any other user. 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.