Access Project

I had never used Access before doing this project. I understand why Databases are more useful than just plain spreadsheets, but for this project I could have done it a lot easier in Microsoft Excel personally. The queries and reports gave me the most problems. Getting things to filter and sort properly took a lot of trial and error. Still not entirely sure I did that part correct actually. The form worked, but seemed to add the new members to the queries section, not the original table. I think that may be because I had selected the queries group when I made the form.

If you couldn't tell already, I do not have much of a knack for Access yet, and I'm still not sure of all its' functionality so my ability to upgrade this database would be limited. I guess the ability to auto-add the join date into the database, instead of manually typing it would be one improvement. Maybe you could hide non-essential information from the employees as to prevent abuse.

Week 11: Muddy

When starting the lectures I had no idea just how little I knew about Access. I had opened it up before but never really done anything with it, and most times when installing Office, I'd uncheck the box for installing Access. New names for rows and columns, and the tables are nothing like I've seen as a table before. This was going to be an entry into foreign territory.

I kind of understood the idea of a primary key. That is what I understand to be the unique object to which all other things are relevant to. Everything else is just describing what is in the primary key. However I am using Office 2010, and getting to the default design view that I saw in your lectures was a trial in itself. It defaults to database and didn't realize that there were 4 different types of views. Then you get to the different types of data that can go into the fields. Access obviously has a lot of features, most of which I'll probably never learn. However I did make sure to play some Access games http://www.happy2-island.com/e/access.shtml