Learning objectives: Learn to use the Accees database and create a database of guest books to be used in the future.
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
An empty database, 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!!) )
The relevant pictures of this topic are as follows:
To create a new table using the designer, you can have multiple tables in a database MDB file
The relevant pictures of this topic are as follows:
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
The relevant pictures of this topic are as follows:
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
The relevant pictures of this topic are as follows:
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
The relevant pictures of this topic are as follows:
Finally, set the name of the table to guestbook, then double hit the table, watch the record inside the table 3b
OK, everyone, don't worry, this database is useful later, we do not delete.