How Do I Start an At-Home Data Entry Business?

The home database is a carrier for storing materials, knowledge, working files, audio and video programs, and the cornerstone of supporting home multi-media platforms.

Home database

This entry lacks an overview map . Supplementing related content makes the entry more complete and can be upgraded quickly. Come on!

The home database is a carrier for storing materials, knowledge, working files, audio and video programs, and the cornerstone of a home multi-media platform.

Chinese name

Home database

Explanation

Store information, knowledge, work files

Types of

Multi-media platform

Pinyin

jiatingshujuku

In order to manage various types of information in the home, it is necessary to first establish a home database structure in a computer. The structure of a relational database is very simple. It is composed of data files, and each data file is equivalent to a two-dimensional table. Each form is filled with a type of data, and the relationships between each form are established by common data items to form a database that includes all aspects of data. ^[1]

For modern families, all aspects of information need to be managed. There can also be a variety of database files. For example: family financial management, family address book, commodity information, stock quotes, college entrance examination information and so on. In the following, we only take the home address book database as an example. Discuss how to create a database file.

First, draw tables one by one to establish the database structure

Before creating a database, you should first design the structure of the database table, that is, determine the header of this two-dimensional table. There are several entries, each entry name, what data type is in the entry, and how many character positions it occupies.

For example: we want to create a database file named: (Address Book. DBF). This includes the following: name, work unit, date of birth, age, title, address, phone number, and notes. These contents are in a two-dimensional table'each table entry, called a data item, also called a field. Each field type should also be specified. For example, the name and address are character type; the age is numeric type. Due to the variable number of words in the remarks field, it can be specified as a detailed type, and the date of birth should be a date type.

As for the width of each field, it should be noted that a Chinese character is equivalent to two Western characters. Therefore, considering the existence of a double surname, the width of the name can be 8; the unit may require ten Chinese characters, so the width of the field can be 20 bits. Numeric fields occupy a single digitthe decimal point must also occupy a single character position. Since the age field is all integers and does not exceed 100 years of age, a two-digit width can be used. Remarks are detailed fields. The width of the field is fixed and is 10 digits. In fact, it can store content that does not exceed 4096 characters.

Assume that the home address database <address. The structure of DBF> has been determined. The data structure of each data item is defined as follows:

1) Name character width 8

2) Unit character width 20

3) Date of birth date type width 8

4) Age number type width 2

5) Post character type width 8

6) Address character width 20

7) Phone character width 12

8) Please note the fine width 10

This is equivalent to drawing the header of a two-dimensional table, which has the form shown in Table l.

Name	unit	date of birth	age	Position	address	phone	Remark

After completing the database structure design, you can use dBASE III commands to build a database on your computer. Enter the dBASE state, the . Prompt appears on the screen, type the command:

CREATE B: Address book. DBF

CREATE is a command to create a database. The commands of dBASE can only input the first four letters. So you can also enter CREA instead. Then enter the file name of the home address book. After executing this command, the name <address book is created on the disk. DBF> data file. It is best to use the Chinese pinyin for the file name, which is more convenient for each use in the future. For example, using TXL instead of the three Chinese characters in "Address Book" makes inputting a lot easier. DBF is a file extension. It is fixed to data files by dBASE and indicates the file type. Can't be changed to something else.

After the above command is executed, the screen displays:

B: Address book. DBF

field name type width dec

l char / text

The first field (field) is a field number, which is automatically generated by the computer, and is automatically incremented by one each time a line is entered. name is the name of the field to be filled in by the user; type is the data type; width is the width of the field; dec is the position of the decimal point; if it is a numeric field, it must be filled in. At the beginning, the cursor is at the name position. After you fill in "name" and press Enter, the cursor moves to the type position. There is a prompt at this position: "char / text ', which means a character field. Now the name is a character field, so Hit enter, and the cursor jumps to width. If it is not a character field, press the space bar, and each time it is displayed in turn at the type position; Num (numeric type), Date (date type), and Mem (detail type) are for your choice. When a certain type is displayed, press the Enter key, the type is defined. Enter the field width in the width position, such as the name field is 8, type "8" and press Enter, the cursor will move to the next line, waiting for your input Definition of the second field. If the field is a numeric field, the cursor will move to the dec position after the width is defined. Please enter a few decimal places.

In the above way, you can enter the definitions of field names, types, widths, decimals, and so on in sequence. When all eight fields of a database file are defined, the cursor jumps to the ninth item position. At this time, press the key combination Ctrl + W, the screen prompts: Hit RETURN to confirmanykey to Resume

Press the Enter key to store the newly defined database structure (that is, the header of the two-dimensional table). If you press other keys, you can re-display the just-defined structure screen. You can use the cursor movement keys to move the cursor to the place where you just entered an error and make changes. After modification, use (ESC) key to exit.

Second, fill in the form-enter data into the database

Entering data into a completed database is like filling out a form. Entering data into a newly built database seems to be filling out a blank form. There are several ways to add new records to a database that already has some data. For example, add (APPEND) to the back of the form, insert (1NSERT) into the middle of the form, and modify and delete the stored records.

1. Initial input after building the library structure with the CREAT command

After the CREAT command is used to build the library structure and use Ctrl + W to end the library building, and choose Enter, the screen displays: Input data record now (Y / N)

If you press N, the computer returns to the "." Prompt of dBASE. You can execute other dBASE commands, such as building the next database.

If you press "Y", the screen displays the name of a form content item just defined, please fill it in order. That is, starting from the first line of the form, filling out the form column by column.

Re. rd NO 1

Name

unit

date of birth//

age

Position

address

phone

Notes Memo

You can fill in the contents of each data item (field) in sequence. After completing each item, press Enter to end, the cursor automatically jumps to the next item, you can continue to enter the content of the next data item field. After all input is completed Form one row. Press the Enter key, the screen will display each data item of the next record, you can continue to enter, that is, fill the next line of the form.

2. There are several points to note when entering data:

(1) Except for the M field, the input content width can only be the width set when the data is defined. Once the set width is reached, the cursor spatters on the next segment, but if the input content does not reach the defined field width, you can Enter key ends.

(2) M-type field input method is: when the cursor is under Memo, press the Ctrl + PgDn key combination, the system will display a blank screen, the upper display:

DBASE WORD PROCCESSOR

You can enter a piece of text as the content of the Memo field in a full-screen editing mode similar to WORDSTAR. The number of words must not exceed 4096 bytes, that is, 2048 Chinese characters. After inputting, press Ctrl + W, the computer returns to the screen for inputting data records, and can continue to enter other fields. The Memo field entered at this time is stored in the directory called Address Book. DBT file. This file is automatically generated by dBASE when you use the memory field in a database. The file name is the same as the main file and the extension is. DBT.

When all records in a database have been entered, enter the last field of the last record and use Ctrl + W to end the input status and return to the dBASE prompt. Or when a blank record appears, press Enter to exit the input state.

If a total of five records are entered during the first entry, the database contents entered are shown in Table 2.

Record #	Name	unit	date of birth	age	Position	address	phone	Remark
1	Wang Shan	Beijing University	06/03/44	49	Associate Professor	Peking University 68--15	8214532	Memo
2	Li Yi	Beijing University of Aeronautics and Astronautics	05/16/53	40	engineer	Beihang 45--2-3	4965321	Memo
3	Liu Liu	Qinghe Wool Spinning Factory	02/22/60	33	worker	Beihang 36--13	285211	Memo
4	Li Wei	University of Geosciences	07/07/73	20	student	Earth University 27--21	2595361	Memo
5	Li Yanping	Beijing industry university	01/30/75	18	student	Beijing University of Technology 35--25	8806245	Memo

Third, fill in the form-add records to the database

The content of a database cannot be entered all at once, and needs to be continuously increased. For example, if you meet a new friend, and you want to add his address to the address book, you need to add a new record to the database. Therefore, for databases that already have data, you need to add them frequently, just like adding a new row to a two-dimensional table. The format of the command for adding records is as follows:

APPEND [BLANK]

[] Means: the content of [] in the command may or may not be present.

There are a few things to note about this command:

(1) Before operating a database, you should first open the database. The meaning of "open" is like we need to modify an article. We must find and open it from the bookshelf before we can start adding and modifying. The command to open the database file on the disk is: .USE <file name> <> The content in the command is required, and it is filled in according to the <> instructions.

After opening a file, all subsequent operation commands are performed on this file. If you want to use another file, you need to execute another open file command, and the original open file is automatically closed.

So to add a record to the address book, two commands should be executed:

This command means to add a new record after the original records in the database.

If the APPEND command is followed by a BLANK parameter, a blank record is automatically added. In the future, you can enter data by other methods. If there is no parameter, the screen displays a data record structure. Please fill in:

Record NO 6

Name

unit

date of birth//

age

Position

address

phone

Memo

Since there are already 5 records in the original database, record number 6 is displayed, and adding is started from the sixth record. The method is the same as the input method when building the database. After each record is entered, the next blank record is automatically displayed, and you can continue to enter. If you finish typing, you can enter the Enter key when a blank record is displayed, or press Ctrl + W while typing.

If at this point you fill in two new records:

Record #	Name	unit	date of birth	age	Position	address	phone	Remark
6	Zhang Sanfeng	Second Machine Tool Plant	01/17/59	34	worker	Earth University 48--41		Memo
7	Li Li	Beijing company	03/15/50	43	lecturer	17--15	8864521	Memo

There are already 7 records in the address book database.