Silicon Beach Training – Office & Business Applications Training

Microsoft Access is a very powerful database application designed to save you time and make creating relational databases easier.

Advanced Microsoft Access Training Course objectives:

By the end of the Advanced Access training course, delegates will have extended their knowledge of Access databases to include using macros to advanced levels. A prerequisite for this access training course is attendance on our beginners access training course or equivalent experience.

This is an intensive 1-day Beginners Microsoft Access training course, introducing delegates to the concepts of creating relational databases using MS Access.

Microsoft Beginners Access training Course Objectives:

By the end of the Beginners Access training course, delegates will be able to create a simple relational database using Access. Our beginners access training course will prepare delegates for our advanced acces training course.

This Access API training course is designed to introduce Access programmers to the power of the Windows API (Application Programming Interface).

In this hands-on Access API training course, delegates will learn to access parts of the Windows code usually outside the scope of Visual Basic by harnessing powerful API functions.

This Access API training course is valuable for every new, recent or intending Access programmer who needs to explore the Windows API.

This ACT! training course will teach students the fundamentals of contact management; how to schedule and keep track of activities with clients, and how to find client information quickly. A working knowledge of Windows is required.

ACT! Training Course content: Getting Started, Creating a Contact Database, Locating Contacts, Organizing Contacts, Scheduling Activities, Working with Activities in other Act! Windows, Creating Documents with the ACT! Word Processor.

This Crystal Reports training course is designed for those users of database applications who need to create and modify reports within their organisation. The Crystal Reports training course will provide an introduction to the major functions of the and allow users to provide reports in a range of formats, combining information from their databases.

Crystal Reports Training Course content: Creating basic reports, Inserting database fields, Previewing a report, Formatting objects and reports, Record selection, Record Sorting, Grouping and Summarising, Linking tables/databases, Introduction to and creating Formulae, Sub and running totals, Creating 'Top-N' reports, Summary/Drill Down reports, Cross-Tab Reports, Report distribution, Special fields and fields in text objects.

This Advanced Crystal Reports training course provides more in-depth training on the basic features covered in the introductory course, together with additional features not previously covered.

Advanced Crystal Reports Training Course content: Review of Introductory topics, Advanced Formulas; Variables, Two-pass reporting, Running Totals, User function Libraries. Conditional Formatting, Multiple Sections, Parameter fields, Advanced Cross-Tabs, SQL/ODBC Query Designer, Creating Data Sources; Using Access, Using Text, Using Excel Files. Graphing, Dictionaries & Sub-Reports.

Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data.

This is an advanced Microsoft Excel training course that will provide you with an understanding of the most advanced features of MS Excel.

Microsoft Excel is a very powerful spreadsheet application designed to save you time and make creating spreadsheets and other documents easy.

This is an introductory Microsoft Excel training course that will provide you with a working understanding of the basic features of MS Excel.

The Microsoft FrontPage Web site creation and management tool gives you everything you need to create and manage exactly the site you want, whether you're creating a personal Web page or a corporate Internet or intranet site.

By the end of this Microsoft FrontPage training course, delegates will be able to: Create simple web sites using FrontPage, Manage text and graphics on a Web Page, Use FrontPage Components, Create a simple FrontPage Form, Publish a Web Site.

This Intro to Mac training course is designed to give new or relatively new users of the Apple Macintosh an introduction and tuition in all aspects of the computer from the very basics of setting-up and the 'naming of the parts' to using the Internet and the bundled applications which come with your computer.

By the end of this Intro to Mac training course, delegates will be able to: Understand the Mac operating system and how it works, Connect and use external devices such as Printers, Scanners and Cameras, Organise all types of Files and Folders, Browse the Internet and use email, Use the bundled applications iTunes and iMovie.

This Intro to PC training course is designed for individuals who are new to computing and the web. It gives complete beginners the knowledge and confidence to start using the Windows interface effectively, search the internet and set up a web based e-mail account.

By the end of the Intro to PC training course, delegates will be able to: Start and shut down their PC, Use the mouse and keyboard, Use the Windows environment to open and close applications, Save, open and manage files, Search the Internet effectively, Set up a web based email account and send and receive mail.

Microsoft Outlook XP is a very powerful Personal Information Manager (PIM) designed to save you time and make integrating tasks, email, calendar and contact information simple.

This Microsoft Outlook training course will provide you with an understanding of the huge range of features of MS Outlook XP that relate primarily to the individual user.

This PC Master training course is to promote ever more sophisticated use of PCs. Typical delegates come from strong business background, with self-taught skills in PC use. The PC Master training course builds knowledge of PC use for business users. There is a theme of self-sufficiency.

Delegates are encouraged to probe to better understand the working and use of personal computers. A key aspect of the PC Master training course is the series of six, hands-on workshops in which students develop themselves to become 'PC Masters'.

This Powerpoint training course is aimed at those with no experience of presentation or graphics programs. Users will be shown what PowerPoint can be used for, and how to use its basic features to create presentations and produce graphics.

By the end of this Microsoft PowerPoint training course participants will: understand what a PowerPoint presentation is, and how they can be used, understand the principles of creating a presentation: including creating slides, using Master Slides, views and templates, understand some fundamental graphics package concepts: objects, handles, layers, drawing tools, know how to print their presentation, and/or associated handouts.

Through MS Project, you can monitor and schedule projects using resources such as people, equipment, time and money. Analyse your project information by using Gantt charts, graphs, tables and views and track your project, identifying what to do if it doesn't go to plan.

This Microsoft Project training course is designed to introduce delegates to the concepts of project planning. Delegates will learn how to identify, organise and manage the tasks and resources required to complete a project under the constraints of time and cost to achieve a final project target.

Through MS Project you can monitor and schedule your projects using resources such as people, equipment, time and money. You can analyse your project information by using Gantt charts, graphs, tables and views and you can track how your project progresses, identifying what to do if it doesn't proceed to plan.

This Advanced Microsoft Project training course is designed to familiarise clients with Microsoft Project's more advanced functions.

During this Microsoft Publisher training course, delegates will learn the basics of using MS Publisher, including how to create customized documents from scratch as well as with Publisher Wizards. Delegates generate a multi-page document, create document layout and work with importing and formatting text and graphics.

Upon successful completion of this Microsoft Publisher training course, delegates will be able to: Navigate in the Microsoft Publisher environment, create new multi-page documents, import text and graphics from other applications, format text using fonts, sizes, styles, and line spacing, use alignments, tabs, and indents, create common elements such as page numbers and design guides that will appear on each page of a document, create documents containing multiple columns, flow several independent stories throughout a document, wrap text around graphics.

The popular Sage Line 50 accounting enables you to keep track of your company accounts and easily produce required documentation and monthly reports.

The knowledge gained from more detailed information about your business transactions allows you to time your business decisions effectively as well as to map it's profitability and progress.

This Sage Line 50 training course is designed to introduce you to computerised accounting in Sage. It is primarily for those with little knowledge of Sage who would like to understand more about the day-to-day inputting of their accounts on computer.

This popular Sage Instant accounting enables you to keep track of your company accounts and easily produce required documentation and monthly reports.

This Sage Instant Accounting training course is designed to introduce you to computerised accounting in Sage. It is primarily for those with little knowledge of Sage who would like to understand more about the day-to-day inputting of their accounts on computer.

The goal of this Small Business Server training course is to provide delegates with the relevant and specific content they need to install, implement, administer, deploy applications on, and optimise performance of Microsoft Small Business Server.

At the end of the Small Business Server training course, delegates will be able to: Describe Small Business Server 2000 components and functions, Plan for and install Microsoft Small Business Server 2000, Add network users and client computers, Administer Small Business Server 2000, Configure Small Business Server 2000 server applications, Monitor Small Business Server 2000 performance.

This VBA For Access training course is designed for experienced users of Access' advanced features, who wish to extend their knowledge to include the use of Visual Basic for Applications (VBA) within Access.

Experienced Access users with previous programming experience may find a 1:1 intensive course achievable in one day. Less experienced users, users without programming experience, or for training in groups, the two day course is recommended.

This VBA for Excel training course is designed to give a good working knowledge of Visual Basic for Applications – concentrating on Microsoft Excel.

The Visual Basic for Applications content of the training course can be applied to other Microsoft Applications.

Through using Visio, you can easily create and enhance technical diagrams such as flow charts, network diagrams, maps and floor plans.

This is a hands-on Visio training course where the morning session concentrates on learning basic and more advanced Visio skills. The afternoon session is then used to practice creating simple and more complex Visio drawings.

This Microsoft Visio training course is designed to take delegates from learning basic Visio skills to a more in-depth understanding of the concepts behind creating technical drawings using Visio.

Microsoft Word is a very powerful word processing application designed to save you time and make easy work of creating forms, address labels, merging data into form letters and other tasks.

This is an advanced Microsoft Word training course that will provide you with an understanding of the most advanced features of MS Word.

Microsoft Word is a very powerful word processing application designed to save you time and make creating letters, CVs, reports and other documents easy.

This is an introductory Microsoft Word training course that will provide you with a working understanding of the basic features of MS Word.