Individuals, IT Professionals and Businesses To talk to us, Call 01492 623887 |
|||
Microsoft Access 2000 DeveloperThis series of courses will provide IT professionals with the knowledge and skills necessary to design and implement database solutions using Microsoft Access 2000. At the completion of this course, students will learn to identify the guidelines for selecting database architecture; create the key objects in a database application and generate outputs; identify the measures to secure a database, retrieve data from an Access 2000 database; customize forms, use forms to accept validated data, and navigate between controls and records in a form; customize reports and create advanced reports for displaying data; and customize, enhance, and deploy a Data Access page, identify the basics of Access 2000 programming; identify the constructs that are used to control the flow of a program; write Sub and function procedures; and write event procedures for responding to user actions in an Access 2000 application. to manage data in tables by using ActiveX Data Objects (ADO) recordsets and SQL; identify code to create and manage stored procedures and triggers; and identify errors and code to create error handlers, learn to enhance the user interface by implementing toolbars, ToolTips, status bars, and help project file; perform common management tasks to ensure better performance of an application; and upsize an Access database to a SQL Server database. AudienceThis course is designed for database programmers and developers who want to design and implement database solutions using Microsoft Access 2000. Course ContentsDatabase Design
Handling Data
Creating Applications
Debugging Applications
Completing Applications
DeliveryComputer Based Training (CD-ROM) - Self Study ContentInteractive, skills-based with full testing for exam preparation DurationApprox 40 - 50 hours QualificationsKeimos Certificate of Study Pre-requisitesMicrosoft Access Expert level or similar experience Click here to get a free information pack Need to talk to somebody about the Courses? Then call us on 01492 623887 Distance learning/Self StudyAll courses are designed to offer you the student the convenience of studying from the comfort of your own home or workplace, working at your own pace in the way that is most suited to your lifestyle and career commitments. Working at your own pace means that you are more likely to learn the subject in-depth as you are not under pressure to compete with other students who may be better or worse than, so you will never lag behind or be waiting for somebody to catch up. Keimos Database CoursesOur courses use simulations extensively to provide opportunities for students to learn & practice skills-based content. This “learning by doing'” model is far more effective than the traditional true/false, multiple choice approach. Live application software is not needed. Interactive content is used often in the courses to engage the learner's attention, to reinforce and exercise skills being taught, and to provide feedback on the learner's grasp of a skill or concept. Top |
Database Courses |
A database operations manager is responsible for organising, operating and maintaining information in a database. Databases store information such as customer names and addresses, stock records or accounts. Many organisations use databases including:
As a database operations manager, you should:
There is no single route to becoming a database operations manager - the main
requirements are having the right knowledge, skills and experience for the
job. Qualifications are an important part of demonstrating these, and although
a degree is often required, there are many other recognised academic and vocational
qualifications.
Whilst the larger graduate recruiters may take trainees from any discipline,
smaller employers generally require knowledge in specific computer languages,
software packages or operating systems. Many employers will require a good
honours degree. For others, experience in programming will help.
Many database operations managers move into this work from the business side
of an organisation. However, they must have some experience in systems programming
or systems design, and they often have a degree or higher national award, which
can be in any subject. Experience can be just as important as qualifications
for many jobs.
The majority of training is on the job, supplemented by short internal or
external courses as appropriate, and progress will be helped by taking additional
manufacturers courses. Some IT companies offer specific certifications
in their products.
Graduate Apprenticeships in IT may be available for people in England. These
integrate study at degree or diploma level with structured work-based learning.
Many young people enter IT work directly through Modern Apprenticeships at
Foundation and Advanced level, or Skillseekers and Modern Apprenticeships in
Scotland. There are no set entry requirements but employers will want to be
sure that applicants are motivated, enthusiastic and can benefit from the training.
Opportunities can arise within any organisation that makes use of computerised
databases.
Specialist information technology bureaux, which provide a database service
to clients, also employ database operations managers.
Managers can progress in their career by moving to another employer for a post
with greater responsibility. Alternatively, they might transfer their skills
to other areas of computing work, such as systems analysis, network management
or general management.
Self-employment or freelance work is sometimes possible, and there are an increasing
number of experienced database operations managers who do contract work.
Curriculum is designed to give the Oracle Database Administrator (DBA) a firm foundation in basic administrative tasks and provide the necessary knowledge and skills to set up, maintain, and troubleshoot an Oracle8i database. Participants will learn about the concepts of relational databases and the SQL and PL/SQL programming languages, database administration strategies and procedures provided in Oracle8i, the critical skills for planning and implementing database backup and recovery strategies.
The Microsoft Certified Database Administrator is specifically for professional who implement and administer Microsoft SQL Server databases. Individuals who derive database designs, manage and maintain databases, configure and manage security and install and configure Microsoft SQL Server would benefit from this course.