Find Jobs
Hire Freelancers

Create the database

$2-8 USD / hour

Cancelado
Publicado hace casi 11 años

$2-8 USD / hour

Plan a database project for a mock organization. The database can be for any application your wish however it cannot be a student/teacher or employee/department database. (5 pnts) Write a report to include the following: * A paragraph describing the database and the application. * A list of entities (tables) and how they are related to each other. You project will require that you have at least two tables and a one to many relationship between them. Final Project Part II: Create the database to complete your project. Your project must implement the following technical requirements. (75 pnt) 1. At least two tables with a one to many relationship between them. 2. Use at least one lookup field on one of the tables. 3. Set validation rules on all numeric fields. There must be at least one numeric field. 4. Use at least one input mask for a field. 5. Enforce the relationships for all tables. 6. Create a query that uses a parameter. Name it QUERY1 7. Create a different query has a calculated field. Name it QUERY2 8. Create a different query that uses a join and multiple criteria with and/or. Name it QUERY3 9. Create a simple update form that uses a combo box. Name it FORM1. 10. Create a different form that uses a subform. Name it FORM2. Add a combo box to find a record in the table. 11. Add a calculated field to FORM1. 12. Create one summary report that uses grouping and subtotals. Name it REPORT1 13. Add a calculated field to REPORT1 14. Create a blank form in design view. Add buttons to the form that will open the other forms and reports in your database. Make it the startup form using the FILE tab options button. Put a label title on the form. Name it the MENU form. 15. Create a query and use the query to build a pivot table and pivot chart. Name the query PIVOT 16. Add a graphics to the report named REPORT1 also make sure to add date and pages numbers to this report. 17. Export query 2 to a web page format. Be sure to submit the web page and save your export steps. 18. Save, compact and backup your project on disk
ID del proyecto: 4457885

Información sobre el proyecto

4 propuestas
Proyecto remoto
Activo hace 11 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
4 freelancers están ofertando un promedio de $7 USD /hora por este trabajo
Avatar del usuario
Hi, Access VBA expert here, I have got several applications ready as per your requirements, plz chk pm for DEMO, Regards.
$5 USD en 9 días
4,9 (5 comentarios)
3,1
3,1
Avatar del usuario
Hi I have more than nine years experience in Database Development and Administration. Please see PM. Thanks.
$7 USD en 10 días
5,0 (1 comentario)
1,7
1,7
Avatar del usuario
Over 16 years professional experience working for large UK companies
$8 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hey I have very good experience with this kind of work.
$9 USD en 4 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
lucknow, India
5,0
8
Forma de pago verificada
Miembro desde sept 2, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.