Home / GIT Online Exam / GIT Online Test – DBMS Exercise 1
dbms

GIT Online Test – DBMS Exercise 1

access 2010


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
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
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
SEE MORE  Learn HTML on Your Mobile
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 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.
SEE MORE  GIT Online Exam - Quiz on Presentation Software

About admin

Check Also

git-tutorials

List of All GIT Post Links

GIT Online Exam  சார்ந்த அனைத்து  பதிவுகளின் இணைப்புகள். List of all GIT Online Exam tutorial links …

One comment

  1. Thanks you sir
    This very helpful for teachers

Leave a Reply

Your email address will not be published. Required fields are marked *

You cannot copy content of this page கொப்பி பன்ணாதீங்க  அய்யா. சுயமா எழுதுங்க