I need help with Microsoft access and the direction in Word file attached

 

I need to do this work by 

Fall 2013

Create a database that contains information related to a company such as a publisher, art gallery, sports team, or other service businesses that deal with people and the products they create/sell.

Plan:

1. Plan your database on paper by first listing all the fields you require.

2. Split your list into tables minimizing redundant data

3. Determine the relationships

Your Database must include things we have learned in class. Here are the minimal requirements:

· A lookup field that looks up a value from another table

· A lookup field that utilizes a list created by you

· A calculated field if it makes sense (optional)

· Default values where appropriate

· Realistic field sizes

· Input masks and formatting as appropriate

· Relationships that enforce referential integrity

· Tables should have a minimum of 10-15 records

· Create at least two forms that you utilize the special options we learned in class

· Must utilize a button

Create at least 3 queries using the following:

· At least one wildcard

· At least one parameter

· At least one that includes more than one table and criteria.

Create at least 2 reports.

Create a Main Menu form.

· Include labels as needed for explanation

· Include buttons for at least 2 forms and 2 reports

· Include a button to exit the database

· Each form and report should have a button added to return to main menu

Fall

2013

Create a database that contains information related to a company such as a publisher, art gallery, sports
team, or other service businesses that deal with people and the products they create
/sell
.

Plan:

1.

Plan your database on paper by first listing all the fields you require.

2.

Split your list into tables

minimizing redundant data

3.

Determine the relationships

Your Database must include things we have learned in class. Here are the minimal requirements:

·

A

lookup field that look
s up a value from another table

·

A lookup field that

utilizes a list created by you

·

A calculated field

if it makes sense (optional)

·

Default values where appropriate

·

Realistic field sizes

·

Input masks and formatting as appropriate

·

Relat
ionships that enforce referential integrity

·

Tables should have a minimum of 10
–
15 records

·

Create at least
two

form
s

that you utilize the special options we learned in class

o

Must utilize a button

Create at least 3 queries using the following:

·

At least one
wildcard

·

At least one parameter

·

At least one
that includes more than one table and criteria.

Create at least 2 reports.

Create a Main Menu form.

·

Include labels as needed for explanation

·

Include buttons for at least 2 forms and 2 reports

·

Include a butt
on to exit the database

·

Each form and report should have a button added to return to main menu

Fall 2013

Create a database that contains information related to a company such as a publisher, art gallery, sports
team, or other service businesses that deal with people and the products they create/sell.

Plan:

1. Plan your database on paper by first listing all the fields you require.
2. Split your list into tables minimizing redundant data
3. Determine the relationships

Your Database must include things we have learned in class. Here are the minimal requirements:
 A lookup field that looks up a value from another table
 A lookup field that utilizes a list created by you
 A calculated field if it makes sense (optional)
 Default values where appropriate
 Realistic field sizes
 Input masks and formatting as appropriate
 Relationships that enforce referential integrity
 Tables should have a minimum of 10-15 records
 Create at least two forms that you utilize the special options we learned in class
o Must utilize a button

Create at least 3 queries using the following:
 At least one wildcard
 At least one parameter
 At least one that includes more than one table and criteria.

Create at least 2 reports.

Create a Main Menu form.
 Include labels as needed for explanation
 Include buttons for at least 2 forms and 2 reports
 Include a button to exit the database
 Each form and report should have a button added to return to main menu