This is today’s comment

I am happy today. Merdeka!

My Portfolio

Microsoft TechEd 2008 Small Poster for MCSB KL


















Banner for MCSB KL




Azmi Aziz Profile

:: Objective
An opportunity to obtain a challenging position in IT training with an organization that provides exceptional growth potential

:: Education
1997-2000
Diploma in Information Technology
Nanyang Polytechnic, Singapore

1993-1994
GCE A Levels
Catholic Junior College, Singapore

1989-1992
GCE O Levels
Teck Whye Secondary, Singapore

:: Core Marketable Attributes
Skills include:
Fine communication & interpersonal skills
Natural flair for teaching
Burning desire for success
Positive mindset & attitude
Strong presentation and public speaking skills
Ability to empathize and see things from another person’s perspective
Open-mind & always searching for new frontiers of knowledge to explore

:: Courses & Seminars Delivered in Corporate Training
Microsoft Office Systems
Adobe Application Programs
...
Access(97- 2007)
Photoshop CS2
Vista
Excel (97-2007)
Macromedia Flash
CSS Scripts
PowerPoint(97-2007)
Adobe Premiere
Javascripts
Outlook(97-2007)
Dreamweaver
HTML
Project(97-2007)
Fireworks
Mekkographics(charting tools)
InfoPath 2003 & 2007
Freehand
Crystal Xcelcius
OneNote 2003 & 2007
Expression Web
Publisher 2003 & 2007
Groove 2007
Word(97-2007)
Excel VBA
Access VBA

:: Working Experience

Consultant Trainer
Dec 04 - Feb 07
Avantus Training Pte Ltd
Duties include:
Providing professional consultation on Microsoft products to corporate clients
Marketing softwares by conducting live demonstration in seminars
Delivering excellent training programs to corporate students (Government & Private sectors)
Constructing high quality deliverables (Customized course wares for specific clients)
Imparting special Microsoft Office System tips & tricks with Productivity @ Work tools
Responsible for internal training website (Design & Planning)
Infecting the company with humorous culture

...
Consultant Trainer
Dec 02 – Dec 04
Comat Training Pte Ltd
Duties include:
Providing high quality IT application training to corporate/ schools students
Creating course wares for lessons
Running live demonstration for launch of Microsoft products

...
Internal Trainer
Dec 00 – Dec 02
Overseas Chinese Banking Corporation Bank
Duties include:
Facilitating in leadership, team building and bonding camps for staff
Conducting presentation skills and communication skills techniques
Providing Microsoft office application training to internal staff
Conducting training using banking system for induction programme and refresher courses
...
Relief Teaching in Primary & Secondary Schools
Jan 95 – Apr 97

:: Certifications

Train The Trainer
PSMB
Perbangunan Sumber Manusia Berhad
Malaysia

Microsoft Office Specialist Master
2003

Microsoft Office Specialist Master
2002

Microsoft Office Specialist Master
2000

:: Hobbies
Parenting

Action Packed Movies

Sports - Soccer

Self-Improvement

Ease your way through Microsoft Access!

Access Objects Short Definition

table - store information
query - get selected records
forms - navigate, enter, delete informations
reports- print or preview records
pages - html format
macros - fine tune system using built in commands
modules - visual basic programming for access, create customise functions

What is Primary Key? Its something that is ...
- unique
- required
- link tables


Filtering In Access Tables

Finding Records between 1500 and 2000 in range
1. Right click any of the numbers
2. Choose Filter for:
3. type between 1500 and 2000 in filter for box
4. Press Enter

or Filter for: >=1500 and <=2000
--------------------------------------------------------------
How do i filter date?

1. Right click any of the dates
2. Choose Filter for:
3. type between 1/1/92 and 31/12/92 in filter for box
4. Press Enter

or Filter for : >=1/1/92 and <=31/12/92
or Filter for: *92
-----------------------------------------------
How to use * or ? in finding records?

* Sales -- ends with Sales
Sales * -- begins with Sales
* Sales * -- contains sales
C???? --- finding 5 characters only and starts with C

Finding Not Equal to ...
Filter For: <> Sales
Filter For: ! Sales
Filter For: not sales

----------------------------------------------------
view only staff > 5 years of service Query

(today's date - hire date) / 365 >5 years

1. must be below Hire Date Field Name
2. Criteria: (now()-[Hire Date])/365 >5


simple query

criteria: "usa" <--- hard coded
-------------------------------------------------------------------------------------
Using Search Query

search employee by ID Query
1. go to Query Object
2. Create query in design view
3. Get Employees Table
4. Include all fields
5. from Employee ID column, Criteria: [enter employee Id]
6. save query: Q Search Employee by ID
--------------------------------------------------------------------------------------
search employee by hire date Query
1. go to Query Object
2. Create query in design view
3. Get Employees Table
4. Include all fields
5. from Hire Date Column,
Criteria:
"enter either one syntax"
between [enter start date] and [enter end date]

>=[enter start date] and <=[enter end date]
6. Save Query: Q Search Employee by Hire Date

How do i combine field names together?
(Concatenation)

1. Insert a new column
2. From Field:
Names:[First Name]& " " &[Last Name]

------------------------------------------------------------------------------
calculated Query

Total Amt = Quantity * Unit Price

1. go to Query Object
2. Create a new query design
3. get "Order Details" table
4. include all fields
5. from end of column, Field: TotalAmt:[Quantity]*[Unit Price]
6. Press Enter twice
7. Run query
8. Save query as "Q Total Amt Before Discount"

-----------------------------------------------------------------------
Custom Format for Currency
$ #,##0.00

"RM" #,##0.00

#,##0.00 "Kg"

¥(Atl+157) #,##0.00
-------------------------------------------------------------------------
Find Total Amt After Discount Query
Total Amt = Quantity * Unit Price *(1-Discount)

1. go to Queries Object
2. Create a new query design
3. get "Order Details" table
4. include all fields
5. from end of column,
Field: TotalAfter:[Quantity]*[Unit Price]*(1-[Discount])
6. Press Enter twice
7. Run query
8. Save query as "Q Total Amt After Discount"
-----------------------------------------------------------------------------
create a new query table that showcase only employees
> 5 years of service, show new salary, increment of 5%

Old Salary New Salary
$1000 $1050

1. go to Queries Object
2. Create new query in design view
3. Get Employees Table
4. Include First Name, Last Name, Hire Date, Basic Pay
5. go to end of column, Field: New Pay:[Basic Pay]*1.05
6. Under Hire Date Column, Criteria: (now()-[Hire Date])/365>5
*** get increment from user, then use this
[Basic Pay]*(1+[enter increment])
7. Press Enter twice
8. Save Query as Q New Salary for >5 years of service

--------------------------------------------------------------------------------
Finding Customer without orders

1. Go to Queries Object
2. Click on "New" Button above
3. Choose Find Unmatched Query Wizard
4. Screen1: Choose Customer Table, choose next
5. Screen2: Choose Orders Table, choose next
6. Screen3: Link Customer ID<=> CustomerID, choose next
7. Screen4: Display all fields, choose double arrow(center),choose next
8. Screen5: Name your queries: Customer without orders
9. OK
------------------------------------------------------------------------------------

Why we need forms in access?

- easy to navigate records
- user friendly interface
- delete records easily
- add new records with big "ADD" buttons
- search records, filter records
-----------------------------------------------------------------------------------

Free Software Increasingly a Benefit to Business IT

Cool Apps for FREE
www.zoho.com

Minority Report Movie Comes True!
www.microsoft.com/surface

Adobe launch Online Word Processor!
www.buzzword.com

Learn Microsoft Office for FREE
www.functionx.com

Excel at Its Best
www.exceltip.com
www.mrexcel.com


Free Photo Editor!
www.getpaint.net - very small file, easy to use, lightweight version of photoshop

www.gimp.org - more detailed


Free Font Type
www.007fonts.com

Two Search engine in One - just for the fun of it...
www.polycola.com
no more www.gahooyoogle.com
try search something and your browser will split into 2!

Free PowerPoint Templates
www.brainybetty.com

Simple Online Money Tracking & Budgeting
www.budgetpulse.com


A free and small personal web server for Windows and Linux
www.aprelium.com


Nice Cute Background Pictures
www.itypeit.net

Working Smart with Outlook!

How do i create email with nice background?
1. Action --> New Mail Using --> More Stationery...

How do i create a new autosignature?
1. Tools --> Options
2. Mail format Tab(top)
3. click on "Signature" button
4. Click on "New"
5. Type New Title
6. Type your name, company, contact no, email, etc
7. OK

note:---------------------------------------------------------------------------
When creating new email, outlook uses word format.
When sending email, outlook uses html format.

1. copy and paste animated(moving) picture into your mail.
note: you wont see it moving until you send your mail out.
go to send items to view your animated picture inside your
send mail.
---------------------------------------------------------------------------------------------

how do i send voting email?
1. Click new email
2. go to options
3. click on voting buttons
4. type your list and separate by ;
eg. yes;no;maybe


how do i track my email?
1. go to send item folder
2. open voting email
3. click on "tracking" tab

how do i color email messages with conditions?
1. View --> Arranged by --> Custom...
2. Click on Automatic Formatting
3. Add New title
4. Choose format, add color and bold
5. click on Condition Button, eg from azmiaziz@demo.com
6. Click OK(3 times)


how do i create a new personal folder file(pst)?
1.File --> Data File Management
2. Click "Add"
3. Type name of pst file
4. Choose location of pst file
5. Type name of folder in your mailbox
6. OK

how do i open pst file?
1. file --> Open --> Outlook datafile

Be Creative Using PowerPoint

Really Simple steps to create powerpoint presentation

1. start powerpoint 2003
2. enter title/subtitle
3. insert new slide
4. enter title/content
5. repeat step 3 & 4
6. choose slide design
7. run slide show

how do i create new presentation from template?
1. file --> New...
2. On my computer(2003) / General Templates (2000, 2002)
3. choose templates


how do i change my color design?
1. Format --> Slide Design
2. From Slide Design(task pane-right)
3. Choose Color Scheme


how do i get to my slide master?
View --> Master --> Slide Master

how do i choose my own background?
1. insert picture from file
2. resize picture
3. change to washout
4. send to back

how do i apply custom design to existing presentation?
1. open presentation
2. Format --> Slide design
3. from slide design task pane(bottom)
4. Browse...
5. locate your design file
6. OK


how do i bring my word content to powerpoint without copy and paste?
1. change content to heading style
2. word file must be close when importing outlines

how do i add animation to my pictures?
1. slideshow --> custom animation
2. select picture --> add effects(right pane)

how do i make my slide/my animation self running with timing?

1. slideshow --> slide transitions
2. check automatically after option bottom right pane
3. add timing for every slide

how do i make my presentation loop? i.e going back to slide one again.
1. slideshow --> setup show
2. choose browse at a kiosk (choice from top left)

how do i convert my powerpoint file to powerpoint show?
(*.ppt) --> (*.pps)
1. File --> Save As...
2. Save as type: PowerPoint Show(*.pps)

You Can Be An Excel Guru Too!

Shortcuts and More shortcuts!
Tips and More Tips!

Nice Excel Reference to get make you fall for Excel
www.exceltip.com
www.mrexcel.com
www.functionx.com


How do i select entire list using shortcut?
Press : CTRL + SHIFT + Down Arrow

How do i convert date into text with my format?
=text(select date cell, "dddd")

how do i convert my currency to RM?
1. select cells
2. format --> cells
3. Custom
4. Type "RM" #,###0.00
5. OK
show me

How do i convert my currency to ¥?
1. select cells
2. format --> cells
3 Custom
4 Type press ALT with 157 #,###0.00
5. OK















How to lock only one cell?
1. select all the cells in the worksheets. Press Ctrl + A.
2. go to Format --> Cells...
3. from the Protection Tab, remove the locked cell, i.e unchecked the locked cell
4. click OK
5. select the cell you wish to lock, that only one cell.
6. go back to format --> cells...
7. from the protection tab, check the locked cell.
8. click OK
9. go to Tools --> Protection --> Protect sheet...
10. enter password, reconfirm password
11. OK



How do i toggle between fill series and copy cells?

if u drag using the + sign and the number increase, then u drag with pressing down your control key.
1. select the cell to drag down.
2. point to the bottom right of the cell u select and u see the fill handle
3. dont drag yet, press down ctrl key, u will see another plus sign above the fill handle
4. drag down while holding your ctrl key



Reference in Excel

* Relative Reference E7

* Absolute Reference $E$7

* Mixed Reference E$7 or $E7





how do i find years of service?
=( todays date - hire date )/ 365
=(now() - C6)/365


How do i highlight(format to different color) hire date based on years of service?
1. select range of dates
2. Format --> Conditional Formatting
3. Change "value is" to "formula is"
4. = (now()-first hire date cell)/365> reference cell
5. Format cell - bold, red text
6. OK

How do I change date to serial number?
1. select date
2. press CTRL+SHIFT+ ~


free fonts
www.007fonts.com


How do i record my RM macro?
Go to tools --> macro --> record new macro or bring out visual basic toolbar
1. Start Recording
2. Format --> Cells...
3. Custom Format
4. Type "RM" #,##0.00
5. OK
6. Stop Recording


How do i record cent symbol macro?
Go to tools --> macro --> record new macro or bring out visual basic toolbar
1. Start Recording
2. Format --> Cells...
3. Custom Format
4. Type #,##0 press ALT with 155
5. OK
6. Stop Recording

how do i record my header and footer using macro?
Go to tools --> macro --> record new macro or bring out visual basic toolbar
1. Start Recording
2. View --> Header & Footer
3. Click on "Custom Header"
4. Type Company Name
5. Ok
6. Choose Page 1 of ? from Footer List
7. OK
8. Stop Recording