Introduction To Database For Beginners

CONTENT 1. Introduction and concepts 2. Creating a database using MS Access 3. Tables 4. Forms 5. Queries 6. Reports INTRODUCTION AND CONCEPTS A database is a collection of information organized to provide efficient retrieval. The collected information could be in any number of formats (electronic, printed, graphic, audio, statistical, combinations). To create and manage Databases, Database Management System (DBMS) software is used. A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include ; MySQL Oracle, MS Access FoxPro, DbaseIV Lotus Approach Microsoft SQL Server Advantages of the DBMS: The DBMS serves as the intermediary between the user and the database. The database structure itself is stored as a collection of files, and the only way to access the data in those files is through the DBMS. The DBMS receives all application requests and translates them into the complex operations required to fulfill those requests. The DBMS hides much of the databases internal complexity from the application programs and users. 1. Improved data sharing. The