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

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