Choosing How to Create Your Database

Team-Fly    

 
10 Minute Guide to Microsoft Access 2002
By Joe Habraken
Table of Contents
Lesson 3.  Creating a New Database

Choosing How to Create Your Database

Before you can create your database tables and actually enter data, you must create a database file. The database is really just a container file that holds all the database objects, such as the tables, forms, and reports . You also have two options for creating a new database: You can create a blank database from scratch or create a new database based on a database template.

Creating a new database based on a template means that you take advantage of the Database Wizard, which not only creates your new database file but also helps you quickly create tables, forms, and other objects for the database.

Plain English

Database Wizard Access provides several templates for creating new database files, and the Database Wizard walks you through the process of creating objects, such as tables, for the new database.


Whether you create your new database from scratch or use one of the database templates depends on how closely one of the Access templates meets your database needs. If one of the templates provides you with the type of tables and other objects necessary for your project, it makessense to use a template. For example, if you want to create a database that helps you manag can take advantage of the Inventory Control templa-----te that Access provides. This template provides you with the basic tables and other objects to start the process of getting a handle on your inventory database.

In some cases, the templates might not meet your needs. For example, if you want to create a complex database that allows you to track sales, customers, and employee performance, it might be easier to create a blank database and then create each table for the database from scratch. Let's start the overview of database creation with creating a blank database.


Team-Fly    
Top
 


10 Minute Guide to Microsoft Access 2002
10 Minute Guide to Microsoft Access 2002
ISBN: 0789726319
EAN: 2147483647
Year: 2000
Pages: 160
Authors: Joe Habraken

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net