Access Form Help

[Spotniq]

Good evening,

I'm fairly new to Access, but pick up things pretty fast. I've been tasked with creating a pretty complex form at work (at least complex for me and was wondering if I could get a high level overview road map from some folks here (as to what I need to do first and what steps to follow etc.) What I'm trying to do is create a form that users will use to request item #'s for various business reasons. There are 6 different types of item #'s a user can request and I would like to have 6 different buttons that would lead to an individual form for that particular item #. Each form ranges from 5 columns of data up to 10 columns of data. However, I want to create usernames and possibly passwords for the users that will be accessing this form, reason being is I want to somehow tie their user names to the requests they've made and create a history of their requests. In essence if a user logs in they can go to a page where they can see all of their previous requests be it from any item #. Now, I would also like for Access to some how inform me when new requests are submitted be it via e-mail or a message within Access. Is this something than can be done within Access? I currently have a version of this form built in Excel using VBA, but I want to start keeping history of the requests (like mentioned before) within the same form. currently I have to take the form that is e-mailed to me via a macro I built and take the data and insert it into another spreadsheet. Any help would be greatly appreciated. Thank you in advance!!

[June7]

Start with learning about relational database concepts. Here is one tutorial source http://www.rogersaccesslibrary.com/

Yes, Access can send emails.

[Spotniq]

Thank you June7!