![]() You will see from the fields included, that there is a field detailing when the Student Enrolled on the course (dtmEnrolled). The original StudentInformation table, containing 52 records, would look like the following:Īs you will see, the above table contains contact information relating to the student members. If you have read the previous article that detailed How to Append records using a Microsoft Access Append Query you should be aware of the following: You would like to remove any records from this table that are not of current students, so you will archive records by initially appending the data from your StudentInformation table into another table (ExpiredStudents) and then deleting these records from the StudentInformation table. All of this information relating to their details is stored in your StudentInformation table. Your company runs training courses, with students signing up for these courses. Now consider the following scenario example, that will illustrate the use of a Microsoft Access delete query:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |