COIS-3380 Database Assignment Soccer League
ost applications that create a product, like a document, allow you to create and work with the item and name it later when you save or exit. Databases must be named and placed in the desired folder when they are first created. The only time you will be prompted to save something is when designing or modifying database objects (e.g., tables, forms, queries, and reports) but NOT when you are adding or changing data or when you exit Access.
Create a new (blank) Microsoft Access database named just “Soccer”. Create the following tables with the exact names and structures shown with the primary keys as first field of each table. Fields with validation rules must also have suitable validation text. Field properties listed below must be set as indicated. To obtain help about a field property, click within the property box and press the F1 key – read the help related to the property and use the examples provided.
Teams table:
Field Name Data Type Field Properties
Team ID Number
Primary key, field size = Integer, no decimal places, required
Validation rule requires it to be >= 0
(Info only: team 0 is for “unassigned” coaches & players later)
Validation text with meaningful message
Team Name Short Text Field size = 15, required, cannot be 0 length
Color Short Text Field size = 15, required, cannot be 0 length
Mascot Short Text Field size = 15, not required
Gender Short Text
Field size = 1, required, cannot be 0 length, force uppercase
Validation rule allows only:
F, M, or C (meaning female-only, male-only, or coed)
Validation text with meaningful message
Age Bracket Number
Field size = Byte, required, no decimal places, default value 0
Validation rule allows only the values 0, 6, 8, 10, 12, 16, 20
Validation text with meaningful message
After creating each of the above three tables, perform the following additional tasks:
Create a default or basic form for each table by selecting the table and using the “Form” button on the Create ribbon. After Access creates the form, save it with the default name, and then open it in design view and make sure labels and text boxes are sized properly. Short fields shouldn’t have large text boxes.
Both labels and textboxes must be large enough to properly display entire contents. The form must have a title at the top. You can receive BONUS points by making the form more appealing or useful.
Use the appropriate form to enter the sample data shown on the next page into the appropriate table.
Note: the primary key ID numbers will be automatically generated except for the Teams table. If you can’t enter the data properly, you may have an error in the validation rule for that field.
Open each table in datasheet view and “best-fit” all columns to fully display data and field names. Save the table layout when closing table.