Monday, July 28, 2014

How To Creating a Database Using a Wizard in Access 2003

How To Creating a Database Using a Wizard in Access 2003


You can use a wizard to create a database, or you can create a custom database from scratch. The Access database wizards help you create databases suited to your specific needs. Each wizard guides you through the process of selecting and creating fields, tables, queries, reports, and forms, which makes it easier to use the database. When you create a database, you need to assign a name and location to your database, and then you can create the tables, forms, and reports that make up the inner parts of the database.

Create a Database Using a Wizard

graphics/1_icon.jpg
Click the New button on the Standard toolbar.
graphics/2_icon.jpg
Click On My Computer.
graphics/3_icon.jpg
Click the Databases tab.
graphics/4_icon.jpg
Click the database wizard you want.
graphics/5_icon.jpg
Click OK.
graphics/6_icon.jpg
Click the Save In list arrow, and then select the location where you want to save the new database.
graphics/7_icon.jpg
Type in a name for the database, and then click Create.
graphics/02inf21.jpg

Did You Know?

The default file format is Access 2000. For maximum compatibility with existing databases, the default file format for new databases created with Access 2003 is Access 2000.


See Also

See "Converting Access Databases" on page 268 for information on changing the default file format and converting databases.
graphics/8_icon.jpg
Read the introduction, and then click Next to continue.
graphics/9_icon.jpg
Click a table to display the fields in the table, select the check boxes with the fields you want, and then click Next.
graphics/10_icon.jpg
Select the style you want to use for screen displays, and then click Next.
graphics/11_icon.jpg
Select the report style you want, and then click Next.
graphics/12_icon.jpg
Type a name for the database, and then click Next.
graphics/13_icon.jpg Click Finish.
Access creates the database based on your responses to the wizard. Enter any additional information requested during the final process.
When Access finishes creating all the database objects, the Main Switchboard appears, where you can use the database.
graphics/02inf22.jpg