Structured Query Language (SQL) in Access

Download the 2014 Voters Database and follow the following instructions.

  1. Create.
  2. Query Design.
  3. Close ‘Show Table’.
  4. Click ‘View’ in SQL.
  5. Choose ‘SQL View’.
  6. Type SELECT * FROM tblVoters WHERE user_section = ‘2CHROME’
  7. Right-click ‘Query 1’ and click ‘Save’.
  8. Rename Query Design to Section Chrome.
  9. Create a query for Section Excellence, Section Firefox, Section Integrity, & Section Patriotism.

-glenoid

Graduation Song 2015

“Whenever You Remember”

Carrie Underwood

When you look back on times we had
I hope you smile
And know that through the good and through the bad
I was on your side when nobody could hold us down
We claimed the brightest star
And we, we came so far
And no they won’t forget

[Chorus]
Whenever you remember times gone by
Remember how we held our heads so high
When all this world was there for us
And we believed that we could touch the sky
Whenever you remember, I’ll be there
Remember how we reached that dream together
Whenever you remember

When you think back on all we’ve done
I hope you’re proud
When you look back and see how far we’ve come
It was our time to shine
And nobody could hold us down
They thought they’d see us fall
But we, we stood so tall
And no we won’t forget

Whenever you remember times gone by
Remember how we held our heads so high
When all this world was there for us
And we believed that we could touch the sky
Whenever you remember, I’ll be there
Remember how we reached that dream together
Whenever you remember

Yeah, Oh

We claimed the brightest star
And we, we came so far
You know that we, we showed them all
And no they won’t forget

Yeah

Whenever you remember times gone by
Remember how we held our heads so high
When all this world was there for us
And we believed that we could touch the sky
Whenever you remember, I’ll be there
Remember how we reached that dream together
Whenever you remember

Whenever you remember

Oh, whenever you remember

– glenoid

CBT Ready for Assessment

25 Competency Based Trainees are now ready for assessment (September 12-13). May you do your best and make us proud. Cheers!

CBT-13

CBT (Competency Based Training) Batch 1 (July-September 2014) with Sir Glen (extreme left), Sir Donie (seated, first from left), Sir Eduard (standing, center), and Sir Ian (seated, second from right).

– glenoid

How to ‘Think About It’

What are the practical applications of programming?

In the real world, how can we really yield the power of the code and make our own lives easier? Apparently, the answer is all around us. The moment our phone wakes us up from sleep to the our endless hours of posting and browsing through the internet. The question of what applications can we use the skill of programming for can be answered even from the ‘apps’ that we are using.

We are already doing it. It’s happening right now. It’s here.

But for most people, is programming really that practical to learn? The answer is no. Behind the simplicity of the software we are using, are codes that took years for developers to master. This duration of time to accomplish such level of expertise made the trade more of an art – than just a mere skill.

It can be done but it would need time.

But there is one thing we should remember. That all disciplines are inter-related to one another. So there must be something that we can learn from programming that we can incorporate to our daily, normal lives. Like what Steve Jobs said,

Everyone should learn a computer language because it teaches you how to think.

This is not just an exclusive hobby for people with technical inclination towards technology. This is not just a subject or a course you learn online or in school. This is not just something you do for money. Learning it actually helps you in exercising your mind just as you condition your physical body.

You can love it, but you don’t have to. Just like what you used to feel towards shutting that phone alarm that wakes you up every morning.

– glenoid

Midterm Exams Announcement

A few announcements from Sir Glen regarding the Midterm Exams (September 3-5):

  • Compro 6 (For Chrome, is scheduled on September 3; Firefox on September 4)

    • Exam type would be the same as the prelims. Mainly about advance for-loops and arrays.
  • IDP 2 (For Firefox, is scheduled on September 3)

    • Exam type would be the same as the prelims. About DB connection in VB 2010 with search functionality.
  • Compro 2 (For 1C, is sheduled on September 4)

    • Exam type would be the same as the prelims. About conditional algorithms (if-else and if-else if-else).
  • IPC 2 (For CHS2, is sheduled on September 6)

    • Exam type would be the same as the prelims. About for-loops.
  • SAS 1 (For CHS1 and 1C)

– glenoid