As soon as you want to manage a mobile library or multiple branches, you would have to ditch Access for a real SQL RDBMS. You could probably use it to catalogue your Funko-Pop collection, or to keep track of the inventory, lending and book returns of a municipal library, as long as the database is only kept on one computer. It is not something you can pick up on one afternoon to code your company’s billing and invoicing system. It is not a networked database, but it can be used to run SQL queries on a local database, and multiple users can open the same database file if it is on a shared SMB folder. It has an integrated editor for the database schema and a GUI builder to create forms and reports. Access is a database product, designed to compete with products like dBase, Cornerstone, and FileMaker. Sometimes people confused Excel and Access because both have tables, so at some point Microsoft caved in and made Excel understand SQL queries, but Excel is still not a database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |