Enter the Student IDs Quickly

1. Type the first two ID’s, ST348-245 and ST348-246, into cells A5 and A6, respectively.
2. Highlight the two ID’s to select them.
3. Drag the  to cell A13.

The rest of the Student ID’s are entered into cells A6 to A13 correctly

Enter Data Correctly

When entering the data, it is important to ensure that it is entered correctly. Other than row 2 between the spreadsheet title and the column headings, do not leave any other blank rows when entering your data. Also, make sure that you don’t leave any empty cells.

 caused by incorrect data entry are the source of many problems related to data management. If the data is entered correctly initially, the program is more likely to give you back the results you want.

Rows Are Records

Each row of data in a database is known as a record. When entering records, keep these guidelines in mind:

• Do not leave any blank rows in the table. This includes not leaving a blank row between the column headings and the first row of data.
• A record must contain data about only one specific item.
• A record must also contain all the data in the database about that item. There can’t be information about an item in more than one row.

Columns Are Fields

While rows in an Excel database are referred to as records, the columns are known as fields. Each column needs a heading to identify the data it contains. These headings are called field names.

• Field names are used to ensure that the data for each record is entered in the same sequence.
• Data in a column must be entered using the same format. If you start entering numbers as digits (such as 10 or 20), keep it up. Don’t change partway through and begin entering numbers as words (such as ten or twenty). Be consistent.
• The table must not contain any blank columns.

Create the Table

Once the data has been entered, it can be converted into a table. To convert data into a table:

1. Highlight the cells A3 to E13 in the worksheet.
2. Select the Home tab.
3. Select Format as Table to open the drop-down menu.
4. Choose the blue Table Style Medium 9 option to open the Format as Table dialog box.
5. While the dialog box is open, cells A3 to E13 on the worksheet are surrounded by a dotted line.
6. If the dotted line surrounds the correct range of cells, select OK in the Format as Table dialog box.
7. If the dotted line does not surround the correct range of cells, highlight the correct range in the worksheet and then select OK in the Format as Table dialog box.

Drop-down arrows are added beside each field name, and the table rows are formatted in alternating light and dark blue.

Use the Database Tools

Once you have created the database, use the tools located under the drop-down arrows beside each field name to sort or filter your data.

Sort Data

1. Select the drop-down arrow next to the Last Name field.
2. Select Sort A to Z to sort the database alphabetically.
3. Once sorted, Graham J. is the first record in the table, and Wilson R is the last.

Filter Data

1. Select the drop-down arrow next to the Program field.
2. Select the checkbox next to Select All to clear all check boxes.
3. Select the checkbox next to Business to add a check mark to the box.
4. Select OK.
5. Only two students, G. Thompson and F. Smith are visible because they are the only two students enrolled in the business program.
6. To show all records, select the drop-down arrow next to the Program field and select Clear Filter from “Program.”

 

Expand the Database

To add additional records to your database:

1. Place your mouse pointer over the small dot in the bottom right-hand corner of the table.
2. The mouse pointer changes into a two-headed arrow.
3. Press and hold the right mouse button and drag the pointer down to add a blank row to the bottom of the database.
4. Add the following data to this new row:
   Cell A14: ST348-255
   Cell B14: Christopher
   Cell C14: A.
   Cell D14: 22
   Cell E14: Science

 

Complete the Database Formatting