Chapter 2 Creating a New Database

Chapter 2 To create a new database by using the Database wizard

  1. If the New File task pane is not displayed, open it by clicking the New button on the toolbar.

  2. In the Templates area of the task pane, click On my computer, and then click the Databases tab to display the available templates.

  3. Double-click the template you want to use.

  4. Follow the steps of the Database Wizard, and click Finish to complete the process.

Creating Tables the Simple Way To create a table by using a wizard

  1. On the database window’s toolbar, click the New button to display the New Table dialog box.

  2. Double-click Table Wizard.

  3. Follow the instructions of the Table Wizard, and then click Finish to create and open the table.

Refining How Data is Displayed To edit the property settings of a table

  1. Display the table in Design view.

  2. Click in the Data Type cell of the field you want to edit, click the down arrow, and then click the Data Type you want to set for the field.

  3. In the Field Properties area, click the General or the Lookup tab, click the property you want to edit, and enter the property, or select the property from the drop-down list of options.

Manipulating Table Columns and Rows To size a column to fit the longest entry

  • Point to the vertical bar between the column headers, and double-click.

Manipulating Table Columns and Rows To change the height of all rows in the table

  • On the left side of the datasheet, drag the horizontal bar between any two record selectors up or down.

Manipulating Table Columns and Rows To return the height of all rows to the default setting

  1. On the Format menu, click Row Height to display the Row Height dialog box.

  2. Select the Standard Height check box, and then click OK.

Manipulating Table Columns and Rows To hide a column

  • Click in the column, and then on the Format menu, click Hide Columns.

Manipulating Table Columns and Rows To restore a hidden field

  1. On the Format menu, click Unhide Columns to display the Unhide Columns dialog box.

  2. Select the check box of the field you want to display, and then click Close.

Manipulating Table Columns and Rows To freeze columns

  • With the columns selected, on the Format menu, click Freeze Columns.

Manipulating Table Columns and Rows To unfreeze columns

  • With the columns selected, on the Format menu, click Unfreeze All Columns.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset