Access

There are many things that can be done within Access. In the Information Technology minor program we focused on using the Access database to show us items we want to see in the ways we want to see them and using it to categorize information. I learned to show information through tables, queries, forms, reports and macros. I would often start with a blank slate; taking a basic file from Excel and manipulating it within Access. In the below Access database, I was given the task of categorizing tables of movie actors, movie titles, and character roles. I formed inquiries to pull out specific information from the tables. I then put that information into reports to better show the categorization. I also created forms for the user to fill out in order to show specific information. Below are screen shots of some of the tables, queries, forms, and reports that I created. I’ve also included a screenshot of the relationship page, a page that shows how information is related.