How to Create an Organiser Using Microsoft Access
Microsoft Access is a database management program that is designed to be relatively simple to use so that people without database experience can quickly and easily create and use databases. Microsoft Access comes installed with a number of sample databases that you can use as a starting point when creating your own database applications. It also allows you to customize and organize your database as much as you need to meet your own needs.
Other People Are Reading
Instructions
-
-
1
Start Microsoft Access. Go through the Start Menu, select "Microsoft Office," then select "Microsoft Access 2007." When you start Access, you will start with a menu screen titled "Getting Started with Microsoft Office Access."
-
2
Determine what type of things you will be organizing. As you can see from the screen, you can organize a number of samples of categories from assets to students. If the items you wish to organize do not appear on this menu, find one that is close to the items you want to organize. For example, if you want to organize your CD collection, you can use the assets category. The menu on the left side of the screen will give you more options of categories as well.
-
-
3
Click on the category you wish to use. When you do so, the right side of the screen will load with a few buttons and options. It will also include a short description of the type of database you are creating. You can check the descriptions of different categories by reading this section of the screen when you click on different categories in the main window.
-
4
Name your database. In that right window pane there is a box with a name for your database. It will start with a default name that matches the category, but you can type your own, more descriptive name for your database in that box so you will be able to find your database later from other locations like "My Computer."
-
5
Determine the location for your database. Just below the box discussed in Step 4 is the file location of the database you are creating. If you want the database stored in a different location, click the open folder to the right of the box and select another location.
-
6
Click the "Create" button. Microsoft Access will take a few moments to create all the objects and parts of your new database, and then will open the database, ready for your use. With most categories, it will load menus, tables, queries and reports for you. Just explore all the items that have been added, and start adding your information into the database.
-
1
Tips & Warnings
Try out different samples and explore. You cannot hurt the database by clicking to see what things will do.
