MS ACCESS
1) What is Database Management System (DBMS)?
*computer Software to manage, maintain database as well as view update and retrieve data is called database management system.
2)What do you mean by data processing?
*The term data processing embraces the technique of sorting, relating, interpreting and computing items of data in order to provide meaningful and useful information.
3) List some database applications.
* Some of the popular database management systems are: Oracle, Sybase, MS Access, MS SQL Server, Paradox, DB/2, Dbase, FoxPro, MySql
4) What is MS-Access?
* MS-Access is a RDBMS (Relational Database Management System) application developed by Microsoft Inc. that runs on Windows operating System.
5) What is Database?
* A database is an organization of data related to a particular subject or purpose so that the data can be retrieved or processed.
6) What is the extension of Access database file?
*The extension of MS-Access data file is MDB.
7) What is relational database?
*A database with tables related to each other on a common field to facilitate the data retrieval from multiple tables is known as relational database.
8) What is a key field?
* A common field on which two tables are linked is known as key field.
9) What is primary key?
* A primary key is a rule which ensures that unique data is entered for the field and the field is not left blank. This is the field that would indentify a record uniquely in table
10) What do you mean by foreign key?
*The common field in child table that maintains relation with master table is foreign key.
11) What are the elements of a database?
*The major six elements of a database are Tables, Queries, Form, Reports, Macros, Modules
12) What is a table?
*A table is a collection of data about a specific topic such as products, students or suppliers. A table organizes data into columns (fields) and rows (records or tuples)
13) What is a field?
*A field in a database is a piece of information about a subject. Each field is arranged as a column in table.
14) What is a record?
* A record is complete information about a subject. A record is a collection of fields and presented as a row in a table of database.
15) What is a query?
* A query is a question about data in database. It results a set of data from database that can be used as a source of records for reports and forms.
16) What is a form?
*Entering and viewing data directly on the database table is not always convenient. So, a form is created to facilitate easy entering data and created that retrieve records from a single table or from multiple tables.
17) What is a report? A report is an object in MS-Access that is used to view and print data. Though a Report is similar to a form; its specialty lies in special features like help to summarize data.
18) What are the differences between a form and a report? *Forms are primarily used to edit overview data whereas reports are used primarily to print or view data. In a form your usually navigate from one record to another, whereas in reports summarized data are possible to present.
19) What is a macro?
*A macro is an object in MS-Access that is used to execute one or more database commands automatically. Macros are useful in tasks such as printing month-end reports, adding new record to a table, printing letters to customers periodically.
20) What is a module?
* A module object in Access is a program written using VBA (Visual Basic for Application) to automate and customize database function.
