New in "Access2003" table, query with SQL statement, turn off warning message, modify database password, repair database

First, the new table

Open Access2003 only one database controller, choose to create a table using the designer, you can graphically set the

Right-click a field to set the primary key

After you have finished all the fields, press Ctrl+s to save the

You may find that you have one more table in the database controller. You can edit it like Excel. You can also control an Access database in ASP.

Second, the table query

Select the query item in the database controller, select Create query in Design view, select Close in the Pop-up dialog box, and then right-click in the blank gray area. Select SQL view. You can use SQL statements to control the ACCESS2003 database.

Three, every open Access2003 have a bunch of warning questions

After entering Access2003, select "Tools", "Macros", "security" to set the minimum security, there will be no more warnings. Databases are built on their own, how can it be unsafe?

Iv. Modifying the password for the Access2003 database

Also in the Tools menu security can modify or revoke the password of the database

V. Compress and Repair databases

When your Access2003 is Access2007 turned around, or has undergone a copy process, you'd better compress and fix the database as shown in:

New in "Access2003" table, query with SQL statement, turn off warning message, modify database password, repair database