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.