Access Assignment (BCC Resources)

Design and develop a database of resources available to you at BCC by creating a table in MS Access. Below, I am providing you with an outline (field suggestions) for a basic table design. You are more than welcome to use this as a starting point to expand upon. If you follow my model, the fields you want to include in each record of your database table are as follows:

I strongly suggest that you make up short, easy names for the fields/columns in the table. Use the description field within the design tab to clarify the field name that you have created. Clarity is important, especially if someone other than the creator of the database needs to use it at any point. Remember there should be no embedded spaces in any of your field names. You should also make sure that the field lengths for each of your text fields are realistic (they should not all be 255).

An example might be:

Note, if you cannot find information for a particular field you may leave it blank if you honestly tried to find it. For example, some of the things may not have a room or extension or contact person, but they may have a website.

Once your structure is finalized and implemented within Access, you should populate the table with at least 15 records. Please look up and include information from the list below and then go to the college website and find 5 additional BCC resources to included in your list.

Once the table has been set up and populated, you will need to query the table to get results. I will not accept submissions that have only one result for each (or most) of the queries below. If you run into this issue, you may need to change the "Category" and/or "Plan to Use" fields so that you get multiple records that meet your criteria.

Required Queries:

  1. Do a query to show id number, title of the resource and category for a particular plan to use code.
  2. Do a query to show at least two fields (not all) of the fields for a particular category AND a particular building.
  3. Do a query to show all of the fields for a particular building OR a particular plan to use code.
  4. Do a query to show all of the fields for a particular building AND a particular category OR a particular plan to use code.
  5. Do a query to show all of the fields for a particular category AND either a particular building OR a particular plan to use code.
  6. Do a query to show some (but not all) of the fields for records where the id number is less than a certain amount (you pick the amount) AND either it is in a particular building OR has a particular plan to use code.