Database is a warehouse or house for storing, processing, and securing the data. The examples below show the uses of databases that you commonly encounter:
- Member accounts in websites
- Credit card information in an ATM machine
- Documents that can be searched in your computer.
- Book information in a library system
We have three ways to create a database file. However, in this tutorial, we select two ways to introduce you. The two ways are:
- How to create a database file via Blank Database Wizard
- And how to create a database file via Local Template Database File
To create a database file, you have to do the following:
- Click Start--> All Programs--> Microsoft Office--> Microsoft Office--> Microsoft Office Access 2007--> Office Button--> New
-->Or you can click New Blank Database
File Name: Enter a database’s name.
Folder Open Icon: Brow for a location to put your database.
Create Button: Create a new database.
- Write database name in the file name box
- Click Folder Open
- Click Create button
To create a local template database file, you have to do the similar way as shown above:
--> Start-> Program--> Microsoft Office--> Microsoft Office Access 2007
Local Templates--> select any local database templates which you like
To exit from Microsoft Access 2007, you have to do the following:
- Click Button Office
-Click Exit Access or Click Close Button or Press Alt+F4
If you want to open existing database file--Microsoft Access file which you created before, you have to follow the step below:
--> Open Ms.Access 2007--> Click Button Office--> Click Open as figure below:
After you click Open, Open File Dialog will load; then you can select any database file that you want to open; next click Open Button.
You can rename any database file you named it before by practicing as the following:
- Find the location of database file stored
- Right-click database file you want to rename
- Click Rename
- Write new name for database file and make sure database file extension(accdb) unchanged
- Press Enter Key.
You sometimes want to remove database file that you created because you do not need to use it any more or because this file is useless. You can delete it by following the steps below:
- Close database file you would like to delete
- Find location of database file located in hard drive or other storage devices
- Right-click database file
- Click delete or Select database file
- Press Delete Key
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: