如何创建Access 2016中类似Students模板的表格式学生列表表单？

Hey there! I’ve helped tons of folks replicate that handy built-in Students form in Access 2016—let’s get your form showing the student list and working for edits/adds in no time.

1. Double-Check Your Form’s Data Connection #

The most common reason your student list isn’t showing is that your form isn’t properly linked to the Students table. Here’s how to fix that:

• Open your form in Design View (right-click the form in the Navigation Pane and select this option).
• If you don’t see the Property Sheet, hit F4 to bring it up.
• Go to the Data tab in the Property Sheet, then look at the Record Source field. It should be set directly to the Students table (or a query that pulls in all the student fields you need).
  • If it’s blank or set to something else, click the dropdown menu and select Students to link it correctly.

2. Switch to a Continuous Form Layout #

The built-in Students template uses a Continuous Form—this lets you see multiple student records in a list while still being able to edit individual entries directly. Here’s how to switch your form to this layout:

• In Design View, head to the Design tab in the ribbon at the top.
• Click More Forms > Continuous Form. You’ll see your form adjust to a repeating row format (each row will hold one student’s info).

3. Add Your Student Fields (With the Right Controls) #

Now make sure you’ve got all the fields you want to display/edit on the form:

• Open the Field List (press Alt+F8 or click the Add Existing Fields button on the Design tab).
• Drag and drop each field (like Name, Level, Email) from the Students table onto your form’s row. Arrange them neatly—this row will repeat for every student in the list.
• For fields like Level, use a Combo Box instead of a plain text box (just like the template!). This lets users pick from predefined options (e.g., "1st Grade", "2nd") instead of typing manually.
  • To set this up: Drag the Level field from the Field List, then follow the wizard. Choose "I want the combo box to get the values from another table or query" (if you have a Levels table) or "I will type in the values that I want" to enter your grade options directly.

4. Enable Add/Edit/Delete Functionality #

Make sure your form lets users modify records and add new students:

• Go back to the Property Sheet’s Data tab, and verify these settings are set to Yes:
  • Allow Edits (lets users change existing student info)
  • Allow Additions (lets users add new students via a blank row at the bottom)
  • Allow Deletions (optional, but lets users remove records if needed)

5. Add Quick-Action Buttons (Optional, But Just Like the Template) #

To make your form as user-friendly as the built-in one, add navigation or action buttons:

• In Design View, go to the Design tab > Buttons. Pick an action like "Add New Record", "Save Record", or "Next Record".
• Follow the wizard to set up the button, then place it at the top or bottom of your form for easy access.

Troubleshooting If Records Still Don’t Show #

• If you’re still not seeing any students, check the Filter property in the Data tab—if it’s set to a specific value, it might be hiding all records. Clear it if needed.
• Make sure the Data Entry property is set to No (if it’s Yes, the form will only show a blank record for adding new students, not your existing list).

Once you’ve gone through these steps, switch back to Form View and you’ll see your full student list. You can edit any field directly (like changing "1st Grade" to "2nd" right in the list) and add new students by scrolling to the blank row at the bottom.

内容的提问来源于stack exchange，提问作者john c. j.