Carlow Home
   
Access QuickTips
- Create a Database Using the Database Wizard
- Create a Database Without Using a Wizard
- Display or Change the General Properties of a Database Object - Create a Table Using the Wizard
- Create a Table From Scratch Using Design View  
     
   
Create a Database Using the Database Wizard
 

1. When Access first starts up, a dialog box is automatically displayed with options to Create a New Database or Open an Existing One.

2. Select Database Wizard and follow the instructions.

3. If you have already opened a database or closed the dialog box, click File on menu bar and select New Database.

Back to top  
     
   
Display or Change the General Properties of a Database Object
 

1. In the Database window, select the object (the database itself or one of its components) whose properties you want to change.

2. Click File, click Database Properties, select Author, Manager, Company, Category, Keywords, Comments, Hyperlink base.

3. Click OK.

Back to top  
     
   
Create a Table From Scratch Using Design View  
  1. Switch to the Database window.

2. Click the Tables tab, then select New button.

3. Select Design View.

4. Define the Field Name, Data Type, and Description for each field in your table.

Note: It may prompt you to create a primary key. This is fine. Simply click yes and save your table.

Back to top  
     
   
Create a Database Without Using a Wizard  
 

1. Instead of selecting Database Wizard, select Blank Database.

2. Specify a name in File name: area for the database then choose the drive or folder where you want to save the file from Save In: folder list, click Create.

Back to top  
     
   
Create a Table Using the Wizard  
 

1. Switch to the main Database window (contains the Tables, Queries, Forms, Reports, Macros, Modules for the database).

2. Click the Tables tab, and the select New button.

3. Select the Table Wizard.

4. Follow the directions in the Table Wizard dialog boxes.

Back to top