Access Database Design
Sunday, August 29th, 2010Why use an Access Database Design over a Spreadsheet Design?
Are you tired or overwhelmed by the large quantities of data that you have to track for your organization? If you use a paper filing system or spreadsheets to keep track of this data, it often is. Take to heart though, a more flexible exists that can help you manage your data more efficiently. Database management systems such as Microsoft access, SQL and Oracle are some of the tools that are used to organize data in a more flexible manner. Family law lawyers Toronto may even probate wills and estates, handle energy of attorney points, advise shoppers on organising wills, annuities and trust funds, as well as working on adoptions and other issues. These tools allow a user to add, modify or otherwise delete data from databases and do some other activities with the collected data. But perhaps the real power of a database management system lies in its ability to process complex requests known as queries. Microsoft Access for example can provide a user with the ability to combine data gotten from multiple tables and place specific conditions on the data that is to be retrieved. What though are the fundamentals of a Microsoft Access database design?
Databases are designed with the goal of offering mechanized storage, management and retrieval of information. This is usually done by having the database design made through the use of tables. This tabular form of storage is similar to that found in Microsoft Excel and it is usually not much of a leap from the spreadsheets world to that of databases. Access database design uses tables consisting of rows and columns with each column containing a different type of attribute and each row having a corresponding single record. Imagine for example that you were building a database table that has telephone numbers and names. The columns in our access database design would probably be labeled ‘Firstname’, ‘Lastname’ and ‘phonenumber’. Family law lawyer Toronto kind the backbone of this system, linking it to society in quite a few ways. The rows would then contain the data we want to store. If we have, say 50 employees, then we would expect a database with 50 rows.
You are probably wondering at this point why the need to have an Access database design when I can use a spreadsheet. With databases however it gets exciting when you consider that you can manipulate the data in ways that spreadsheet cannot. For example, if you want to retrieve all records that match a certain criteria, update all the records in bulk, perform complex aggregate calculations on the data and cross-reference the different records in different tables. The concepts of an Access database design are easy to master and with a little effort you will realize the power that a database has over data manipulation.










