To move to the previous row in the range or table, click Find Prev.Ĭlick Criteria, and then enter the comparison criteria in the data form.Īll items that begin with the comparison criteria are filtered. To move to the next row in the range or table, click Find Next. To move through 10 rows at a time, click the scroll bar in the area between the arrows.
To move through rows one at a time, use the scroll bar arrows in the data form. Any data that you have typed in the fields is discarded. Note: Before you press Enter, you can undo any changes by clicking Restore in the data form. If a cell contains a formula, the formula result is displayed in the data form, but you cannot change the formula by using the data form.
#DATA ENTRY FROM CREATOR UPDATE#
In a data form, you can enter new rows, find rows by navigating, or (based on cell contents) update rows and delete rows. Each label has an adjacent blank text box in which you can enter data for each column, up to a maximum of 32 columns. The data form displays all column headers as labels in a single dialog box. Microsoft Excel can automatically generate a built-in data form for your range or table. Use a data form when a simple form of text boxes that list the column headings as labels is sufficient and you don't need sophisticated or custom form features, such as a list box or spin button. You may find that using a data form can make data entry easier than moving from column to column when you have more columns of data than can be viewed on the screen. Learn about data formsĪ data form provides a convenient means to enter or display one complete row of information in a range or table without scrolling horizontally. Since the process of designing the form also defines the database, the Form Designer can be regarded as a type of database design environment.When a row of data is very wide and requires repeated horizontal scrolling, consider using a data form to add, edit, find, and delete rows. Epi Info™ 7 handles all of the database management aspects such as the table creation, managing keys, relationships, and other information storage details. If you have access to a Microsoft SQL Server database, Epi Info™ 7 can natively use this format for data storage, instead of the MS Access format. If no changes are made to the default settings when new projects are created, data are stored in the project’s MS Access data file having an “.mdb” extension.
A list of the available field types is shown in the topic on FieldsĮpi Info™ 7 normally uses the Microsoft Access database format.
Field types range from simple labels, text, numeric, and date fields to more advanced fields like drop-down lists, data grids, and command buttons. On each page, one or many data entry fields are added which collect individual data elements.įields added to a page can be any of a variety of field types corresponding to the type of data needed and the kinds of analyses that can be anticipated. Each project can have one or many forms which can have one or many pages. It is where you customize any data validation you want to occur when the form receives data in the Enter tool.ĭata collection in Epi Info™ 7 is organized by projects.
Form Designer is the tool used to design the survey, questionnaire, or form, tailor the data entry process, and specify the tab sequence. In Epi Info™ 7, the Form Designer and the Enter modules work together to design the data entry process and collect data.
0 kommentar(er)
