Access questions, thank you, access questions and answers

Seeing this, it means that you have been able to complete an access database independently, but in the work, you also need to pay attention to these problems, which is easy to ignore.

When your database crashes with any of your simple operations, the database can be corrupted. To solve this problem, we need to fix this database.

To repair a database, you first ask to open the database as an administrator if the database is closed by another user, then click the Tools menu, then point to Database Utilities, and click the Compact and Repair Database command. Access will do the work automatically.

On this command, there is also a "Compress" operation, when we delete a form or report, access does not return the space they occupy, and to use this part of the space, you must use the "Compress" operation.

You can set the form properties.

2.Try previewing and setting the paper size.

3.The easy way to do this is to open Excel and then the Access file. Or choose it from the menu'Export to excel format.

4.FoxPro is good, you can try it. To repair a database, you first ask to open the database as an administrator if the database is closed by another user, then click the Tools menu, then point to Database Utilities, and click the Compact and Repair Database command.

Access will do the work automatically.

1.You can set the form properties.

2.Try previewing and setting the paper size.

3.The easy way to do this is to open Excel and then the Access file. Or choose it from the menu'Export to excel format.

4.FoxPro is good, you can try it.

1.You can set the form properties.

2.Try previewing and setting the paper size.

3.The easy way to do this is to open Excel and then the Access file. Or choose it from the menu'Export to excel format.

4.FoxPro is good, you can try it.

To repair a database, you first ask to open the database as an administrator if the database is closed by another user, then click the Tools menu, then point to Database Utilities, and click the Compact and Repair Database command. Access will do the work automatically.

1.You can set the form properties.

2.Try previewing and setting the paper size.

3.The easy way to do this is to open Excel and then the Access file. Or choose it from the menu'Export to excel format.

4.FoxPro is good, you can try it.

You can try the landlord's method.。。。 You don't know until you've tried it yourself...

1. I'm a little skeptical of your question, I've been studying for so long and I don't know that tables can be saved as forms.

2. You can adjust the page settings.

3. I haven't tried it.

4. It's easier for you to use access.

Question (1) To record students' grades, of course, you have to register the scores, first of all, there must be a field to record the "score", and secondly, the score must be recorded in the name of each student, and the field that uniquely identifies each student can be found in the "Student Information Table", that is, the "student number" closes early, and the score also corresponds to the course, and the "student curriculum" has the course identification column "course number". Therefore, the table for recording students' grades should be structured as follows (basic).

Student Transcript (ID Auto Number, Primary Key, Student ID, Text, Course Number, Number, Score Number).

Field description: id "In principle, each table should have a primary key to uniquely identify each record row, in fact, the student number, course number, and score in the grade table may be duplicated, and it is a natural choice to add an automatic number primary key;

The field types and sizes of the "student number" and "course number" should be consistent with the fields with the same name as the corresponding data tables, so as to establish the one-to-many referential integrity relationship between them.

In order to facilitate the number calculation, the data type of the "fraction" field should be a number, if it is not necessary to be accurate to the decimal point, you can choose "long positive", otherwise you can choose "single fine", etc.

Question (2) The function of this query is to list the student number, name and gender of the male student with the surname Zhang.

Corresponding SQL statement:

Select Student ID, Name, Gender from Student Information Form.

where name like"Zhang*"and gender="Male";

Three ways:

Directly add or delete data in a table.

Verify the retrieval using the macro method.

Use the VBA module to do this.

The simplest number is to set the form data source as a wine sales record, then set the text box and drop-down list data source on the form as a field, and then go back and set the form to data entry mode, and the confirmation button is created with a wizard, which is to add a new record function. You should know how to do this step, and then connect the wine sales record and the wine inventory to the right query, and use the wizard as follows:

Count the total number of sales quantities, and then connect the table after querying statistics and the inventory quantity table, and subtract the two quantities to be the number of savings in inventory.

Verification with macros is one of the best ways to access, and you have to create three macros: 1Add a data macro 2Check the data macro 3Write off the data macro, in the macro SQL statement is very important, the data you enter in the table must be checked with the data in the inventory table.

Using VBA is the safest practice, because VBA can verify your input, and then organize the data in the table, I will send you an example of VBA, and you can learn the rest yourself, it should be said that it is relatively simple.

The database sent a copy to try it out.

In the confirmed click event write, manipulate the access database.

The first is 15, and the second is 20

The formula rear-front + capacity = 10-45 + 50 = 15

The stack calculation formula is bottom-top+1=49-30+1=20

For beginners to accesss, it is recommended to use the bind data table form to insert data into the table, which is the easiest to use. When you need to insert data into the binding form, you only need to click the "*" sign in the navigation button, and then enter the data directly in the binding control of the form, and all the data maintenance and validity rules, constraints and data integrity checks behind the data table will be automatically completed by the system without human intervention.

Of course, sometimes we will ask the form to have a more flexible way of data entry, and we can use VBA** to insert data into the data table, but this method requires the programmer to have a considerable level of knowledge of the database, which will be more complicated to deal with. If the landlord is interested, you can take a look at my following, where there are detailed example answers and treatments**.

Form design view.

Form view. <>

The access version is wrong?

If the file is corrupted, you may wish to create a new access file, and then import the access ** back in the form of an import table.

Try!

You're asking questions in such a general way, and you don't know how you can fit your needs .........At the very least, you should give an example of your requirements based on your specific situation!

Generally, you need to input data into the data table, directly associate the data source of the form with the data table, and each corresponding control is also bound to the corresponding field, as long as the data is entered, you can do not need additional .........

For beginner database friends, it is not recommended to use ** to operate at the beginning, and should start with the basic functions to learn!