Exploring Access 2007 - Database Categories
(Page 3 of 4 )
A variety of database categories are available as templates. Companies can use their own staff to set up some custom applications using these templates. A large selection of templates covering a wide range of business needs are available at the Microsoft office online, from where they can be brought into the application as shown in the next picture. The following are some of the templates available:
- Accounting and Finance
- Assess and Inventories
- Budgeting
- Education
- HR
- Marketing
- Project and Tea Management
- Sales
In this screen you may also create a new database by clicking on the Blank Database icon in the middle window. In the open recent database window a list of recently opened databases will be shown. I created a database and afterward deleted the same, but somehow the program refused to update this information (first figure). The database was even deleted from the Recycle Bin. You may also see the new file extension, Database1.accdb (the three letter file extension mdb is gone).
Creating a new blank database
Click on the Blank database icon in the middle of the screen in the main window. This opens the following window.
The database name is changed to TestDec2006 as well as its default folder. In my previous computers the database icons blew up the My Documents folders to the point that scrolling was a problem. This time all Microsoft Access Databases will go into a single folder, AccessDataBases as shown.
When you save the database with a name, and after indicating a folder, it opens with this default view with Table1 as shown here.
This is a re-sampled version of a large screen, but even so, Microsoft's screen designers have done a good job of cramming a lot of functionality into an easily resizable screen. The TestDec2006 database took only 234 KB of memory (96 KB in Access 2000).
Next: Screen shots of the Ribbon >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 4 
