The record will now be selected in the worksheet window. In the Find what text box, type the information that you are searching for.
The record is deleted and rows beneath that row move up. Press + click the record number » Delete. On the left-hand side of the record, click the record number.
In your database, scroll to the record that you would like to delete. WARNING: By deleting a row, the entire contents of the row will be deleted. Use the arrow keys to move to the next field of the record. Adding a New RecordĬlick the field in which you would like to start entering your data. If you need to make a few minor changes to the information in your database, sometimes it is quicker to make them through the worksheet window. Within the appropriate field(s), type the desired search criteria. To ensure that you search the entire database, move to either the first or last record of the database (use the scroll bar). To select the existing record you want to delete, click and hold the scroll bar dragging up or down. The new records are added to the end of your database. When you have entered the last record, click Close. WARNING: If you press or after you have typed the field information, the data will be added to your database and you will automatically go to a blank form to start a new record. In each field, type the desired information.
The form will be cleared and ready for you to enter data. Place the cell pointer within the database.Ī dialog box displaying the sheet name appears. The first row must be completed with the column labels (i.e., the field names). NOTE: You cannot start from a blank worksheet. The Find Next and Find Prev options make locating a specific record easier. The Forms feature is also helpful for searching for a record. When a record is added, Excel automatically clears the form and is ready for you to enter the next information. Excel has an easier way of entering data called the Forms feature.įorms allows you to switch from field to field in your record by pressing. You often have to move the cursor around the page and waste valuable time. In a database, these are called fields, records, and field names, respectively.Įntering a lot of database information to the worksheet can be time-consuming and inefficient. A worksheet is made up of columns, rows, and column labels. These functions, such as finding, sorting, or subtotaling, can make organizing and analyzing your information easier. Creating a DatabaseĮxcel recognizes lists of information as a database when the database functions are used. For more information on entering values and text, refer to Getting Started with Excel. If a number is treated as "text," you cannot use the number in mathematical formulas (e.g., SUM and AVERAGE). To enter a number as text, precede the number with an apostrophe or format the necessary cells as text.
Numbers will be counted first when using the analysis functions. Make sure you enter numeric data as numbers or all text. Blank rows will cause only the part of the database above the empty portion to be selected when using the database analysis functions (e.g., dsum, dcount, and sort). Tips for Setting Up a Databaseīe sure not to leave any blank rows in the middle of the database. This document presents the basics of working with an Excel database. This article is based on legacy software. (Archives) Microsoft Excel 2007: Database Basics
0 kommentar(er)
