Student+Life+Toolkit

= Student Life Toolkit = Back to: Task 3 and 4 Please email us at cregan@msmary.edu or sacarchidi@email.msmary.edu with any questions!

=
Student Life currently has old organization requests, budget requests and community service forms on paper file. Since information has to be kept a few years back, we suggest that you take some time to input some of the old information into the database. Clubs range in size and membership so we have created 3 Excel Spreadsheets which each President will fill out electronically and then send back to you. To input back data, you should fill them out and save them by Club name and year. The screencast below will show you how to attach them to the database=====

[[file:Contact List.xls]][[file:Detailed Breakdown of intended Usage for funds.xls]][[file:Description of Service Projects.xls]]
Watch the screencast below to learn the basics of how to input data into Microsoft Access and how to attach the above documents.

media type="file" key="How_to_Input_Back_Data_in_Microsoft_Access.swf" width="826" height="640"

Collecting New Data from Club Presidents
Microsoft Access allows you to easily collect data from Club Presidents electronically through Microsoft Outlook email. You **MUST** use Outlook (not Outlook Exchange). With just a few clicks to verify the information, it is then automatically updated to the database. Watch the screencasts below to see how it is done!

media type="file" key="Creating_an_Email_to_send_to_Club_Presidents.swf" width="842" height="640"

Microsoft Online also has some great resources in the form of text and video:
Collect Data using e-mail

Queries -When you want to review, add, change, or delete data from your database, consider using a query. Using a query, you can answer very specific questions about your data that would be difficult to answer by looking at table data directly. You can use queries to filter your data, to perform calculations with your data, and to summarize your data. You can also use queries to automate many data management tasks and to review changes in your data before you commit to those changes.

Reports - You can create a variety of different reports in Microsoft Office Access 2007, ranging from the simple to the complex.