Use the Microsoft access 2016 student database free Student database template to keep track of information about your students, including emergency contacts, medical information, microsoft access 2016 student database free information about their guardians.
You databaee also search and filter students, track student attendance, show or hide columns, and map student addresses. Want to watch a video about using this template? See this article, Use the Students Database Template. Note: The Students database template has been updated over the last few years.
These instructions refer to the latest version of the template available for download. If the steps below don't match what you're seeing, you're probably using an older version of the template. When you first open the database, Access displays the Welcome form. To prevent this form from displaying the next time you open the database, clear the Show Welcome when this database is opened check box. To make sure all the database content is enabled, in the Message Bar, click Enable this content.
For more information about enabling database content, see the article Decide whether to trust a database. The Quick Search box lets you quickly find an student on the Student List form. Access filters the list cacess show only those records that contain the text you searched for.
To return to the full list, click Clear the current search. It's the X inside the search box. On the Student List form, you can filter the list of students, and save your favorite filters for future use. On the Filter Details form, enter a filter name and description, and then click Close. Use the Filter Favorites box to apply a saved filter, or click Clear Filter to remove the filter. Xccess the Student List form, some fields columns are hidden by default.
Microosft change which fields are displayed:. In the Unhide Columns dialog box, select the check box beside each column that you want to show. Clear the check box to hide the column.
The Student Details form lets you microsoft access 2016 student database free and enter more information about microsoft access 2016 student database free student, including pictures, guardians, emergency information, and attendance. To microsoft access 2016 student database free the Student Details form:. On the Student List form, click Open next to the item that you want to see. Note: You can attach multiple files for each item, including different file types such as fgee or spreadsheets.
If you use Microsoft Outlook, you can add students from that program without having to re-type the information. In the Select Rree to Add dialog box, select the names that you want to add to the database. On the Student Details form, if you have entered a street address for the student, you can display a map of that location:. To display a report:.
In the Navigation Pane, under Reports microsoft access 2016 student database free, double-click the report you want to display. You can create your own custom reports. For more information, see the article Create a simple report. You can customize the Students database by adding a new field to the Students table, and then adding that field to the Student List form, the Student Details form, and the All Students report. Scroll to the right until you see the column named Add New Field.
Double-click the column heading, and type in the field name. Right-click the form or report in the Navigation Pane and then click Layout View. Need more help? Expand your skills.
Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions.
Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback!