Access Database Design - SIMPLE

Completado Publicado Mar 5, 2004 Pagado a la entrega
Completado Pagado a la entrega

**This is a project for my microsoft access class. I need someone to make a good example project for me to follow. If you think you under stand the instruction i got from my teacher please make a bid and it could be some easy money if you are good at using access.**

## Deliverables

Part I: Database Design

This test you will build a video rental database.

The name of this database is [login to view URL]

You have to design and build the data in the tables.

You have to establish the relationships between the tables.

You will be responsible to make sure that there is data in each of the tables.

**Database Project Requirements**

Here is a list of the information that you need to keep track of, all fields are required:

Video Titles

Video Ratings

Video Running Time

Video Category

Video Actors

Actors First and Last Names

Actors Date of Birth

A copy number for each video

A status for each video on whether it is checked in, or out.

Each Video can only be associated with a single category.

Valid Categories are:

Science Fiction

Western

Adventure

Thriller

Romance

Comedy

An Actor may be in many videos, and each video may have many actors.

Each video may have several copies in the store.

** **

**Part II: Form Design**

Here is an example of the Video Form, to be used in your store. Remember to show all the information that is listed in this example form. Your form is NOT expected to exactly like the example. Your form is not only graded on whether it works, and contains the necessary information, but on how it looks.

Make sure that your form has:

The current date

At least one piece of clip art

Video, Actor, Copy information is displayed

Buttons on the bottom of the form perform the following

o Last Record

o Previous Record

o Next Record

o First Record

o Add Record

o Delete Record

o Close Form

** **

**Part III: Report Design**

***Report 1***

**The following is an example of a Video Status Report. You should look as close as the example as possible, but not exactly. This report list the status for every video that is the store.**

**Please make sure that the copy status for each video title is displayed.**

***Report 2***

Also create a report that is run off a query that shows which videos are checked out. That report should be grouped by category.

**Example Report**

## Platform

I will have more info as i get it from my teacher.

Ingeniería Microsoft Access MySQL PHP Arquitectura de software Verificación de software

Nº del proyecto: #3123365

Sobre el proyecto

26 propuestas Proyecto remoto Activo Mar 6, 2004

Adjudicado a:

edlukens

See private message.

$21.25 USD en 4 días
(82 comentarios)
5.5

26 freelancers están ofertando un promedio de $31 por este trabajo

Prashantskin

See private message.

$42.5 USD en 4 días
(577 comentarios)
7.3
vevssl

See private message.

$29.75 USD en 4 días
(83 comentarios)
6.3
utopiaprogr

See private message.

$34 USD en 4 días
(62 comentarios)
5.4
expertbrain

See private message.

$42.5 USD en 4 días
(53 comentarios)
5.1
alcanta

See private message.

$38.25 USD en 4 días
(28 comentarios)
4.9
gopikap

See private message.

$21.25 USD en 4 días
(54 comentarios)
5.1
vbcodepro

See private message.

$42.5 USD en 4 días
(52 comentarios)
5.0
RGATRAC

See private message.

$42.5 USD en 4 días
(11 comentarios)
3.6
fastianz

See private message.

$42.5 USD en 4 días
(4 comentarios)
3.3
msmughal

See private message.

$42.5 USD en 4 días
(37 comentarios)
3.6
vnicky

See private message.

$32.3 USD en 4 días
(15 comentarios)
2.8
codeoverload

See private message.

$21.25 USD en 4 días
(4 comentarios)
2.4
bogdandvw

See private message.

$12.75 USD en 4 días
(8 comentarios)
2.4
kinglancer2004

See private message.

$29.75 USD en 4 días
(3 comentarios)
2.0
sanjaykumarr

See private message.

$25.5 USD en 4 días
(4 comentarios)
1.8
dumitruvw

See private message.

$12.75 USD en 4 días
(1 comentario)
1.1
rcccc

See private message.

$8.5 USD en 4 días
(2 comentarios)
0.5
eparkvw

See private message.

$42.5 USD en 4 días
(0 comentarios)
0.0
stephendecaro

See private message.

$42.5 USD en 4 días
(0 comentarios)
0.0
andersoft3000

See private message.

$29.75 USD en 4 días
(0 comentarios)
0.0