Objectives
At the end of the course, students will be
able to:
Understand the history and evolution of the personal computer.
Understand the names and functions of the key components in an IBM compatible computer.
Understand the name and function of the most common PC Peripherals and basic operating
system concepts.
Understand the role forms and reports play in a business application.
Understand the purpose of controls and identify the usage of standard Windows controls.
Understand design principles that you should use when creating Windows applications.
Understand why flat file data organization is not used in modern databases.
Define and understand terms that pertain to relational database design.
Describe the history of SQL.
Specify SQL syntax for retrieving records from a database.
Join multiple tables in a query and specify search criteria and sort records.
Understand the basics of what a program is.
Understand the purpose of variable and constants and how to use them in programs.
Understand the purpose and role procedures play in application programming.
How to create procedures and use them in programs.
Control program execution with decision control structures.
Cause programs to repeat statements with looping structures.
Create a simple database application. topCourse Contents
Evolution of
Personal Computer Business Applications
Understand how the microprocessor was the enabling technology of the personal computer.
Understanding the evolution of business application software during the 1980’s
Understand the role of IBM in proving to the business world that the PC was a viable
business tool
Recognize a significant barrier to the success of the IBM compatible PC as a viable
business tool
Understand the role and essential importance of the graphical user interface in the
evolution of business application software
Understand how Microsoft dominated the operating system and business application software
market. top
Introduction to
Personal Computer Systems
Describe the basic components in a personal computer and how they interrelate
Define hardware, software, programs and operating systems
Define IBM PC compatible
Understand the role of the motherboard and how it hosts the other components of a personal
computer system.
Distinguish between the most common system buses used on IBM PCs today.
Understand how the BIOS helps configure and control computers.
Understand what a microprocessor is
Distinguish between the processors in the Intel x86 line
Describe what RAM is
Describe what ROM is
Describe what cache is
Describe what CMOS is
Describe what serial ports are
Describe what a Universal Serial Bus is
Describe what a Fire Wire is
Describe what a parallel port is
Describe what floppy drives are
Describe what a hard drive is
Describe what disk controller s are
Describe what removable media drives are
Describe what tape drives are
Describe what the console is
Describe what displays are
Describe what video adapters are
Describe what the most common types of input devices are
Describe what multimedia devices are
Describe what sound cards are
Describe what optical disks are
Describe what digital cameras are
Identify the various types of printers that exist
Describe what modems are
Describe what terminal adapters are
Describe what network interface cards are
Describe what network protocols are
Describe the role of an operating system
Compare and contrast; single task, multitask and multithread operating systems
Describe what a graphical user interface is
Understand how disks are organized
Understand how to manage hard drives
Understand how memory is configured in a PC
Describe what virtual memory is
Describe how virtual memory can be configured top
Developing a User Interface
Definition of forms and why they are used
Describe why reports are useful to a business application
Identify standard controls used in Windows applications and describe their purpose
Describe how each standard control contributes to the design of a user interface
top
Introduction to
Relational Database Concepts
Understand what it means to organize data in a flat file structure
Understand the negative consequences of flat file structures
Understand the concepts at the heart of relational databases
Understand foundational terms associated with relational databases
Understand the practical implementation of relational database constructs
top
Introduction to SQL
Understand the history of modern relational database access
Describe the purpose of SQL
Create an SQL Select statement to retrieve records from a database
Use aliases to include expressions and calculations in query output
Retrieve a list of unique values from a field or table
Specify multiple sort orders and search criteria
Specify criteria for values within certain ranges
Join tables together to access fields from multiple tables top
Constructs of Programming
Language
Describe what a program accomplishes
Understand simple program commands
Understand the purpose of variables in programs
Differentiate between types of variables
Declare variables and use them in programs
Understand the purpose of constants and their use
Understand what is meant by procedural programming
Understand the purpose of procedures, how to declare them and how to use them
Understand more about the scope and lifetime of variables top
Program Control Structures
Understand the importance of decision control structures in programming
Use the If…End If and Select…Case structures to conditionally execute program
statements
Understand what looping structures are
Know why applications use looping structures
Use the Do and For looping structures in a program top
Creating a Simple
Database Application
Create a simple form for data input
Use a database table as a record source
Add program code to enhance the functionality of the form top
Particulars:
Cost: £1550(
€ 2480)
excluding VAT
Platform: Windows NT
Numbers: Maximum of 6 people on each course at F1’s training facilities in London and Bath top |
