 Create a table Named Students  Create a form and capture 20 student (Imaginary Students)  Create a query from the table that filters Names of students, Surname and Department  Create a report based on a query from the table that filters Names of

Hi  Asemahle Mbekwa

Based on my testing, here are the steps to create the table, form, query, and report as requested. 

1/ Create the Students table 

• Open Microsoft Access. 
• Create a new blank database. 
• Go to Create > Table Design. 
• Add these fields: 
  • StudentID: AutoNumber
  • FirstName: Short Text
  • Surname: Short Text
  • Department: Short Text
• Select the StudentID row. 
• Select Primary Key. 
• Save the table as: Students

2/ Create the student form 

• In the left Navigation Pane, select the Students table. 
• Go to Create. 
• Select Form. 
• Access creates a form from the Students table. 
• Save the form as: frmStudents 
• Close the form in Design View, save the changes, and then open the form again from the Navigation Pane. 
• Use the form to enter each student record. Leave the StudentID field blank because Access will generate it automatically when StudentID is set to AutoNumber. 

3/ Create the query 

• Go to Create. 
• Select Query Wizard. 
• Choose Simple Query Wizard. 
• Select OK. 
• Choose the Students table. 
• Move only these fields to Selected Fields: 
  • FirstName  
  • Surname 
  • Department 
• Select Next. 
• Select Finish. 
• Save the query as: qryStudentsDept  

4/ Create the report 

• In the left Navigation Pane, select the query: qryStudentsDept  
• Go to Create. 
• Select Report Wizard. 
• Make sure the query is selected. 
• Add these fields: 
  • FirstName  
  • Surname 
  • Department 
• Select Next. 
• Choose any sorting/grouping if required, or skip it. 
• Select a sort order.
• Select a layout. 
• Select Finish. 
• Save the report as: rptStudentsDept 

I hope this provides additional insight 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.