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:
-
Id number (do not use the default id number that
Access will provide, make up your own number)
-
Title of the resource
-
Building
-
Room
-
Extension
-
Contact person (if no person is listed, give the
resource name such as Financial Aid)
-
Website URL
-
Category (make up a code here that can be used for
multiple resources for example Career, Support, Transfer, Extra
Curricula, Financial might be some categories you could use – you can
make up a code such as car for Career and sup for Support)
-
Plan to use code (Y for Yes, N for No, M for Maybe)
- Do you plan to use this resource while you are at BCC?
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:
- 111
- Academic Center for Entrepreneurship
- K
- 121
- 2695
- April Lynch
- http://www.bristolcc.edu/academics/academiccenterforentrepreneurship
- Career
- Y
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.
- Academic Center for Entrepreneurship
- Financial Aid
- Learning Resource Center
- Career Services
- Connection Center
- Tutoring and Academic Support Center
- Disability Services
- Transfer Affairs
- Athletics
- Bookstore
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:
- Do a query to show id number, title of the resource and category for a
particular plan to use code.
- Do a query to show at least two fields
(not all) of the fields for a particular category AND a
particular building.
- Do a query to show all of the fields for a
particular building OR a particular plan to use code.
- Do a query to show
all of the fields for a particular building AND a particular category OR a
particular plan to use code.
- 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.
- 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.