Microsoft Access is a relationship data base management system through which you can have multiple tables, all linked to each other through a common field, each table containing a specific type of information. For instance you can have one table containing a list of all the items that you sell, another table containing information about which item can be procured from which supplier another table containing orders for different items received from different customers and yet another table containing basic information about customer themselves and all this table can be linked together though common key fields.
Access also gives you the option of working with one access table by itself or with different kinds of data base fields and records has been explained later in the “Creating data base” section.
A modern relational data base management system can perform a wide array of tasks. In general it acts as a transparent interface between the physical storage and the logical presentation of data. In practice, it provides a set of more or less flexible and sophisticated tools for handling information, you can use these tools to
• Define a database
• Query the database
• Add, edit and delete data
• Modify the structure of the database
• Secure data form public access
• Export and import data
Because it gives you so much control over your data, a relational DBMS can also serve as the foundation for product that generate, Applications and extract data.
Which of theses abilities you consider most imported depends on The job that you need to do you might be in change of creating and Maintaining a database’ you might be a casual user who primarily works with existing applications to accomplish specific tasks, or you might be system developer who creates such applications. If you are using professional oracle version 5.1 all three roles in your works, so lets take a closer look at each of them.
Comments
Post a Comment