MOA621S - MEDICAL OFFICE APPLICATIONS 2B - 2ND OPP - JANUARY 2023


MOA621S - MEDICAL OFFICE APPLICATIONS 2B - 2ND OPP - JANUARY 2023



1 Page 1

▲back to top


nAm I BIA un IVERSITY
OF SCIEnCE Ano TECHn OLOGY
FACULTYOF COMMERCE; HUMAN SCIENCEAND EDUCATION
DEPARTMENTOF GOVERNANCE& MANAGEMENT SCIENCES
QUALIFICATION: BACHELOR OF BUSINESS AND INFORMATION ADMINISTRATION
QUALIFICATION CODE: 07BBIA
LEVEL: 6
COURSE: Medical Office Applications 2B
COURSE CODE: MOA621S
DATE: JANUARY 2023
DURATION: 3 Hours
SESSION: PRACTICAL
MARKS: 160
EXAMINER(S)
MODERATOR:
SECOND OPPORTUNITY - QUESTION PAPER
Ms L Beukes
Ms A Schroeder
INSTRUCTIONS
1. Answer ALL the questions.
2. Read all the questions carefully before answering.
3. Make sure your name, surname, question number and the date
appear in the Header and Footer.
THIS QUESTION PAPER CONSISTS OF 6 PAGES (Excluding this front page)

2 Page 2

▲back to top


\\
Question 1
Marks: 35
Type the following docurlient neatly on A4-Portrait paper. Ensure that you execute
all the instructions at the end of the second page. Use normal margins, font Arial,
font size 12, and the correct line spacing.
Typist:
___ Main Heading: Virtual Offices
Use the Word Art description Black, Text 1, Outline
,B..a..ckgroundl, Hard Shadow Background 1, u/c, cent
2.What Is a Virtual Office?
A virtual office gives businesses a physical address and off ice-related services
without the overhead of a long lease and administrative staff. 2.1 With a virtual
office, employees can work from anywhere but still have things like:
a mailing address,
phone answering services,
meeting rooms, and
Insert round Bullets, s/s
videoconferencing.
1.The yirtual office
Location is becoming less importantessential to organizations as work is
becoming something you do, not someplace you go.
Just as there are varying degrees of virtuality, there is also a variety of mobile
and remote work environments to understand -«-----
insert 1st reference
Greater
Productivity
c::=:::J
c::=:::J
Free workers from
administrative tasks
3.Advantages and Disadvantages of a Virtual Office
The ~peal of a virtual office to users is twofold.
3.1Advantages

3 Page 3

▲back to top


3.1.1Fi1°si:,-#\\-emMonthly cosi· of a virtual office is for less
than that of a traditional o.ffice. 3.1.3 No waiting for a lease to
expire or incur1°ingthe cosi" of a broken lease.
D.r, 3.1.2 Virtual offices h-a-5-R-eh"-e-0-f-N-o'fhm-ea-intenance and upkeep cosi•s, nor does
it need to be staffed.
3.2Dis<:evantages
3.2.156me of the services that a vi1"tual office arrangement offers require pr':f-
Cplanning to utilize.
For e><ample,many pa-&kagesco,'fte-Vo#-h"'-i-i-1'!'1-i-=!=-ea-1¥'.J€:-<3f--ceH.:of-rei"-el'l€-e-N-OlnS
· · teleconferencing and vi-e-eoconferei"l-€-H~
3.2.3 Usis may find the lack of flexibility limiting and inconvenient.
3.2.4There is also the potential for distractions i•hat come with working from
home and therefore so1r:re--lNef'-kcm1~igsh-=r--,'\\ob·er~s productive when operating in
a virtual office envirol1l'1'1-€1w'1h-ic'Fh influence p1"oductivity~
snsert 2 nd
reference
-3.2.2 Virtual offices also may have restricted access on nights and
Insert Drop
weekends*. Insert Footnote
Cap~
With a virtual office, employees can work from anywhere but still have things
like a mailing address, phone answering services, meeting rooms, and
videoconferencing.
INSTRUCTIONS
1. Type paragraphs in chronological order.
2. Use drawing tool to insert the correct shapes (Diamond, Oval &
Rounded Rectangle)
3. Footnote- "Not applicable to all virtual office users" (Bold, Italics, 10)
4. Insert Picture Watermark- use picture with trees {Scale 100%,
washout)
5. Insert Page numbers (excluding 1st page).
Table of Content Information:
6. Heading 1 - Paragraph Headings 1, 2, 3 {Font size 14)
Heading 2 - Paragraph Headings 3.1. 3.2 (Font size 13)
Please insert the following references:
7. Use the two links in the given folders to insert the references)
8. Insert Reference List.
9. Insert a Table of Content (Automatic Table 2).

4 Page 4

▲back to top


Question 2
TOTAL: 30
Retrieve the ProfsFinancial and adhere to the instructions that follow:
INSTRUCTIONS
1. In the Database ProfsFinancial use the table Sales M to
create a simple query that will display the Client First Name,
Product Name, and Investment Amount.
2. Use the table Products to create an action query that will
display the products that use mutual funds.
3. Use the tables Products & Sales M to create a joint table.
Please delete the current link by right-click on the link and
press delete. Create a new link with Commission. Create a
query that will display the clients who received commission of
60 from the suppliers of Laurier only.
Under Reports use Reps1 to format the report.
3. Create a header titled AGM Report - Font Lucida Sans,
Size 20, Bold, u/c, Colour - Blue Green, Theme - Slice.
4. Page number which shows the current page and total number
of pages - bottom right corner.
5. Insert Today's Date only in the top right corner. (Full Date).
6. Insert AGM Logo from the folder next to the title in the top left
corner.
7. Insert your name & student number in the header.
8. Go to layout view and resize all columns to fit perfectly.
9. Print all queries as well as the report.

5 Page 5

▲back to top


QUESTION 3 - PUBLISHER
[35]
The following ql!estion is an Invitation that contain information about a virtual baby
shower. Please-design the Invitation Card according to the instructions below.
Insert Baby Shower Card - Under Built It Templates, Invitation Cards, Baby Shower 5.
Colour Scheme: Teal
Font: Comic Sans
Page Size: Quarter-Sheet Top Fold
Page 1 -Top Front Cover
BABY SHOWER INVITATION- Font: Curlz MT, 24
Page 2
Delete top part - 1st block
2nd Block-type the info below in Colonna MT, 16, cent:
HONORING
LAUREN HAUKONGO
&
BABY RODGER
Page 3
1st Place holder: Type the following in Font: Informal Roman, 10, u/c, cent.
Please join us for a virtual baby shower to celebrate little Rodger
2nd Place holder: Font Comic Sans, 10, Bold, Cent
Contact person: 0813331717
3rd Place holder: Type information below, Font: Comic Sans, 8, cent. Please bold
date and time.
Lauren will be opening gifts via Facebook live on
Saturday, 12 November 2022, at 16:00
Please text Lauren for a direct link & details how to join.
Last Place holder: Font: Calibri, 11, cent, Bold Mailing Address.
Mailing Address:
Lauren Haukongo, 27 Beethoven Street, Windhoek-Wes
Registry: Baby Company & Amazon
Page 4: Back of Invite
Please use online picture to insert a picture of "Baby in pram clip art" - center position.

6 Page 6

▲back to top


ELIXIR PAPER
MARKS: 60
Start Elixir and log into the General Practice option.
Swakopmund Medi-City has just implemented Elixir at the practice. As the new appointed Medical
Administrator and having the knowledge and experience, use the information given below to set-up
the practice from scratch with the Elixir programme.
1.
Create the following Service Providers for Swakopmund Medi-City.
-
-1
I
Dispensing
2 Provider DisciplineHPCSANCRellular
E-mails DispensinRgegistration
3 DrKuhNnills Urologist 0065656,0.8812323n00ku0hn@gmail.com Yes
4 DrMichaEerl asmuGsenerSaul rgeo0n07565609812321m11e1rasmus@iway.comN.ona
5551245
5 DrNyathKieletsoNeurologist 0085657008123235n5ke5letso@iafrica.comY.neas
5557896
C
2
Add the following patient accounts from the excel spreadsheet correctly.
-l Account
2 NumberSsurnamFeirsntame
3 SAU00S1aundersRoennelle
4 KOCH0K0o1ch Rodney
5 BAU00B1aumannSolomon
6 ROOI0R01ooi Anna
MedicAaIlD
IDNrs PostAalddress Town Scheme Provider
640101001P0O7B0o02x014 RUNDU NHBPRONDCrKEuhNnills
701812001P0O7B0o0x2451 OTJIWAROINNVGEOSTMDErMDichaEerlasmus
781610001P0O7B0o02x547 OHANGWENNAAPOTELDrNyathKieletso
801212000P1r2iv4a5Btea4g578WINDHOEKNAMDEBDrKuhNnills
3
Add the following medical aid numbers (references) to the existing accounts.
-1 Account
2 Number
3 SAU00l
4 KOCH002
5 BAU003
6 ROOI0Ol
Medical Aid
Number
811456
812458
813478
814787
4.
Insert the following Accounting groups to your Database and delete others:
4.1 Normal - White
4.2
Claim date expired - Orange
4.3
Benefits Exceeded - Yellow
4.4 Handed Over - Blue
5.
Clinics:
Consulting Rooms
Swakop Clinic
Tamariskia Clinic

7 Page 7

▲back to top


6
6.
Please add the following reasons to the Rejection list and delete the others.
6.1 Limits Exceeded
6.2 Wrong Dependent
6.3 Claim date expired
7.
From your existing accounts, please open the following accounts please add the following
dependants on their accounts.
MAIN MEMBER
Ms Ronelle Saunderson
Ms Anna Rooi
DEPENDANT
Zanelle Saunderson {001)
Date of Birth: 11 September 2010
Medical Aid nr: 67788
Allergies: Citric Acid
Jason Rooi (01)
DOB: 17 August 2015
Med Aid Nr: 677989
Allergies: Atenolol
8.
Please create the following Macros:
Macro
GenlOl
Ankle
011
End
104
Procedure
General Surgery
Ankle Surgery.
Endocrine Surgery
Your Code
6507
ROAB
35YR
96Al
Q5J5
lAIR
3D67
PA72
U893
XP87
E354
1J15
Description
Shoulder
Dressing Tray
Syringe 5ml
Linen Saver
Gloves non sterile
Ankle Brace
Tray Dressing
Panado Cap
Anaesthetic
Injection
Gloves
Needle
9.
Post the following Macro's to these patients:
General Surgery- Rodney Koch
Ankle Surgery - Solomon Baumann
Endocrine Surgery-Anna Rooi
10. Settle the Payments
Receipt Numbers
General Surgery- Rodney Koch (500101)
Foot Surgery - Solomon Baumann {5005656)
Endocrine Surgery-Anna Rooi {5002621)
11. Print the Daily Transaction Report to verify all the transactions for the day.