Page 89 - iPro_trackGPT_V5_Class7
P. 89
Closing Database
After completing the work, you need to close the database. To close the current database, select
the Close option from the File tab.
If a database is like a treasure chest and you're the treasure keeper, how would
you organise and store your precious items to make sure you can find them
easily when needed?
OPENING AN EXISTING DATABASE
To open an existing database, follow the given steps: 1 Click on
the File tab.
2 Select the Open option. 5 Select the database.
4 Navigate to the location where 6 Click on the
3 Click on the Browse option. you have saved the database. Open button.
EXITING ACCESS 2021
To exit from MS Access 2021, Click on the Close button at the top-right corner to exit the
Access window.
A collection of programs required to store and retrieve data from a database is called a
Database Management System (DBMS).
There are mainly two types of database—Flat File Database and Relational Database.
Table is a group of related data organised in columns and rows in a database.
A set of values for the fields is called a record.
Primary key is a unique field by which the records are uniquely identified in a table.
Query allows you to retrieve information from a table based on some criteria or condition.
Database and DBMS—An Introduction 87

