Vi ste ovdje
Overview/Description
Using Access macros and Visual Basic for Applications (VBA) code, you can easily add functionality to a database to suit your business needs. This course provides an introduction to programming in Access 2010 and explores when to use macros or VBA code to automate processes. It demonstrates how to create and modify different types of macros as well as how to specify actions, conditions, and event handlers.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson ObjectivesAccess 2010 Macros and VBA
create macros
execute macro actions...
Overview/Description
Whether it is to stay in touch with friends and family or to message colleagues from the office, people depend on e-mail communication more than ever before. When away from the office, Outlook 2010 offers two options for people to access their Exchange e-mail accounts â Outlook Web App and Outlook Anywhere. This course discusses how to access and sign on to Outlook Web App using a web browser and how to configure Outlook 2010 with Outlook Anywhere so that users can send and receive messages. This course also covers the role that forms play in Outlook 2010 and how forms...
Overview/Description
Inserting images, such as photographs, clip art, and shapes, into your PowerPoint 2010 presentation can help to capture and keep the attention of your audience. This course will show you how to insert, format, and apply special effects to your images so that they provide the maximum impact for your presentation. You will learn how to create a photo album and create a presentation that effectively displays your favorite photos. In addition, you will be shown how to use the new built-in screen capture tool that enables you to capture and embed screenshots of other programs...
Overview/Description
Word 2010 offers you a variety of tools that allow you to insert navigation and reference materials into a document. With heading styles applied to your document, you can easily construct a table of contents; you can also insert footnotes and endnotes, and you can quickly link to web pages, shared files, or other sections of a document using bookmarks. This course explores all of these topics, and discusses how to use each feature to improve the readability of your documents.
Target Audience
Individuals and business users with basic computer literacy and some experience...
Overview/Description
Excel has more than just charts to offer in the way of visual presentation. Nonchart-related graphic tools such as Shapes, SmartArt, WordArt, ClipArt, and Screenshots are all ways to enhance the visual impact of documents that tend to be dominated by dry numbers and text. This course focuses on these and other graphic elements that can be added to Excel 2010 spreadsheets. This course also introduces ways to change the themes and styles offered by Excel 2010.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson...
Overview/Description
A well set up project file is essential to the success of a project. The advanced project file customizations available in Project 2010 can simplify many project management tasks, saving you time, and increasing the effectiveness of project analysis and reporting tools throughout the life of your project. This course covers how to customize default options, add new tabs and groups to the Ribbon, and add new buttons to the Quick Access Toolbar. You will also learn how to import or export a customized Ribbon and Quick Access Toolbar so that project team members can share...
Overview/Description
Microsoft Office Access 2010 offers several advanced options for importing and exporting data. With Access 2010 you can link to, or import data and objects from external sources, such as other Access databases, SQL Server databases, Excel spreadsheets, Microsoft Word files, and XML files. You can also export data and objects from an Access 2010 database to a variety of external sources. This course explains and demonstrates the various methods of importing, exporting, and linking to external data sources in Access 2010.
Target Audience
A broad range of business users...
Overview/Description
Project 2010 comes with many enhanced features and tools that help project managers report on project status and carry out project management tasks with ease and efficiency. This course covers several of the advanced tools you will use to communicate project status and streamline your tasks, such as the visual reports, enhanced copy and paste, and the Compare Projects feature, which allows you to compare project files and produce an informative comparison report. This course also covers the procedure for recording macros, which will allow you to save time on repetitive...
Overview/Description
An important ingredient in managing projects is the ability to easily identify potential resource issues and the impact they could have on the overall project schedule. This course covers advanced resource and scheduling adjustments, such as how to delay task start dates and apply predetermined work contours to manage assignments. You will also become familiar with Team Planner, a graphical view that allows you to view and adjust work assignments with drag-and-drop action. This course also includes several methods for leveling resources and correcting overallocation...
Overview/Description
Ongoing inspection and adjustment of the project plan is vital to address impacts to the project schedule and address scope and budget changes. This course covers how to easily identify warnings, solutions, and drivers for tasks using Task Inspector, how to address repetitive tasks by creating a recurring task, and how to inactivate tasks that are no longer necessary to the project. This course also covers ways to inspect a project plan by grouping, filtering, and displaying the critical path.
Target Audience
Individuals familiar with basic project concepts who wish to...
- 1 od 11
- ››