Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
COIS-3380 Database Assignment Soccer League
Most 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:
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.
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.