Create queries to: (display all fields) a. Show all clients that are in the Client table (save the query as client query
Posted: Thu Apr 28, 2022 2:42 pm
Create queries to: (display all fields)
a. Show all clients that are in the Client table (save the query as
client query)
b. Show all employees that are in the Employee table who has a
client in the Client table (save the query as employee client
query)
c. Show all services that are currently being offered to clients in
the Client table (save the query as client service query)
d. Show all employees living in Barbican (save the query as
Barbican query)
e. Show all employees living in Papine OR Cosmetologist (save the
query as Papine OR Cosmetologist query)
f. Show all employees living in Barbican AND Nail Technician (save
the query as Barbican AND Technician query)
g. Show all ID numbers that start with H- (query should be based on
Employee table and be called ID Numbers for Hairdressers)
9. Create Columnar forms for all tables (all fields are to be
included, forms should be called Clients, Employee and Services
respectively).
10. Set the Sunken Special Effect format on all the data fields in
the Client form.
11. Disable the ServiceID and EmployeeID field in Client
form.
12. Create a Tabular report based on the Barbican AND Technician
query. Sort the report by the EmpID in ascending order. All fields
from query are to be included in report and report should have same
name as query
13. Add your full name and ID number as a Page Footer in the report
(bottom left, below the date)
Employee Emp ID Name Address H-1002-1 Martha Reid Papine H-1002-2 Monique Rowe Spanish Town H-1002-3 Mandie Jacobs Papine N-1003-1 Zarah Welsh Barbican N-1003-2 Marley Walker Papine N-1004-3 Candy Powell Barbican B-1004-1 Rick Parker Barbican B-1004-2 Samantha Porter Portmore B-1004-3 Kimone Sawyer Barbican F-1005-1 Marsha Moore Portmore Telephone (876) 869-0000 (876)222-2200 (876)669-9856 (876,598-7895 (876)653-8585 (876888-8858 (876,555-6689 (876)896-8778 (876)669-9856 (876)821-2345 Position Loctician Cosmetologist Cosmetologist Nail Technician Nail Technician Nail Technician Masseur Masseuse Esthetician Makeup Artist Client ClientID Name C-001 Melissa Reid C-002 Mark Wellington C-003 Samantha Brussel C-089 Dave Rose Telephone (876,563-5278 (876)226-6633 (876,510-0000 (876)999-8999 ServiceID EmpID H-01 H-1002-1 B-01 B-1004-2 F-01 B-1004-3 N-01 N-1003-1 Service ServiceID H-01 B-01 F-01 N-01 P-01 P-02 P-03 Services Hair Body Face Nail Combination: any two services Combination: any three services All four services
a. Show all clients that are in the Client table (save the query as
client query)
b. Show all employees that are in the Employee table who has a
client in the Client table (save the query as employee client
query)
c. Show all services that are currently being offered to clients in
the Client table (save the query as client service query)
d. Show all employees living in Barbican (save the query as
Barbican query)
e. Show all employees living in Papine OR Cosmetologist (save the
query as Papine OR Cosmetologist query)
f. Show all employees living in Barbican AND Nail Technician (save
the query as Barbican AND Technician query)
g. Show all ID numbers that start with H- (query should be based on
Employee table and be called ID Numbers for Hairdressers)
9. Create Columnar forms for all tables (all fields are to be
included, forms should be called Clients, Employee and Services
respectively).
10. Set the Sunken Special Effect format on all the data fields in
the Client form.
11. Disable the ServiceID and EmployeeID field in Client
form.
12. Create a Tabular report based on the Barbican AND Technician
query. Sort the report by the EmpID in ascending order. All fields
from query are to be included in report and report should have same
name as query
13. Add your full name and ID number as a Page Footer in the report
(bottom left, below the date)
- Create Queries To Display All Fields A Show All Clients That Are In The Client Table Save The Query As Client Query 1 (63.28 KiB) Viewed 31 times