USA: +1(669)289-8683
USA: +1(669)289-8683

Microsoft Access Project

I need to create command buttons on the front page which specifically uses a macro to open different reports in print preview. I need different buttons for clients, mailing labels, a report. I need a pop up form so I can choose from a list of clients with a validation check box.If you do a good job, I may have more work for you. Keep in mind that I need this done quickly. I attached the assignment as well as a video.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

ire

CertName CertEffective CertExp CertComments
Advanced Life Support
Bouldering
Cave Diving
CPR
Deep Water Dive
First Aid

1
First Aid

2
Hiking
Kayaking
Open Water Dive
Snorkel Instructor Level 1
Technical Climbing
White Water Kayaking
2

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

1 E.

2nd

3

3

3

Sycamore

MO

4

7 Claremont Avenue

MO

2

5

1

IRWIN

MO

6

08 E 61st Terr

MO

7

E 97TH ST

KC MO

8

1 HEDGES

RAYTOWN MO 64133

9

MICHIGAN

KC MO

10

E

9th

MO

11

E 35TH STREET

MO

12

106 E 45 ST SOUTH

MO

13

KC MO 64131

14

RAYTOWN MO 64133

15

Kansas City MO 64133

16

ND ST

MO

17

Overton

MO 64052

Kansas City MO 64138

19

KANSAS CITY MO

20

KC MO

Brian

Kansas City MO 64131

22

RAYTOWN MO 64133

KC MO

Kansas City

l

KC MO 64133

KC MO

27

KC MO

28

Indep. MO 64055

29

RAYTOWN MO 64138

30

KC MO 64138

31

KS

32

MO

33

Kansas City MO 64133

34 Patrick

Raytown MO 64133

35

RAYTOWN MO 64133

Kansas City

64129

37

KS

38

Overland Park KS

ClientID ClientFN ClientLN ClientAdd1 ClientAdd2 ClientAdd

 3 ClientCity ClientSt ClientZip ClientPhone ClientEMail ClientComments ClientCorrespondance
Patrick O’Halloran 11 3

 0 6 Raytown MO 6

 4 13
Mikala O’Neill 7 20 Kansas City 641

 33
Clinton Odel 2

 10 Independence 640

 5
Jessica Obetting 7

 8 9 RAYTOWN 641

38
Brian Oliver 1

 16 KC 64133
Kelsey Parker 11

 31 64131
Ashok Patro 6

 30
Reed Patterson 79

 35 641

 32
Brett Pener 62

 14 12 Grandview 64030
Casey Perry 62

 15 KANSAS CITY 641

 29
Krysta Pettus 17 INDEP 64055
Kyle Pfeifer 1174 E 67TH ST
Phuong Pham 6410 HARVARD
Daniel Salmon 4801 Overton
Jenna Sahli 10100 E

22 INDEPENDENCE 64052
Catherine Sanders 28 19 Indep.
18 Paige Schlatter 7522 E. 89TH Terrace
Sarah Schrader 10703 BRISTOL TERRACE 641

 34
Jennifer Turbitt 1830 Lawn 641

 27
21 Wallace 421 E. 73RD Terr.
Nick Tucker 5812 MANNING
23 Ross Wagner 3505 Ruysser Rd 641

 37
24 Michael Walker 3117 S. 8TH Terrace KS 66103
25 Nea Woodward 12005 E 63rd Terr
26 Jonna Yencic 1009 Santa Fe Tr. 64145
Grant Zimmerman 6877 Sni-A-Bar Rd 64129
Alvin Lin 16516 Ellisonway
Elizabeth Musil 7911 ELM
Kimberly Winn 8107 E 90TH ST
Emily Blake 5706 W. 97th Terr. Overland Park 6

6207
Brooke Boehmer 2291 Current Liberty 64068
Chad Bowman 11800 E 60th Terr.
Brown 6114 Sterling
Katie Cofer 11004 E 72ND TERR
36 Jeffrey Siler 4701 Byrams Ford Road Mo
Bill Smith 14013 W. 61ST Terrace Shawnee 66216
Lisa Friedrichsen 12345 College Blvd. 66213
39 Curtis Sharon 123 a street La Mesa CA 91941

CertName

CertExp

1 Advanced Life Support 1

IDEmp EmpCertID CertStart
1/1/12 1/31/13
EmpEmergContactID IDEmployee EmpEmergFn EMpEMergLN EmpEmergAdd1 EmpEmergAdd2 EmpEmergAdd3 EmpEmergCity EmpEmergSt EmpEmrgZip EmpEmrgPhone EmpEmrgCell EmpEmrgRelation EmpEmergPowerAtty EmpEmergCountry
1

CA

0

2

Smith

San Diego CA

USA 0

3

0

4

0

5

6207

0

6

Australia 0

7 Nea

0

8

Finland 0

9

Bogata Chile 0

EmpID EmpFn EmpLn EmpAdd1 EmpAdd2 EmpAdd3 EmpCity EmpSt EmpZip EmpCountry EmpComments EmpCorres
Alan Paul 123 A St. San Diego 92121 USA
Mary 234 B St. 92127
Rudolf Scheffrahn 5521 Leiberstrasse Eider Oberstein Gemany
Juan Valdez 222 Corte Madera Bogata Chile
Sebastian O’Shaughnessy 46 Friar John Way WHITTAKER WA Australia
Caitlyn Corrigan 41 Railway Avenue BENARCH VIC 3630
Kauppi Vanhamaantie 9 ELIMÄKI 47200 Finland
Ulpu Jalonen Hermiankatu 93 PIHLAISTO 35610
Ricardo Munez 6987 Via Revolution
1

0

2

12

2

1

5

3

0

One Week 1

10

4

0

2

7

5

0

One Week 1

5

6

0

2

5

7

0

1

7

8

0

2

12

PackageID PackageName PackCost PackageDescrip PackageNumGuideReqd PackageDestination PackageDuration
Tibet Trek ¤ 5,2

40.0 One week treking through Tibet Nepal, Tibet
Zip Line in the Canopy ¤ 4,800.00 One Week The Amazon
Winter Photography in Yellowstone ¤ 3,28

5.0 Yellowstone Natl. Park
Hiking to Machu Pichu ¤ 8,7

45.0 10 Days Peru
Heli-Skiing in the Rockies ¤ 6,78

4.0 Aspen, CO USA
Scuba Diving the Great Barrier Reef ¤ 4,97

8.0 Scuba Diving, Fishing and Island hopping along the Great Barrier Reef. Cairns, Austrailia
Dog Sledding ¤ 2,4

25.0 3 Days and 3 Nights Dog Sledding on the Iditarod trail. 4 days and nights in the 5 star resort Alyaska. Anchorage, AK USA
Hot Air Ballooning in Africa ¤ 27,5

98.0 Three extraordiary days and nights in the exquisite Singita Saskawa Lodge. A magnificent Edwardian manor house style with touches of African influence in the heart of the Serengeti plains. Seven days of Balooning over the greatest mammel migration on the planet, and seven nights experiencing a classic Tanzanian safari in spectacular solitude and soothing comfort – with only the canvas walls of your tent separating you from the wonder of the Serengeti. Truly an experience that will change you forever. Then back to the Singita Saskawa Lodge for additional two nights of luxury before returning to the world. Singita Sasakawa Lodge, Tanzania, Africa

32 3

2 1

4.0

12 7

5.0

30 1

31 3

25 2

8.0

15 5

37 6

37 4

5 8

35 1

18 7

29 3

19 2

29 4

24 4

2/28/10 16 5

3/29/10 12 3

9 8

24 8

2/3/10 35 4

34 6

26 2

25.0

27 8

26 4

3 3

37 8

30 3

27 2

16 7

5 1

33 3

6/13/10 14 7

37 6

14 6

26 4

27 6

30 4

40.0

9 3

2 7

8 2

5 5

3/16/10 23 4

45.0 10/5/10 13 4

1/30/10 34 4

6 2

11/10/10 19 6

8 2

10 5

20 6

13 2

9/25/10 34 6

14 7

27 3

24 1

31 3

27 2

25 6

15 6

35 5

20 6

6/13/10 6 1

10/5/10 23 5

18 4

8 3

10 3

1/31/10 31 4

8 8

37 1

5 1

23 4

2 8

16 7

2/26/10 7 1

37 6

5/28/10 22 8

26 4

28 2

9/13/10 4 4

23 3

15 6

8/8/10 23 3

18 4

16 6

29 2

14 4

28 4

21 7

16 8

37 7

4 4

6 7

10/26/10 23 3

18 3

22 5

8/28/10 19 3

98.0

36 1

10/9/10 2 5

35 2

10/26/10 20 1

32 6

ResID ResDate IDResClient IDResPackage IDEmp1 IDEmp2
2.0 9/25/10
3.0 3/29/10
7/1/10
4/21/10
6.0 2/14/11
7.0 5/13/10
1/20/10
9.0 5/8/10
10.0 3/16/10
11.0 2/3/10
12.0 7/4/10
13.0 4/18/10
14.0 2/28/10
15.0 3/15/10
16.0 6/15/10
17.0 9/13/10
18.0
19.0
20.0 6/13/10
21.0 8/11/10
22.0
23.0 10/23/10
24.0 6/19/10
10/24/10
26.0 9/6/10
27.0 11/18/10
28.0 3/5/10
29.0 5/22/10
30.0 11/2/10
31.0 7/6/10
32.0 4/30/10
33.0 5/28/10
34.0
35.0 4/27/10
36.0 11/10/10
37.0 11/24/10
38.0 10/5/10
39.0 4/23/10
1/30/10
41.0 9/1/10
42.0 8/27/10
43.0 8/17/10
44.0
46.0
47.0 11/1/10
48.0
49.0 5/15/10
50.0 3/24/10
51.0 3/30/10
52.0 9/18/10
53.0
54.0 6/12/10
55.0 3/11/10
56.0 2/13/10
57.0 12/9/10
58.0 8/8/10
59.0 7/2/10
60.0 7/22/10
61.0 8/28/10
62.0 2/26/10
63.0
64.0
65.0 2/8/10
66.0 1/31/10
67.0 11/7/10
68.0
69.0 10/9/10
70.0 8/31/10
71.0 4/10/10
72.0 4/8/10
73.0 9/23/10
74.0 5/9/10
75.0
76.0 7/16/10
77.0
78.0 1/29/10
79.0 7/29/10
80.0
81.0 3/21/10
82.0 10/28/10
83.0
84.0 2/16/10
85.0 2/23/10
86.0 7/15/10
87.0 8/2/10
88.0 6/9/10
89.0 5/26/10
90.0 10/26/10
91.0 4/28/10
92.0 7/21/10
93.0 7/20/10
94.0
95.0 1/17/10
96.0 9/11/10
97.0
11/12/10
99.0
100.0 6/26/10
101.0
102.0 4/7/10

SELECT TblClients.ClientID, [ClientLN] & “, ” & [ClientFN] AS Name, TblClients.ClientLN, TblClients.ClientFN
FROM TblClients
ORDER BY TblClients.ClientLN, TblClients.ClientFN;
SELECT DISTINCTROW *
FROM tblReservations;
PARAMETERS __ClientID Value;
SELECT DISTINCTROW *
FROM tblReservations AS frmClients
WHERE ([__ClientID] = IDResClient);
PARAMETERS __EmpID Value;
SELECT DISTINCTROW *
FROM TblEmpCerts AS frmEmployees
WHERE ([__EmpID] = IDEmp);
PARAMETERS __EmpID Value;
SELECT DISTINCTROW *
FROM TblEmpEmergencyContact AS frmEmployees
WHERE ([__EmpID] = IDEmployee);
SELECT DISTINCTROW *
FROM TblClients;
SELECT TblClients.ClientLN, TblClients.ClientFN, TblClients.ClientID, TblClients.ClientCity, TblClients.ClientSt, TblClients.ClientZip
FROM TblClients
ORDER BY TblClients.ClientLN, TblClients.ClientFN;
SELECT TblClients.ClientFN, TblClients.ClientLN, TblPackage.PackageName, TblPackage.PackCost
FROM TblPackage INNER JOIN (TblClients INNER JOIN tblReservations ON TblClients.ClientID = tblReservations.IDResClient) ON TblPackage.PackageID = tblReservations.IDResPackage
WHERE (((TblClients.ClientLN)>”m*”) AND ((TblPackage.PackCost)>4000))
ORDER BY TblClients.ClientLN;
SELECT TblClients.ClientID, TblClients.ClientFN, TblClients.ClientLN, TblPackage.PackCost
FROM TblPackage INNER JOIN (TblClients INNER JOIN tblReservations ON TblClients.ClientID = tblReservations.IDResClient) ON TblPackage.PackageID = tblReservations.IDResPackage
ORDER BY TblClients.ClientID, TblPackage.PackCost;
SELECT TblClients.ClientLN, Count(TblPackage.PackageID) AS CountOfPackageID, Sum(TblPackage.PackCost) AS SumOfPackCost
FROM TblPackage INNER JOIN (TblClients INNER JOIN tblReservations ON TblClients.ClientID = tblReservations.IDResClient) ON TblPackage.PackageID = tblReservations.IDResPackage
GROUP BY TblClients.ClientLN, TblClients.ClientLN
ORDER BY Sum(TblPackage.PackCost) DESC, TblClients.ClientLN;

Still stressed from student homework?
Get quality assistance from academic writers!
Order now

Order your essay today and save 25% with the discount code LAVENDER

Order Now