Description
What to do Next – Take Home Test
Next Create a New Database and the following tables using Access. subject to these business rules
Students and parents can have only one email address
All email addresses must be in a format similar to this [email protected]
Phone numbers must be input in this format 352.212.4477
Parents and students can only be from the following states: Texas, Louisiana, Mississippi, Alabama
We store state names with their two digit abbreviations only.
We can have no blanks in the database (No Nulls Allowed)
Students only can major in the following: Computer Information System, Accounting, Management or Marketing.
All table fields are labeled using this format (example Student Id is labeled Student_Id)
Do the following
Name the Database With the Following Name: YOUR NAME Database
Create one Table called Student.
Place in the table the following columns: Student ID, First Name, Last Name, University Street Number, University Street Name, University City, University State, University Zip Code, StudentEmail ssume for now they have only one email)
Create a second Table called Parent
In that table create the following fields: Student ID, Parent First Name, Parent Last Name, Parent email, Parent phone number, Parent Street Number, Parent Street Name, Parent City, Parent State, Parent Zip, ParentEmail (assume for now they have only one email)
Create a third table called Major.
In that major create these fields, Major ID and Major Name
For each field in all tables select an appropriate datatype and fill in the comments. If you are unaware of what each datatype is, please use Google to research that question
For each field in all tables make the field required.
For the tables
Limit the state name to 2 digits (Example: Louisiana = La)
Create a validation rule which limits the states to the approved 2 digit format used by the post office. The tutorial will provide you this
Create an input mask for the phone numbers to appear in this format 222-222-2222
Create a validation rule where the email address must be in this format [email protected] Example: [email protected]
For the major field create a validation rule which limits the values to Computer Information Systems, Accounting, Marketing, Management
Unformatted Attachment Preview
Learning Objectives
At the conclusion of this unit the student will be able to:
•
•
•
•
•
•
•
•
•
•
•
•
Open a database
Create a table
Open, create and edit records
Modify the appearance of your table to make it easier to view and work with
Create and arrange table fields
Set validation rules
Set character limits
Set Datatypes
Imposing field specific physical business rules on a field
Imposing field specific logical business rules on a a field
Creating validation rules and imposing them on a field
Creating an input mask on a field
Introduction
Learning Material
You are expected on your own to complete this for the exam for this unit. This material
will not be covered in class during class time. Do Not skip this unit as using it is vital if you
wish to develop the knowledge-skills and ability you need to not only pass this course but
to be career ready to enter the workforce. This unit and the units like it that follows will
develop you understanding of database concepts as well as give you hands-on practice
using Access skills you will find you can use beyond this class.
The best way to use this resource is to practice it. On the material where you are working
directly with Access, open up Access and follow the video step by step. Using the split
screen function you learned in CIS 115 will help make this easier to do. Please avoid trying
to practice this on a cell phone. The screen is too small but often time the screen will
render in a different configuration that you would see on a normal computer screen like
you would use at work. If you do not have a computer at home, I strongly recommend you
going to a source that you can use that has one.
To Create a Database Table
To Create a Table follow these instructions
https://www.quackit.com/microsoft_access/microsoft_access_2016/tutorial/create_a_tab
le_in_microsoft_access.cfmLinks to an external site.
If you prefer, you can watch this video, but it gets interrupted by ads
How to Create a Table and Fields in an Access 2016 DatabaseLinks to an external site.
Editing a Table
The following LinkLinks to an external site. will take you to the learning
material for this unit where you will get an introduction opening tables, creating and
editing records and modifying the appearance of your table to make it easier to view and
work with. This material contains both text and video. At the end of the video you will be
asked if you want to continue. For this unit you do not have to hit the continue button as
we will cover that material in a subsequent unit. You are expected on your own to
complete this for the exam for this unit.
The following Link Links to an external site.will take you to the learning material for this
unit where you will get an introduction to modifying tables. This material contains both
text and video. At the end of the video you will be asked if you want to continue. For this
unit you do not have to hit the continue button as we will cover that material in a
subsequent unit. You are expected on your own to complete this for the exam for this
unit.
The link below is the YouTube link to the same video you saw in Working with Tables. It
was placed there to make it easier for you if you only wanted to watch the video.
Access: Working with TablesLinks to an external site.
The link below is the YouTube link to the same video you saw in Modifying Tables. It was
placed there to make it easier for you if you only wanted to watch the video.
Access: Customizing TablesLinks to an external site.
Creating Input Masks: A tutorial LinkLinks to an external site.
How to create a validation Rule LinkLinks to an external site.
What to do Next – Take Home Test
Next Create a New Database and the following tables using Access. subject to these
business rules
•
•
•
•
•
•
•
•
Students and parents can have only one email address
All email addresses must be in a format similar to this [email protected]
Phone numbers must be input in this format 352.212.4477
Parents and students can only be from the following states: Texas, Louisiana,
Mississippi, Alabama
We store state names with their two digit abbreviations only.
We can have no blanks in the database (No Nulls Allowed)
Students only can major in the following: Computer Information System,
Accounting, Management or Marketing.
All table fields are labeled using this format (example Student Id is labeled
Student_Id)
Do the following
•
•
•
•
•
•
•
•
Name the Database With the Following Name: YOUR NAME Database
Create one Table called Student.
o Place in the table the following columns: Student ID, First Name, Last
Name, University Street Number, University Street Name,
University City, University State, University Zip Code, StudentEmail
ssume for now they have only one email)
Create a second Table called Parent
o In that table create the following fields: Student ID, Parent First
Name, Parent Last Name, Parent email, Parent phone number,
Parent Street Number, Parent Street Name, Parent City, Parent
State, Parent Zip, ParentEmail (assume for now they have only one
email)
Create a third table called Major.
o In that major create these fields, Major ID and Major Name
For each field in all tables select an appropriate datatype and fill in the
comments. If you are unaware of what each datatype is, please use Google to
research that question
For each field in all tables make the field required.
For the tables
o Limit the state name to 2 digits (Example: Louisiana = La)
o Create a validation rule which limits the states to the approved 2
digit format used by the post office. The tutorial will provide you this
o Create an input mask for the phone numbers to appear in this format
222-222-2222
o Create a validation rule where the email address must be in this
format [email protected] Example:
[email protected]
For the major field create a validation rule which limits the values to Computer
Information Systems, Accounting, Marketing, Management
When finished, Upload to Canvas
Note you will be using the product of this assignment for a future assignment, Access Skill
Development: Relating Tables in Access, so get this right and save your work
Purchase answer to see full
attachment
