| Microsoft Access provides a user friendly interface for data entry, updating, querying and reporting.
Access creates single user or multi-user databases. An Access database can be placed on a network file server and shared by many users.
In some situations data needs to be gathered from multiple locations on a wide area network (WAN), but network speed prohibits all users sharing a single database. In this case data can be distributed to local area network (LAN) servers and consolidated periodically for companywide reporting.
When databases become too large for Access’ built in database manager (the Jet Engine) Access can be used in conjunction with a client/server database manager, such as Microsoft’s SQL Server. Access provides the user interface and reporting while the client/server database manager provides the speed of queries executed on the server.
|
|
|
