Menu

Access Pros and Cons Microsoft Access or Microsoft Office Access is a database framework made for little to-medium-sized organizations who need to catch

Access Pros and Cons
Microsoft Access or Microsoft Office Access is a database framework made for little to-medium-sized organizations who need to catch, oversee, and report information professionally. It is from the Microsoft Office Suite of utilizations which joins the social Microsoft Jet Database Engine with a graphical UI and programming advancement apparatuses. Since Microsoft Access does not require confounded programming, consistent individuals can make ground-breaking information bases in cutting edge routes with Microsoft Access. (Admin, 2013)
Advantages
Simple to introduce and utilize — Access gives information supervisors a completely practical, social database administration framework in minutes. In the same way as other Microsoft applications, Access contains Wizards that always walk you through. The UI is natural; quickening information data recovery. (Admin, 2013)
Multi-client bolster – About ten clients in a system can utilize an Access application.
Importing data — Microsoft Access makes it easy to import data. (Admin, 2013)
Disadvantages
One document — All the data from your database is spared into one record. This point of confinement alternatives and how you pick use information; backing off reports, inquiries, and structures. Its execution turns out to be moderate as the client scales information estimate. Mixed media information can go through MS Access restricted space rapidly. (Admin, 2013)
Multi-client constrained — Technical farthest point is 255 simultaneous clients, yet certifiable utmost is 10 to 80 (contingent upon kind of utilization). (Admin, 2013)
RDBMS stands for Relational database management system. It uses tables(relations) for storing the data. In mathematical terms these tables are called relations.
Features of RDBMS:
One of the features of the database RDBMS is that it is it stores the data in tables. Other features include: data is created using SQL and every table has several rows and columns.
Provides referential integrity.
Provides primary key for data uniqueness
Components of RDBMS:
Interface Drivers: these interfaces provide definitions of methods to retrieve delete or insert data. Data definition, manipulation languages are some examples.
Sql Engine: it is responsible for interpretation and execution of the sql queries.
Data dictionary: stores the information about data that is stored inside the tables