For the database of the sytem,
the Microsoft Access Database is used and it primarily a Windows file.
Itmust have a location, also called a path,
which indicates how the file can be retrieved and made available.
Although you can create a database on the root directory such as
the C: drive, it is usually a good idea to
create our files, including our databases,
in an easily recognizable folder. [6] As a normal computer file, a
Microsoft Access database has a file extension.
When we are creating a database, the database must have the
extension .accdb. When we create a database,
if you specify only a name (and path), Microsoft Access would
automatically add the .accdb extension.
If we want to create a database that is compatible with previous
versions, use the extension .mdb but we must explicitly add that extension like patientsdata.mdb.