Word Main Window | View Function | Enter Text | Navigate Documents | Select Text | Templates | Auto Text| Using Help
Main window | Enter Data | Navigation | Ins Columns & Rows | Del Columns & Rows | Define Range | Sort | Worksheets
Database basics | Database Wizard | Navigation | Switchboard | Enter Data | Modify | Sort | Query | create Report
Main Window | Recurring Appointments | Plan meetings | Create Tasks | Import Contacts | Create Folders
Create a New File | Page setup | Help Files | Using Tables | Rows & Columns | Inserting Word Art | Inserting Clip Art | Using Wizards
Main Window | Auto Content | Templates | View Modes | Edit | Add Illustrations | Add Charts| Add Backgrounds
Computer Terminology Explained | Windows XP Tutorial

Tutorials - Microsoft Access

Use the Database Wizard 

 
Introduction:

When you first open Access, you have the option of creating a blank database, using a database wizard, or opening an existing database. The easiest way to create a database is with a database wizard. Access includes several different database wizards that you can use to help you create the tables, forms, and reports you will need. Choose the kind of database you want to build and follow each wizard step for completing the database structure.

Step 1: Choose a Database

From the New dialog box, look through the wizards on the Databases tab to find the type of database you want to create and double-click the wizard name. To create an asset tracking database, for example, double-click Asset Tracking. Choose a database: Thumbnail

 

 

 

Step 2: Name the Database

Next, name your new database file. Either accept the name supplied by Access or type your own in the File Name text box. Make it something that will be easy to identify the next time you want to use the database. Click Create to continue. 

Name Database: Thumbnail

 

 

 

 

Step 3: Determine the Structure

The first wizard dialog box tells you that you are creating a database. Click Next. The next box has options for the actual structure of your database, including the tables that will be created and the fields to be included. Choose the table from the left and select (or deselect) the fields to use in the right. Click Next. 

Determine structure: Thumbnail

 

 

 

 

Step 4: Choose a Screen Display

The next dialog box offers you several choices of backgrounds for screen displays and forms in the database. Click each name in the list to display the sample background. Choose a background and click Next. 

Choose screen display: Thumbnail

 

 

 

 

Step 5: Choose a Style for Reports

From the next dialog box, choose the style for your printed reports and click Next to continue.

Choose style: Thumbnail 

 

 

 

 

Step 6: Enter a Title

Enter a title for your database (it can be the same or different from the file name used in step 2). Indicate whether to include a picture on all reports. (If you choose to include a picture, you will have to locate the picture file you want to use by clicking the Picture button.) Click Next. 

Enter title: Thumbnail


 

 

 

Step 7: Last Dialog Box

In the final dialog box, you can choose to start the database immediately. Click Finish to create your new database.

Last dialog box: Thumbnail

 

 

About Us | Privacy Policy | Contact Us | ©2004 JB Computers