Encerrado

Access database Homework

Use Acccess DB to create a set of tables that can support Common Workgroup Process shown in Figure 7-3 for the

a. Sales and Marketing Department (excluding the forecasting function)

b. Operations Department

Each table design must have field definitions, data types and descriptions (on what is the purpose of the field.)

Observe and list the relationships between the tables.

Limit the number of the tables (e.g., 3 to 6 tables) and the number of field in each table (e.g., 5 - 8).

HINT: A minimal table design for this homework may support the state and context of a sales process (e.g., time, location, customer, salesReps, state of the customer engagement, product for sale, order entry, and product inventory, etc.). Product specifications or promotional materials may be defined using "attachment" or "hyperlink" as data types.

Queries:

Next quarter sales revenue forecast (based on probability multiplied by revenue) by customer

Quarterly sales v.s. target by department. For example, 80% of $600K for July for shoe department and 95% of $650K for Aug. for the sports goods department etc.. Add planned sales target and department fields as needed.

Habilidades: Microsoft Access

Ver mais: types data entry fields, microsoft support number, example inventory database, design access database, access sales marketing, salesreps, operations inventory, process access, data forecasting, access v, data entry inventory database, database table design, probability data, customer engagement, customer sales database access, access inventory design, access database process, sales database microsoft access, add field sales order, homework example, customer access database, inventory sales database, access customer inventory database, access database inventory sales, sales order table database

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #5105660

15 freelancers estão ofertando em média $44 para este trabalho

elboukharimu

Hi, I'm very interested helping you doing your Access assignment, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some s Mais

$115 USD in 5 dias
(3 Comentários)
3.4
mail2vimalarora

Hi.. I have gone through your requirement to create database in Access which will have tables for Sales and Marketing Department & Operations Department, and including queries as required. I have done similar projects Mais

$30 USD in 3 dias
(5 Comentários)
2.8
pivn

Let expert do this I am an expert Database Administrator. Plz let me do this https://www.freelancer.com/u/pivn.html https://www.freelancer.com/u/pivn.html https://www.freelancer.com/u/pivn.html

$35 USD em 1 dia
(2 Comentários)
1.9
oobretenov

I could help you with this task. . Mais

$135 USD in 3 dias
(1 Comentário)
1.8
Reza2012

Hi I have more than 10 years experience in MsAccess database administration and SQL programming. Previously I have done same type of work. If you want to see my work sample I can provide you. Please communicate with me Mais

$55 USD in 3 dias
(1 Comentário)
1.7
jawadaman

Hi, I can do this job for you. I am an experienced professional. If interested in hiring me then please let me know so that we finalize the assignment scope. Regards, Jawad

$25 USD in 3 dias
(2 Comentários)
1.6
sayli2

Very easy for me. My last project was also on MS Access. I've 100 completion rate here. please check my profile for details. Thanks

$23 USD in 2 dias
(1 Comentário)
1.5
TCNGraphicExpert

A proposal has not yet been provided

$34 USD in 3 dias
(0 Comentários)
0.0
matrixoforex

I will create it with all your required also can create php interface for it and make it available online for multi user

$50 USD in 7 dias
(0 Comentários)
0.0
bms21

Hi, I am interested about that Access database Homework project and seem that fits me well. I have the skills you are asking for and got time to complete the work. I got a degree on IT and very capable on Microsoft Mais

$35 USD in 3 dias
(0 Comentários)
0.0
RonelBenade

I am an experienced worker in the IT Industry with advanced experience in identifying Dimensions and Facts (Table Structure) to provide you with the most dynamic analytics and business intelligence. No matter how Mais

$30 USD in 2 dias
(0 Comentários)
0.0
danangvw

I have bachelor and master degrees in IT. My Primary skills include Java, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration a Mais

$25 USD em 1 dia
(0 Comentários)
0.0
Atifshareef1628

We have a team of professionals and we have been doing such type of projects. This assignment is so simple and easy. Looking forward for consideration. Thank you!

$25 USD in 3 dias
(0 Comentários)
0.0
hbxfnzwpf

I am very proficient in dealing with word, ppt, access, excel files, and good at VBA programming, I have exceed 6 years of VBA programming experience now. I made many audit program using excel, and I am very efficient, Mais

$25 USD in 3 dias
(0 Comentários)
0.0
Pharoa

I am a Senior Systems Analyst/Programmer with over 19 years experience. I have developed applications with all versions of Ms Access. For your project, I propose to prepare the tables as per your bid with Ms Access Mais

$25 USD in 3 dias
(0 Comentários)
2.7
aerosmith

Hello, I work with access on a daily basis, I can certainly help you fufill your requirements and possibly work with you in the future if you have any new items for access or vba homework. Im proficient with sql and Mais

$20 USD in 5 dias
(0 Comentários)
0.0