1. what is MS Access?:
Microsoft Access is one of the most popular and powerful DBMS. It provides various built-in features. these features help the user to construct database and view information.
2. State the use of MS Access:
Microsoft Access is used to store and process a large amount of information. It is used to create queries, forms and reports easily. it allows entering, updating and reporting information.
3. Define IDE.
IDE stands for Integrated Development Environment. it is a collection of facilities provided to the users. It is used to create databases and database applications. An IDE simplifies the tasks of creating and using a database.
4. List some advantages of IDE.
- It is easy to use.
- It simplifies the creation of database applications.
- It does not require a detailed knowledge of databases.
- It provides predefined facilities to search, sort, retrieve and process data in databases.
5. List some disadvantages of IDE.
- IDE uses graphical interface. It requires more memory and processing power.
- Some IDEs do not allow users to interact with the databases directly.
6. Write some advantages of using MS Access IDE.
MS Access IDE provides samples databases., wizards and keys to understand structure. It is integrated with other applications of MS Office. It provides easier programming facility. There is no redundancy in MS Access.
7. Define the term RDBMS.
RDBMS stands for relational database management system. It is a collection of programs that creates and maintains a relational database. A database in which data is stored in relations is called relational database.
8. List soem facilities provided by a good RDBMS.
- Data security
- Data integrity
- Easy access
- Backup and recovery etc.
9. What is database wizard?
A database wizard is a set of steps that guides the user to create a database easily. It includes choosing a database template, selecting fields, making customizations, adding pictures and the database.
10. Write advantage and disadvantage of using database wizard.
The advantage is that it creates the database very quickly and easily. The disadvantage is that the user may have to make changes in the database that is created using wizard.
11. Describe application window of MS Access.
MS Access Application window follows standard layout of all Microsoft applications. It contains different object that are used to design and create databases.
12. Name different parts of MS Access application window.
Different parts of application window include title bar, menu bar, toolbars, menus, scroll bars and status bar.
13. Describe menu bar.
Each word on menu bar represents a different menu. Each menu contains commands to activate the features of MS Access. If a command also appears on toolbar, the icon representing the command is also displayed in menu. It makes recognizing commands easier.
14. what is the use of database window in MS Access?
Database window in MS Access is used to organize all objects in database. The default table listing is used to displays all tables in current database. It is also used to create tables.
15. List different buttons available on Access database window.
Different buttons available on Access database window are Tables, Queries, Forms, Reports, Pages, Macros and Modules.
16. How is Database window used to easily create or open database objects?
Database window contains an object bar to display different database objects. It also contains a toolbar to select the object to be used. The user can select the object and then click Open or Design button or click New button to create a new object.
17. Define database object.
A component of a database system is known as database object. MS Access provides various objects that are used to store and retrieve data from database.
18. Write down the major database objects in MS Access.
The major database objects in MS Access are Tables, Queries, Forms and Reports.
19. Define any tow database object.
The database object table is used to store data in database. The database object query is used to retrieve data from database.
20. Which database object stores the data in the database?
The table object stores the data in the database.
21. Which database object is used to create and format printed output?
The report object is used to create and format printed output.
22. Define query.
A query is a statement that extracts specific information from database. Queries are used to retrieve the required data from database. Data is retrieved according to the criteria given by the user. It is a more flexible way of selecting. Filtering and sorting records.
23. How is a query written?
The query is written in database access language such as SQL. A query retrieves data from the database and displays it in the form of table. The user can also change data in the database by using queries. Queries can also be used to perform calculations on fields.
24. Define form.
A graphical interface used to interact with the database is called form. Forms are used to enter data in the database. The user can also retrieve, change, delete and update data by using forms.
25. Write some advantages of forms.
- Forms are easy to use.
- Forms use graphical interface that is attractive.
- The user can interact with database without technical knowledge.
26. What are reports?
Reports are the outputs of database application. Reports are used to retrieve and present data in a formatted way. The information on reports is arranged in different ways. A report may alos contain graphs, charts and tables etc.
27. Why are reports important?
Reports are very important in making key decisions. The user can print reports to send them to different people. The output of a query can also be used as source for reports. Most of the DBMs provide the facility of reports.
28. List some advantages of reports.
- Reports provide quick result from databases.
- Reports help in making important decisions.
- Reports can display processed data using graphs and charts etc.
- Reports can be printed or emailed easily.
29. How does a database differ from a table?
The database is the main structure that holds one or more tables. A table is an object in the database that is used to store data about a particular entity.
30. How do fields and records differ?
Fields are the smaller units that make up pieces of information contained in records.
31. Which database object can be used to create a report?
The database objects Table and query can be used to create a report.
32. Which screen element is used to display all database objects?
The database window is used to display all database objects.