Description: 1) create a database using Access 2003 Student.mdb, in the database to create three tables tabStudent, tabCourse, tabScore, each table as the reference structure, and design links between the three tables and referential integrity.
2) in each data table, enter the necessary test data.
tabStudent table at least 10 students to enter the basic information
tabCourse table at least 4 courses of the data input
tabScore table for each student to enter at least two courses results
3) complete the following design:
create three forms, one for input, modify, establishment of three queries,
can learn for inquiry by the basic information students require fuzzy query, student number must be dynamic input
Remove the above three tables of data
birth date range queries by the students basic information, enter the date range must be dynamic
a student by student number query results, the results for the student
To Search:
File list (Check if you may need any files):
student.mdb
2011级大学计算机基础.doc
Download