Getting Started with ASP (ii)-Creating an Access database

In general, ASP programs are used with an Access database, so after installing an ASP environment, we also need to install an Access database to facilitate the establishment and management of databases.

Access is a member of the Microsoft Office Family and provides a lightweight database solution.

I am installing an Office version of Access(sw_dvd5_office_professional_plus_2013_64bit_chnsimp_mlf_ x18-55285. ISO), with the highest prevalence of Office 2003, if you use XP or Win7, it is recommended.

Create an Access database and data table

In Access, a file represents a database, so to create a new database, all we have to do is create a new Access file.

Step1, open Access2013, select "Blank Desktop Database"

Step2, set the file name and directory in the popup dialog, here we select "F:\JJ\Book.mdb".

There are a variety of database formats to choose from, and we have selected an older version of MDB format (2002-2003 format), such as:

Step3, after setting up the database file, there is nothing in this file, it is an empty database. Access2013 version of the operating interface and Access2003 the difference is very large, the operation is more convenient, first rough introduction of the various parts of the window, the specific use please Baidu.

Step4, OK, next we'll use the Table Designer to create a data table book. Select Create | table design , such as:

Step5, we set up a book table, table A total of five fields, respectively, BookID(AutoNumber, primary key),bookname(text),Bookprice (double-precision numbers),bookpubdate(datetime), and bookclick(integer numbers), such as:

The icon for a small key in front of the BookID field is the primary key (unique in the table and not duplicated).

Step6, at this point, our table design is complete, "Ctrl + S" Save Our table, Pop-up dialog box, we enter the tablename "book".

Getting Started with ASP (ii)-Creating an Access database