Download the database file
Database Management System (DBMS)
- Start the Database software.
- Set up the following database with the file name : Lawyer
| Field Name |
Data Type |
| REF NO |
Text |
| LAWYER |
Text |
| CLIENT NAME |
Text |
| DAY |
Text |
| TIME |
Date/Time |
| PREVIOUS VISITS |
Number |
Note: The
TIME and
PREVIOUS VISITS should be numeric fields. Use
Date/Time for the
TIME field data type and
Field Properties format:
Short Time.
- Make the REFNO as the Primary Key.
- Save the table as: Clients
- Close the database
Table
- Open the Database Lawyer again
- Changer the following Fields properties
| Field Name |
Properties |
| REF NO |
Input Mask “L999” |
| LAWYER |
Field Size (15) |
| CLIENT NAME |
Field Size (20) |
| DAY |
Combo Box |
| TIME |
Format “Short Time” |
| PREVIOUS VISITS |
Number |
- Enter the following Records
| REF NO |
LAWYER |
CLIENT NAME |
DAY |
TIME |
PREVIOUS VISITS |
| J120 |
PATEL |
JONES L |
WED |
09:30 |
6 |
| J561 |
PATEL |
SMITH C |
TUE |
12:00 |
10 |
| M124 |
PATEL |
CLARKSON J |
SAT |
16:00 |
4 |
| N657 |
PATEL |
GRIGGS S |
FRI |
13.45 |
10 |
| C780 |
COLLINS |
DENT J |
SAT |
09:00 |
12 |
| E120 |
COLLINS |
JENKINS Z |
WED |
10:30 |
0 |
| L833 |
COLLINS |
DENNIS M |
SAT |
10:00 |
8 |
| H777 |
COLLINS |
MOWHILL S |
FRI |
17:45 |
12 |
| G652 |
McBRIDE |
HARMAN D |
THU |
11:00 |
12 |
| Y444 |
McBRIDE |
PETERS H |
FRI |
18:30 |
6 |
| R567 |
McBRIDE |
CLARKE F |
SAT |
09:30 |
0 |
| H800 |
McBRIDE |
PAUL G |
SAT |
11:00 |
6 |
| D437 |
McBRIDE |
MULERO M |
WED |
15:00 |
2 |
| G123 |
SIMPSON |
ANDREWS C |
WED |
10:00 |
6 |
| H321 |
SIMPSON |
GOODYEAR K |
WED |
11:00 |
6 |
| L909 |
SIMPSON |
STEWART J |
SAT |
12:00 |
10 |
| F549 |
SIMPSON |
GREGORY A |
THU |
16:00 |
10 |
- Mr M Dennis who was to see Mrs Collins has cancelled. Delete his details.
- Add the following new client for Mr Patel. His name Mr S Samuel and he has booked an appointment for Saturday at 10 am. His reference number is D321.
- Save the file.
- Add a new field to the database TITLE. Enter the clients’ titles as follows
| CLIENT NAME |
TITLE |
| JONES L |
MISS |
| SMITH C |
MRS |
| CLARKSON J |
MS |
| GRIGGS S |
MISS |
| DENT J |
MR |
| JENKINS Z |
MR |
| MOWHILL S |
DR |
| HARMAN D |
MISS |
| PETERS H |
MS |
| CLARKE F |
MR |
| PAUL G |
MR |
| MULERO M |
DR |
| ANDREWS C |
MR |
| GOODYEAR K |
MS |
| STEWART J |
MR |
| GREGORY A |
MISS |
| SAMUEL S |
MR |
- Save and print the table.
Query
- Sort the file into alphabetical order of client name and save the query as SORT.
- Search for all the clients whose appointments day is Wed and save as WED.
- Find all the records of clients whose appointments are before 12:00 and have previously visited fewer than 8 times; Display only Client Name and Time fields and save the query as CLIENT EIGHT.
- Create a Query to Display only the Male clients and save the query as MALES.
- Display All the Client names Starting with Letter “C” and Save the query as CNAMES.
Form
- Create a simple form using the table Clients.
- Change the text of the Field headings to Times New Roman, italic 18pt.
- Change the colour of the background in the field headings boxes to green.
- Save the form as Client Form.
- Enter the following new records through the Screen Form.
| REF NO |
LAWYER |
CLIENT NAME |
DAY |
TIME |
PREVIOUS VISITS |
TITLE |
| B421 |
COLLINS |
MUSGROVE D |
FRI |
16:00 |
2 |
MR |
| H555 |
PATEL |
DANIEL Z |
TUE |
10:00 |
0 |
MISS |
Report
- Produce a report as follows.
- Display all of the records.
- Group by Lawyer.
- Sort in descending order of Client Name.
- Title the report Clients groups by lawyer.
- Add a header with your name and current time of day in Arial, bold, 14 pt.
- Change the report title to Client appointments this week, groups by lawyer.
- Save and print the report.
- Close the database file.