Bristol Community College Resources Assignment

Passing in assignment:

As you go along you need to take pictures of the screen and paste them into a document to pass in. You will need a picture of the layout of the table (showing fields etc), you will need a picture of the data in the table also pasted into your document. For each query, you will need a picture of the layout of the query and a picture of the resulting records that meet the criteria. These should also be pasted into the document.
An alternative ia attach the database to your email and send me the actual database. It looks like it is not getting through but I usually can work around it.

Assignment:

Design and develop a database with one table in Access. The table should contain the following information about resources available at Bristol. The layout of the table should contain the following fields.

Id number (do not use the default id number that Access will provide or a sequential id - make up your own numbers).
Name of the resource such as Transfer Services
Phone number if available
Building (make sure that the building code has several records in the same building for doing queries below.
Room
Contact person (if no person is listed, give the resource name again)
Web address
Category (make a code here that can be used for multiple things such as Career Services, Transfer Services both being assigned a code of CT
Plan to use code (Y for Yes, N for No, M for Maybe) I suggest multiples for each code

Remember that fields should not have embedded spaces when you give them a name in the layout of the table and that the text fields should have an apporpriate length (they should not all be 255).
Note, if you cannot find information for a field leave it blank or insert something that makes sense. Here are some examples of resource information you might include in your table. You should look up the needed information. You can also add other resources and exclude some of these suggestions. Please put 10 records in your table with as much information as you can find. Remember that fields like Category and plan-to-use should have multiple of the same code so if I ask for records with a Category of CT I will see multiple records.

Registrar and Records
Mission, Vision and Values
Disability Servics
Transfer Services
Career Services
Information Technology Services
Financial Aid
Student Support Services
Athletics
Advisement

Once the table has been set up and populated, you need to query the table to get results. As mentioned above, set up your data so that sometimes you will get multiple records that meet your criteria. In doing this assignment, if I refer to a particular Category this means you pick a Category code that exists in your table so you might be looking for Category CT. Two records might meet that criteria.

Queries:

Do a query to show the name of the resource, the category and the plan-to-use code for a particular category AND a particular plan-to-use code.
Do a query to show the name of the resource, the category and the plan-to-use code for a particular category OR a particular plan-to-use code.
Do a query to show the id number, the name of the resource, the category, the building, and the plan-to-use code for records where there is a particular building AND a particular plan-to-use code OR where there is an id number greater than a certain number AND a particular category.
Do a query to show all of the fields for a particular building AND a particular category OR for just a particular plan-to-use code.
Do a query to show all of the fields for a particular building AND either a particular category OR a particular plan-to-use code.
Do a query to show all of the fields for records that meet criteria 1 AND criteria 2 OR criteria 3 OR criteria 4. You decide what criteria to use.
Do a query to show 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.