Working with data in RDBMS is very different from working with data in a word processing or spreadsheet program.
Data Control
Spreadsheets and word processing documents are great for solving single-user problems, but they are difficult to use when more than one person needs to share the data.
When you need to share your information with others, RDBMS gives you the flexibility to allow multiple users to read or update your data.
An RDBMS that is designed to allow data sharing also provides features to ensure that no two people can change the same data at the same time.
The best systems also allow you to group changes (which is also known as transaction) so that either all the changes or none of the changes appear in your data.
You might also want to be sure that no one else can view any part of the order until you have entered all of it.
Because you can share your Access data with other users, you might need to set some restrictions on what various users are allowed to see or update.
- In a word processing document, you can include tabular data and perform a limited set of functions on the data in the document.
You can also search for text strings in the original document and, with ActiveX controls, include tables, charts, or pictures from other applications.
In a spreadsheet, some cells contain functions that determine the result you want, and in other cells, you enter the data that provides the source information for the functions.
An RDBMS provides you many ways to work with your data. For example;
You can search a single table for information or request a complex search across several related tables.
You can update a single field or many records with a single command.
You can write programs that use RDBMS commands to fetch data that you want to display and allow the user to update the data.
Access uses the powerful SQL database language to process data in your tables. Using SQL, you can define the set of information that you need to solve a particular problem, including data from perhaps many tables.
Data Control
Spreadsheets and word processing documents are great for solving single-user problems, but they are difficult to use when more than one person needs to share the data.
When you need to share your information with others, RDBMS gives you the flexibility to allow multiple users to read or update your data.
An RDBMS that is designed to allow data sharing also provides features to ensure that no two people can change the same data at the same time.
The best systems also allow you to group changes (which is also known as transaction) so that either all the changes or none of the changes appear in your data.
You might also want to be sure that no one else can view any part of the order until you have entered all of it.
Because you can share your Access data with other users, you might need to set some restrictions on what various users are allowed to see or update.
0 Comments