Home / Video / MS-Access Exercise

MS-Access Exercise

Download the Database File

Tutorial 1

  • Start the Database software.
  • Set up the following database with the file name : Lawyer
Field NameData Type
REF NOText
LAWYERText
CLIENT NAMEText
DAYText
TIMEDate/Time
PREVIOUS VISITSNumber

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

Tutorial 2

  • Open the Database Lawyer
  • Changer the following Fields properties
Field NameProperties
REF NOInput Mask “L999”
LAWYERField Size (15)
CLIENT NAMEField Size (20)
DAYCombo Box
TIMEFormat “Short Time”
PREVIOUS VISITSNumber
  • Enter the following Records
REF NOLAWYERCLIENT NAMEDAYTIMEPREVIOUS VISITS
J120PATELJONES LWED09:306
J561PATELSMITH CTUE12:0010
M124PATELCLARKSON JSAT16:004
N657PATELGRIGGS SFRI13.4510
C780COLLINSDENT JSAT09:0012
E120COLLINSJENKINS ZWED10:300
L833COLLINSDENNIS MSAT10:008
H777COLLINSMOWHILL SFRI17:4512
G652McBRIDEHARMAN DTHU11:0012
Y444McBRIDEPETERS HFRI18:306
R567McBRIDECLARKE FSAT09:300
H800McBRIDEPAUL GSAT11:006
D437McBRIDEMULERO MWED15:002
G123SIMPSONANDREWS CWED10:006
H321SIMPSONGOODYEAR KWED11:006
L909SIMPSONSTEWART JSAT12:0010
F549SIMPSONGREGORY ATHU16:0010
  • 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 NAMETITLE
JONES LMISS
SMITH CMRS
CLARKSON JMS
GRIGGS SMISS
DENT JMR
JENKINS ZMR
MOWHILL SDR
HARMAN DMISS
PETERS HMS
CLARKE FMR
PAUL GMR
MULERO MDR
ANDREWS CMR
GOODYEAR KMS
STEWART JMR
GREGORY AMISS
SAMUEL SMR
  • Save and print the table.
  • Close the database file.

Tutorial 3

  • Open the database Lawyer saved in Tutorial 2.
  • 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.
  • Save and close the file.

Tutorial 4

  • Open the database Lawyer.
  • 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 NOLAWYERCLIENT NAMEDAYTIMEPREVIOUS VISITSTITLE
B421COLLINSMUSGROVE DFRI16:002MR
H555PATELDANIEL ZTUE10:000MISS

Tutorial 5

  • Open the database Lawyer.
  • 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.

About admin

Check Also

WhatsApp Web Now Lets you Create Custom Stickers

WhatsApp Web Now Lets you Create Custom Stickers ஸ்டிக்கர்களை உருவாக்க அனுமதிக்கும் புதிய அம்சத்தைச் சேர்த்துள்ளது வாட்சப் …

Leave a Reply

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