Learning purpose: Learn to use ACCEES database and establish a future guest book database.
First of all, you need to install ACCEES in OFFICE (my demonstration is OFFICE XP version). I won’t talk about the installation process here. After installation, the menu in the figure below will appear.
Click to open ACCEES
Ankong database, create a new database, the file name can be gustbook.mdb, my name is example3.mdb
(For security period, it is better to be more complicated as the ACCESS database can be downloaded!!)
Pictures related to this topic are as follows:
Use the designer to create a new table. There can be multiple tables in a database mdb file.
Pictures related to this topic are as follows:
Fill in the field name and select the field type. A record can have many fields and many field types. The field size means the character tree that this field can accommodate at most. When there is no information in this field, ACCEES will use the default value instead ( No information does not mean empty), generally required fields and allowed empty strings are set to No and Yes respectively to prevent errors.
Pictures related to this topic are as follows:
According to the above picture, you will create several fields. The default value in time is =now(), which means that this field does not need to be filled in, and the system directly replaces the current time.
Pictures related to this topic are as follows:
So after all fields are established, close this window, the system will see the prompt in the picture above, select Yes, the primary key is the record identification. For the sake of simplicity in the future, you can change the number to ID, and try not to express it in Chinese in ACCEES Field name.
Pictures related to this topic are as follows:
Finally, set the name of this table to guestbook, and then double-click to open the table to view the records in the table.
Okay, don’t worry, if this database is useful in the future, don’t delete it.