The third day of the 10-Day learning ASP

Learning Purpose: Learn Accees DatabaseThe use of, and build a future to use the guest book Database。
First of all, you want to install Office Accees (my demo is Office XP version), the installation process is not said here, the installation will appear in the next picture of the menu.

Single hit Open accees

Anring Database , create a new database , file name can be called Gustbook.mdb, my name is Example3.mdb
(in order to be secure, the filename is a bit more complex because the Access database can be downloaded!!) ）

To create a new table using the designer, you can have multiple tables in a database mdb file

Fill in the field name and then select the field type, a record can have many fields, can have many field types, the field size means that this field can hold the most words descriptor, when this field does not have any information is, Accees will replace with the default value (no information is not empty meaning), General required fields and allow empty strings to be set to no, yes to prevent errors

According to the above figure, we set up several fields, in time the default value is =now () Is this field does not need to fill in, the system directly to the current time instead

So the field is established, close this window, the system will appear on the diagram, the choice is, the primary key is the record of the logo, in order to be simple, we can change the number to ID, and in the accees as far as possible not to use Chinese to represent the field name

Finally, set the name of the table to guestbook, and then double hit the table to see the records inside the table

OK, everyone, don't worry, this database is useful later, we do not delete.