Microsoft Office 2007 Suite
Our Microsoft Office 2007 computer training offers you the fastest and easiest way to learn MS Office 2007 applications, including Word, Excel, Access, PowerPoint, and Outlook. These courses also follow the curriculum for the Microsoft Office Specialist exams on Microsoft Office 2007.
Price: USD $299.00
Microsoft Office 2007 Full Suite
Using Microsoft Office Word 2007
This course will cover getting started with Word 2007, working with text, paragraphs, structuring, editing, saving, and opening documents. You will also learn how to use the printing, help, automated formatting, advanced formatting and advanced document navigation in Word 2007. The training introduces student to tables, charts, graphics, advanced data manipulation and advanced document features.
Upon successful completion of this Microsoft Office Word 2007 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-601 MOS: Microsoft Office Word 2007. All of our Microsoft Office 2007 training courses map to MOS certification paths.
Learning Objectives: 
Getting Started with Word 2007
- enter and delete text in a Word document
- locate the main elements of Word 2007's screen
- match the main features of Word 2007's screen with their descriptions
- recognize methods for navigating through a Word document given a scenario
- identify methods for paging through a document
- work with text in a Word document
- use Word's screen
- find a phrase in a Word document
- navigate to a particular point in a document
Working with Text and Paragraphs in Word 2007
- identify the formatting options in Word
- use the Home tab to format text
- apply basic text formatting in a scenario
- cut and paste text in a Word document
- copy and paste text in a Word document
- create lists in a Word document
- add symbols in a Word document
- format text
- cut and paste text
- add a numbered list and a symbol to text
- work with margins in a Word document
- set indents in a Word document
- use tab stops
- align text in a Word document
- set margins and tabs in a document
- center text and indent a paragraph in a document
Structuring, Editing, Saving, and Opening Documents in Word 2007
- insert a page break
- insert a section break
- adjust spacing in a Word document
- insert columns in a Word document
- correct spelling errors in a document
- correct grammar errors in a document
- edit and adjust the formatting for a given Word 2007 document
- save a new Word document
- save an existing document
- open an existing Word document in a given scenario
- save a Word document in PDF format
- save a Word document as a web page
- save a document to a new folder
- save a Word document as a PDF file
- modify save options
Printing, Help, and Automated Formatting in Word 2007
- print a file
- preview a page before printing
- use Word Help
- use Word's Research feature
- search for a Help topic
- use the Research feature to get a dictionary definition
- print two copies of a document
- apply a style to selected text
- create a new Quick Style
- apply a new Quick Style set to a document
- use AutoCorrect
- use Smart Tags
- apply a style to a document
- use Autocorrect to automatically replace text
- create a blank template
- create a template based on an existing document
- create a new template based on an existing template
- create a reusable building block
- distribute a building block with a template
- create a template for a letter
- create a reusable building block for distribution
- create a formal letter in Word 2007
Working with Documents in Word 2007
- insert a header
- insert a footer |w
- insert page numbers |w
- navigate a Word document using the Outline view
- navigate a Word document using Full Screen Reading view
- navigate a document using line numbers
- navigate a Word document using Document map
- navigate a Word document using Thumbnails
- insert page numbers at the top of the page
- insert a date in a document header
- navigate a document in Outline view
- add a shape
- insert WordArt
- insert a basic shape into a document
- insert a WordArt style to a document
- add a picture
- add clip art
- add a SmartArt graphic
- insert a picture in a document from a local folder
- insert SmartArt graphic in a document
Advanced Formatting in Word 2007
- add a page border
- position a page border
- add a text border
- add a watermark to a document
- add a custom background to a document
- apply a theme
- change document properties
- apply a page border to a document
- add a background to a document
- apply a theme to a document
- insert a footnote
- insert an endnote
- customize an endnote
- insert an endnote in a document
- modify an endnote
Advanced Data Manipulation Features in Word 2007
- add form controls
- match the form type with its appropriate use
- add protection to content controls in a form
- protect a form document
- create a field
- modify a field
- create a form
- add fields to a Word document
- create a form letter using mail merge
- print envelopes or labels
- use mail merge to create a form letter
Advanced Document Features in Word 2007
- record a macro
- edit a macro
- record a new macro
- modify a macro
- add a command to the Quick Access Toolbar
- add a command to the Quick Access Toolbar
- add a command to the status bar
- create a macro and assign it
- convert an existing document to a master document and create a new master document
- create subdocuments
- modify a master document
- manage subdocuments
- create a subdocument in a master document and insert an existing document as a subdocument
- make changes to the master document
Advanced Document Navigation and Document Reviews in Word 2007
- create a table of contents
- identify the function of a table of contents
- modify a table of contents
- create a hyperlink
- add a bookmark
- insert an index
- modify an index
- create an index using a concordance file
- create a link to another file in a document
- create a table of contents and an index for a document
- create a document with references
- use the track changes feature to edit a document
- insert a comment
- edit a document using track changes
- print a document with tracked changes
- use the Document Recovery Pane
- save backup copies of documents
- use the file recovery converter
- repair a corrupted document
- recover a document using the Document Recovery Pane
Using Tables, Charts, and Graphics in Word 2007
- insert a table
- create a table
- format a table
- display or hide gridlines
- convert text to a table or vice versa
- add a cell, row, or column to a table
- merge cells in a table
- sort table contents
- create a table from the built in options in Word
- modify and format a table
- sort the contents of a table
- create and format a table in Word
- embed a selection from an Excel worksheet in a Word document
- distinguish between linked and embedded objects
- link to an Excel worksheet in a Word document
- insert a chart into a Word document
- paste an Excel chart into Word
- insert an Excel worksheet as a linked object into a Word document
- insert an Excel chart into a Word document
Collaborative Features in Word 2007
- lock document formatting
- assign a password to a document
- use the Document Inspector
- add a digital signature
- secure a document
- remove private information from a document
- upload a Word document to SharePoint
- create a document library and upload a Word document to it
- assign a specific password to open a document
- use the protect document feature limit formatting to a selection of styles
- save a document as a web page
- set options for saving a Word document as a web page
- recognize how to get a blog account
- create a blog post
- save a document as a web page for Internet Explorer 6 or later
- assign a category to a blog post and upload it
Mentoring Using Word 2007
- Creating and Customizing Documents
- Formatting Content
- Working with Visual Content
- Organizing Content
- Reviewing Documents
- Sharing and Securing Content
TestPrep Using Word 2007
- Creating and Customizing Documents
- Formatting Content
- Working with Visual Content
- Organizing Content
- Reviewing Documents
- Sharing and Securing Content
Using Microsoft Office Excel 2007
This course will cover getting started with Excel 2007, manipulating, formatting data and Worksheets, reviewing and printing. The training also teaches you Excel 2007 formulas, functions, charts, pictures, themes, styles, advanced formatting, advanced data management, advanced customization and how to analyze data and how to protect and share Excel 2007 workbooks.
Upon successful completion of this Microsoft Office Excel 2007 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-602 MOS: Microsoft Office Excel 2007. All of our Microsoft Office 2007 training courses map to MOS certification paths.
Learning Objectives:
Getting Started with Excel 2007
- match basic Excel 2007 features with their functions
- recognize how to use the Help feature in a given scenario
- create a new Excel workbook in a given scenario
- open an existing Excel workbook in a given scenario
- navigate through an Excel workbook
- enter data in an Excel worksheet in given scenario
- save a new workbook
- distinguish between the common file formats used to save work in Excel 2007
- launch Excel and open an existing workbook
- enter data in an Excel 2007 workbook in a given scenario
- save the workbook in a given scenario
- open a recently used workbook and locate specific values, in a given scenario
Manipulating and Formatting Data and Worksheets
- copy or move data in given scenarios
- add, delete, or resize rows and columns in a given scenario
- modify rows and columns to view specific sections of the worksheet
- format workbooks in given scenarios
- insert and delete a worksheet
- rename a worksheet and format the tab color
- copy or move worksheets
- modify cells and workbooks in a given scenario
- modify worksheets to view specified data
- copy and move data and worksheets in a given scenario
- apply basic data formatting
- format a data range as a table
- change the position of data in a cell in a given scenario
- identify the functions of Alignment commands
- work with tables in Excel 2007
- format a data range as a table
- modify an Excel table
- apply number formats in a given scenario
- identify the number formatting options available in Excel 2007
- apply basic conditional formatting rules in a given scenario
- recognize situations when conditional formatting is suitable
- format data and apply conditional formatting in given scenarios
- move data between workbooks and apply formats in a given scenario
Reviewing and Printing in Excel 2007
- use Excel 2007 review tools in a given situation
- work with comments
- use the track changes tool
- review a workbook in a given scenario
- customize page setup using the Page Layout View
- adjust page breaks using the Page Break Preview
- print a worksheet in a given scenario
- specify page set up options before printing a workbook in a given scenario
Excel 2007 Formulas and Functions
- identify the elements of a formula
- identify the default order in which calculations occur
- match absolute, relative, mixed, and 3-D references with examples
- insert an Excel 2007 formula
- use names to clarify formulas
- edit formulas
- work with Excel 2007 formulas in given scenarios
- use the AutoCalculate feature to perform basic functions
- use a logical function
- use a financial function
- use a date function
- use functions to perform calculations in Excel 2007
- use formulas and functions to calculate data in a given scenario
Excel 2007 Charts, Pictures, Themes, and Styles
- insert an Excel 2007 chart
- identify the main elements of a chart
- change Excel 2007 charts
- change the data range included in the chart
- move a chart to a new worksheet
- work with charts in Excel 2007
- insert illustrations in Excel 2007
- apply a theme
- apply a cell style
- use illustrations to enhance a worksheet
- use a predefined theme and style to create a professional-looking worksheet
- use charts, illustrations, themes, and styles to improve the visual impact of your workbook
Advanced Formatting in Excel 2007
- format chart elements in Excel 2007
- identify Chart Tools commands for customizing chart elements
- save and apply a chart template
- use the Adjust formatting commands to modify a picture
- recognize the commands for formatting a picture's style
- format a picture's size and properties
- format a chart
- modify a picture
- create a custom number format
- identify codes for custom number formats
- create a new conditional formatting rule
- recognize how conditional formatting cell precedence works
- find cells that have conditional formats
- create custom number formats
- create a new advanced conditional formatting rule
- use advanced formatting in Excel 2007
Advanced Data Management in Excel 2007
- sort data
- filter data in a range or table
- group and outline data
- insert subtotals in a worksheet
- display different levels of data using outlines
- outline data
- filter and sort data
- apply subtotals to data
- organize worksheet data to facilitate data analysis
- specify the data that is allowed in a particular range
- recognize which error alert to use in given examples
- locate and correct formula errors
- use the Watch Window to audit formulas
- locate and correct formula errors
- add data validation to prevent the errors from recurring
Advanced Customization in Excel 2007
- create an Excel template
- create new cell styles in Excel 2007
- customize Excel 2007 themes
- customize workbook settings
- change the workbook properties
- customize Excel 2007 workbooks
- record and run a macro
- match macro security settings with their effects
- edit and delete macros
- assign a button to a macro and add it to the Quick Access Toolbar
- to create a macro and add it to the Quick Access Toolbar
Analyzing Data in Excel 2007
- create a PivotTable report
- rearrange PivotTable data
- customize PivotTable reports
- modify the look and feel of a PivotTable report
- create a PivotChart report
- modify a PivotChart report
- perform calculations in PivotTables reports
- recognize when to use each calculation type
- create a PivotTable report
- customize a PivotTable report
- change the summary calculation in a PivotTable report
- create a calculation with a formula
- create a PivotChart
- use Goal Seek to perform data analysis
- use Solver to perform data analysis
- create scenarios for what-if analysis
- use the Scenario Manager to modify scenarios
- create a one-variable data table for data analysis
- create a two-variable data table for data analysis
- project values in a series
- perform advanced functions
- match advanced functions with examples of when you would use them
- consolidate data from different workbooks using a Summary function
- use Goal Seek
- use Solver to perform what-if analysis
- create a data table to perform what-if analysis
- use advanced functions and consolidate data
Protecting and Sharing Excel 2007 Workbooks
- protect a workbook in a given example
- apply worksheet protection in a given example
- identify the features of digital signatures in Excel 2007
- protect a workbook
- prevent users from editing a workbook
- apply worksheet protection
- share workbooks on a network location
- merge shared workbooks
- publish a workbook to a SharePoint library
- perform basic actions using SharePoint
- share a workbook on a shared network resource
- merge shared workbooks
- publish a workbook to SharePoint
Exchanging Data with Excel 2007
- create links to data
- identify how to import data
- embed a file in a workbook
- create database queries in Excel 2007
- import an entire Access table
- import Excel data into Access
- copy Excel data to Word
- import Excel data into Outlook
- embed a file in a workbook
- import data from a text file into Excel
- import data from a database into Excel
- use Excel data in a Word document
- retrieve data from an Access database using the Wizard
- create a manual query to retrieve data from an Access database
- identify how XML works in Excel
- recognize the components of a basic XML system
- create an XML map and map elements to it
- import XML data
- export XML data into mapped cells
- use XML data in Excel 2007
Using Microsoft Office PowerPoint 2007
This course will cover getting started with PowerPoint 2007, how to add graphics to presentations, how to add multimedia and animations to presentations, how to create custom slide shows and how to distribute presentations using PowerPoint 2007.
Upon successful completion of this Microsoft Office PowerPoint 2007 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-603 MOS: Microsoft Office PowerPoint 2007. All of our Microsoft Office 2007 training courses map to MOS certification paths.
Learning Objectives:
Getting Started with PowerPoint 2007
- recognize the functions of elements of the PowerPoint screen
- recognize the steps for adding a command to the Quick Access Toolbar
- create a basic presentation in PowerPoint 2007
- format content in a PowerPoint presentation
- add slides to a presentation
- change the layout of a PowerPoint slide
- change the default view in PowerPoint 2007
- match PowerPoint views with their descriptions
- create a basic presentation
- format the content of a presentation
- change the layout of a slide
- search online Help in PowerPoint
- switch from offline to online Help
- search for a topic using online Help
Adding Graphics to Presentations in PowerPoint 2007
- apply a theme to a presentation in PowerPoint 2007
- customize a theme in a PowerPoint 2007 presentation
- insert objects in PowerPoint presentations
- modify the appearance of PowerPoint slides using SmartArt graphics
- apply a theme to a PowerPoint presentation
- add an object to a slide in PowerPoint
- add a SmartArt graphic to a PowerPoint slide
- modify a SmartArt graphic in PowerPoint
- add a chart or a table in PowerPoint
- modify the data in an embedded chart
- change the appearance of a PowerPoint chart
- modify the appearance of a PowerPoint table
- insert a chart in a PowerPoint slide
- change how a chart looks in PowerPoint
- modify the data in a PowerPoint chart
Adding Multimedia and Animations to Presentations
- insert a multimedia clip in a presentation
- insert a sound clip in PowerPoint
- animate an object in PowerPoint
- insert a multimedia file in a PowerPoint slide
- apply a custom animation to a slide object
- specify a transition for a slide in PowerPoint
- recognize the options for transitioning between slides in a presentation
- identify the ways to enhance navigation in a PowerPoint presentation
- add a hyperlink to a slide
- add an action button to a slide
- specify a slide transition for a slide
- add an action button to a presentation
Creating Custom Slide Shows in PowerPoint 2007
- customize a PowerPoint slide show
- hide a slide in a custom slide show
- identify the options for writing on a slide during a presentation
- turn on presenter view
- create a self-running presentation
- create a custom slide show
- select options for writing on a presentation while it's running
- create a self-running presentation
Distributing Presentations in PowerPoint 2007
- secure a presentation in PowerPoint 2007
- print a PowerPoint slide show
- distribute a PowerPoint presentation
- password protect a PowerPoint presentation
- print a PowerPoint presentation
- save a PowerPoint presentation as a web page
- digitally sign and e-mail a presentation
Using Microsoft Office Outlook 2007
This course will cover getting started with Outlook 2007, formatting and managing E-mail, how to use the calendar in Outlook 2007. The training will also teach you how to use contacts, tasks, notes, customize the interface and to complete searches, print items and work with RSS Feeds in Outlook 2007. Students will be introduced to customizing Outlook 2007, using the Journal, configuring rules, alerts, junk mail, working with SharePoint, calendars and Forms, and much more.
Upon successful completion of this Microsoft Office Outlook 2007 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-604 MOS: Microsoft Office Outlook 2007. All of our Microsoft Office 2007 training courses map to MOS certification paths.
Learning Objectives:
Getting Started with Outlook 2007
- launch Outlook 2007
- recognize how incoming e-mail messages are displayed in the Inbox
- recognize Outlook window features and their functions
- create a new e-mail message
- preview an incoming e-mail message
- view an e-mail message in the Inbox using the Reading Pane
- view an incoming e-mail message in a separate window
- reply to an e-mail message
- create a new e-mail message in a given a scenario
- reply to an incoming e-mail message in a given scenario
- get help using the Browsing categories feature, given a scenario
- get help using the Searching feature, given a scenario
- get help using the Table of Contents feature, given a scenario
- use the Browsing categories feature to get help, given a scenario
- use the Searching feature to get help, given a scenario
- use the Table of Contents feature to get help, given a scenario
Formatting and Managing E-mail in Outlook 2007
- format an e-mail message, given a scenario
- apply stationery and themes to an e-mail message, given a scenario
- create a signature for an e-mail message in a given scenario
- create an auto-reply in a given scenario
- set up a Read and Delivery receipt in a given scenario
- recall an e-mail message in a given scenario
- add voting buttons to an e-mail message in a given scenario
- respond to a poll in an e-mail message, given a scenario
- format an e-mail message in a given scenario
- add a signature to an e-mail message in a given scenario
- add voting buttons to an e-mail message in a given scenario
- recall an e-mail message in a given scenario
- apply a format to an e-mail message, given a scenario
- add voting buttons to an e-mail message, given a scenario
- add an attachment to an e-mail message in a given scenario
- preview an e-mail attachment in a given scenario
- edit an e-mail attachment in a given scenario
- add an attachment to an e-mail message in a given scenario
- preview an e-mail attachment in a given scenario
- edit an e-mail attachment in a given scenario
- use color coding to organize e-mail messages in the Inbox, given a scenario
- use color categories to organize e-mail messages in the Inbox, given a scenario
- add a flag to an e-mail message in a given scenario
- arrange e-mail messages in the Inbox using the View menu, given a scenario
- use the Search Folders feature to view different types of e-mail messages in the Inbox, given a scenario
- use the Inbox column headings to arrange e-mail messages, given a scenario
- arrange read and unread e-mail messages in the Inbox, given a scenario
- organize e-mail messages in the Inbox, given a scenario
Using the Calendar in Outlook 2007
- configure how the Calendar is displayed, given a scenario
- change the way the Calendar is displayed, given a scenario
- schedule an appointment directly in the Calendar, given a scenario
- schedule an appointment using the appointment form, given a scenario
- schedule an appointment from an e-mail message attachment, given a scenario
- create appointments in a given scenario
- create an event in a given scenario
- use the Meeting Requests feature to schedule a meeting, given a scenario
- use the Plan a Meeting feature to schedule a meeting, given a scenario
- recognize how to change an appointment to a meeting, given a scenario
- respond to a meeting request in a given scenario
- change a meeting request in a given scenario
- track a meeting in a given scenario
- cancel a meeting in a given scenario
- create a meeting in a given scenario
- reply to a meeting request in a given scenario
- update a meeting request in a given scenario
- request a meeting in a given scenario
- edit Calendar entries in a given scenario
- create a recurring Calendar entry in a given scenario
- change an existing Calendar entry to a recurring entry in a given scenario
- edit a recurring entry in a given scenario
- customize the calendar using the Calendar Options dialog box, given a scenario
- customize calendar entries by applying color to them, given a scenario
- customize the To-Do bar, given a scenario
- customize the calendar by creating additional calendars, given a scenario
- update calendar entries, given a scenario
- make an appointment a recurring entry, given a scenario
- customize the calendar using color categories, given a scenario
- customize the display in the To-Do bar, given a scenario
Using Contacts, Tasks, Notes, and Customizing the Interface in Outlook 2007
- create a new contact using the New Contact feature, given a scenario
- create a distribution list, given a scenario
- recognize how to create a contact from an e-mail that you receive
- recognize how to create multiple contacts from the same company
- view your contacts, given a scenario
- perform tasks using your contacts, given a scenario
- send a contact as an electronic business card, given a scenario
- create a new contact from scratch, given a scenario
- use a contact as an electronic business card, given a scenario
- request a meeting with a contact , given a scenario
- create an electronic business card, given a scenario
- create a task, given a scenario
- recognize how to view your tasks
- recognize how to update a task, given a scenario
- assign a task, given a scenario
- reclaim an assigned task that has been rejected
- track a task that you have assigned, given a scenario
- recognize the different ways to display tasks
- create a note, given a scenario
- customize a note, given a scenario
- recognize how to change the view of the Notes folder
- reject a task that has been assigned to you, given a scenario
- reclaim an assigned task that has been rejected, given a scenario
- track a task, given a scenario
- create a new note, given a scenario
- assign a task in a given scenario
- customize Outlook Today for the Outlook interface, given a scenario
- add folders to Favorite Folders, given a scenario
- work with shortcuts, given a scenario
- customize the Navigation Pane, given a scenario
- customize the Outlook interface, given a scenario
Completing Searches, Printing Items, and Working with RSS Feeds in Outlook 2007
- create a private folder with permission for other users to access it, given a scenario
- create a public folder with permission to share it with other users, given a scenario
- move items between private and public folders, given a scenario
- recognize how to perform a basic search using Instant Search
- recognize how to perform an advanced search using Instant Search
- create a Search Folder, given a scenario
- create a public folder, given a scenario
- move items between private and public folders, given a scenario
- use Instant Search to find an e-mail message, given a scenario
- print Outlook items, given a scenario
- print an e-mail message with an attachment, given a scenario
- print an address book, given a scenario
- print a meeting request and the list of attendees, given a scenario
- add an RSS Feed, given a scenario
- read an RSS Feed, given a scenario
- cancel an RSS Feed, given a scenario
- subscribe to an RSS feed, given a scenario
- view an RSS feed, given a scenario
- cancel an RSS feed but keep all the content, given a scenario
Customizing Outlook 2007 and Using the Journal
- create a new view in Outlook 2007
- customize an Outlook 2007 view
- create a custom toolbar
- recognize how to customize menus and toolbars
- customize the Quick Access toolbar
- customize a default view in a given scenario
- customize a toolbar in a given scenario
- customize the Quick Access toolbar in a given scenario
- add a new e-mail account to Outlook 2007
- change e-mail account settings in Outlook 2007
- remove an e-mail account in a given scenario
- add a new e-mail account in a given scenario
- modify e-mail account settings, for a given scenario
- remove an e-mail account from Outlook in a given scenario
- record a Journal entry in a given scenario
- recognize how to open and configure the Journal
- use the timeline to change the start and end date of a Journal entry in a given scenario
- configure automatic tracking for a Journal item in a given scenario
- create a new Journal entry in a given scenario
Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007
- create a rule from a template in a given scenario
- create a rule from a message in a given scenario
- run a rule manually in a given scenario
- modify a rule in a given scenario
- create a rule for the Out of Office Assistant in a given scenario
- add a rule to a public folder in a given scenario
- switch on desktop alerts in a given scenario
- extend the onscreen duration of a desktop alert in a given scenario
- set up an alert for a SharePoint library in a given scenario
- create a new rule from a template in a given scenario
- change a rule in a given scenario
- create a rule for the Out of Office Assistant in a given scenario
- switch on alerts and configure the desktop alert notification in a given scenario
- recognize how the Junk E-mail Filter works
- recognize the functions of the filter lists
- set the level of junk e-mail protection to low in a given scenario
- add e-mail addresses to the Safe Senders and Blocked Senders lists in a given scenario
- mark an e-mail as not junk in a given scenario
- empty the Junk E-mail folder in a given scenario
- change the Junk E-mail level of protection to low in a given scenario
- add addresses to the Safe Senders and Blocked Senders lists in a given scenario
- mark an email as not junk in a given scenario
- empty the Junk E-mail folder in a given scenario
Working with SharePoint, Calendars, and Forms in Outlook 2007
- connect to a SharePoint library from Outlook in a given scenario
- open a SharePoint file from Outlook in a given scenario
- disconnect Outlook from SharePoint in a given scenario
- create an Outlook task for a SharePoint site in a given scenario
- add an event to a SharePoint calendar from Outlook in a given scenario
- add a SharePoint contact to Outlook in a given scenario
- connect to a SharePoint task list from Outlook in a given scenario
- add and update a SharePoint task from Outlook in a given scenario
- add an item to a SharePoint calendar from Outlook in a given scenario
- create a group schedule in a given scenario
- display the group schedule for times outside working hours in a given scenario
- send a meeting request message from a group schedule in a given scenario
- add an Internet Calendar subscription to Outlook in a given scenario
- publish a calendar to Microsoft Office Online in a given scenario
- open another person's calendar in a given scenario
- add a delegate in a given scenario
- send a meeting request using a new group schedule in a given scenario
- subscribe to an Internet calendar in a given scenario
- open another person's calendar in a given scenario
- choose a form in a given scenario
- create a form in a given scenario
- modify a form action in a given scenario
- test and publish a form to a library in a given scenario
- test and publish a form to a library in a given scenario
- create a custom form in a given scenario
- test a form in a given scenario
- publish a form in a given scenario
- customize an Outlook form in a given scenario
Data Security, Archiving, and Working Offline in Outlook 2007
- disable add-ins in a given scenario
- disable all macros except digitally signed ones in a given scenario
- add someone to the Trusted Publisher's list in a given scenario
- get a digital ID in a given scenario
- digitally sign an e-mail, given a scenario
- back up a digital ID in a given scenario
- use an encrypted e-mail message
- disable all macros except digitally signed ones
- back up a new digital ID
- digitally sign an e-mail
- specify the frequency of AutoArchive in a given scenario
- Manually archive Outlook 2007 items in a given scenario
- set AutoArchive options for a specific folder in a given scenario
- clean up your mailbox in a given scenario
- create a Personal Folders file in a given scenario
- change the data file where content is saved in a given scenario
- open a Personal Folders file in a given scenario
- specify the frequency of AutoArchive for all Outlook folders
- configure AutoArchive settings for a specific folder
- Create a Personal Folder file with a password
- set up remote connections to Outlook in a given scenario
- access your e-mail via Outlook Web Access in a given scenario
- configure a Cached Exchange mode setting in a given scenario
- set up a prompt to work offline in a given scenario
- create a Send/Receive group in a given scenario
- download the offline address book in a given scenario
- filter the items that are downloaded to your offline folders in a given scenario
- process Remote Mail headers in a given scenario
- set up connecting to Outlook via the phone line
- turn on Cached Exchange mode
- create a new Send/Receive group and download the offline address book
- process Remote Mail headers
IRM, Instant, Text, and Unified Messaging in Outlook 2007
- turn on instant message online status in Outlook in a given scenario
- create and send a text message in a given scenario
- forward an Outlook item as a text message in a given scenario
- configure Unified Messaging in a given scenario
- play a voice message on a telephone in a given scenario
- create and send a text message
- set the voice mail PIN
- turn on missed call notification
Business Contact Manager with Outlook 2007
- distinguish the types of records used in BCM
- recognize the functions of BCM interface elements
- create an Account in BCM in a given scenario
- create a new business contact for an account in a given scenario
- create an opportunity in a given scenario
- create a new account
- add a business contact
- create a new opportunity
- add a product or service item
- create a Marketing Campaign in a given scenario
- track the results of a Marketing Campaign in a given scenario
- create a business project in a given scenario
- create a marketing campaign
- create a business project
- link an account to an opportunity in a given scenario
- link a file to an account in a given scenario
- link a phone log to a record in a given scenario
- view a communication history in a record in a given scenario
- link an item to more than one record in a given scenario
- move a link to another record in a given scenario
- auto-link an e-mail message to a record in a given scenario
- link an item to a BCM record
- link a communication history item to more than one record
- move a link to another record
- auto-link an e-mail message to a record
- create a report in a given scenario
- export a report in a given scenario
- launch a Marketing Campaign from a report
- select a new database for your profile in a given scenario
- delete and restore a database in a given scenario
- export data from a database in a given scenario
- export a newly-created report
- change the database that is associated with a profile
- delete and restore a database
- export data from a database
Using Microsoft Office Access 2007
This course covers getting started with Access 2007, basic tables, basic forms, queries, reports, importing and exporting data and data presentation in Access 2007. The training will also teach you how to use advanced data management, programmability and administration as well as database administration in Access 2007.
Upon successful completion of this Microsoft Office Access 2007 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-605 MOS: Microsoft Office Access 2007. All of our Microsoft Office 2007 training courses map to MOS certification paths.
Learning Objectives:
Getting Started with Access 2007
- plan a database
- match the main elements of the Access 2007 screen with their functions
- use Access Help
- plan a database
- use Access Help
- create a database from scratch
- create a database from a template
- add a blank datasheet to a database
- use views
- create an Access database and add a datasheet
- change the view
Basic Access 2007 Tables
- create a table from a template in a given scenario
- identify the elements in an Access 2007 table
- identify the table templates
- create a table using Datasheet view
- create a table using Design view
- modify a table
- modify a table in Design view
- create a validation rule
- create a masked input field in a table
- apply indexing to a table
- create a table from a template
- modify a table
- create a table in datasheet view and add a validation rule
- create an input mask
- manipulate data in records in Access 2007
- view, edit, and navigate records
- sort and filter data
- find and replace data
- print records
- create a relationship
- filter table information
- create a relationship
- edit a relationship
- create a relational database in Access 2007
Basic Access 2007 Forms
- create a form in Access 2007
- add controls to Access 2007 forms
- configure controls on an Access 2007 form
- bind controls to a field in Access 2007
- configure bound controls in Access 2007
- create a form using the Form Wizard
- add and configure an unbound control
- create a bound control and configure the record source
- customize forms in Access 2007
- format forms in Access 2007
- create and modify records
- navigate between Access 2007 records
- sort and filter Access 2007 records
- format an Access 2007 form
- create and modify a record in Access 2007
- sort and filter Access 2007 records
Queries and Reports in Access 2007
- create a simple query in design view
- create a simple query using the Simple Query Wizard
- modify a query in Access 2007
- create an expression with the Expression Builder
- use calculated fields and grouping in Access 2007
- create a crosstab query in Access 2007
- refine a crosstab query in Access 2007
- find unmatched queries in Access 2007
- find duplicate queries in Access 2007
- create and run a query in design view
- group a query by an aggregate function
- change an aggregate value for a crosstab query
- use the Find Unmatched Query wizard
- create a basic report in Access 2007
- add a control to an Access 2007 report
- recognize how to modify Access 2007 reports
- add a group and calculated summary to a report in Access 2007
- create a report using the Report Wizard
- add a control to a report and bind it to a field
- add a grouping to an Access 2007 report
- add a calculated summary to a group
Importing and Exporting Data and Data Presentation in Access 2007
- import data into an Access 2007 database
- distinguish between the options available for importing data into Access 2007
- export Access 2007 data
- distinguish between the formats you can export to from Access 2007
- set up data collection in Access 2007
- collect data by using e-mail messages
- import an object into an Access 2007 database
- export a database object to Excel
- collect data using e-mail messages
- build an Access 2007 PivotTable
- modify a PivotTable in Access 2007
- build a PivotChart in Access 2007
- modify an Access 2007 PivotChart
- create a PivotTable in Access 2007
- create a PivotChart in Access 2007
- modify a PivotTable
- modify a PivotChart
Advanced Data Management in Access 2007
- add a lookup field to an Access 2007 table
- add a subdatasheet to a table
- add attachments to Access 2007 records
- implement data validation in Access 2007
- add a lookup field to a table
- add a subdatasheet to a table |w
- use Expression Builder to construct a rule
- add Subforms to an Access 2007 database
- add Subreports to an Access 2007 database
- apply conditional formatting to a form in Access 2007
- add a subform to an existing form
- apply conditional formatting to a form
- add a subreport to a database
- create and edit joins in Access 2007 databases
- create and use simple parameter queries
- create and run update and append queries in Access 2007
- create and run a make table query
- delete data from an Access 2007 database
- create union queries in Access 2007
- recognize how to create or modify Access 2007 tables and indexes using data-definition queries
- perform SQL processing on a server
- edit the SQL of a SELECT query and use subqueries
- specify a join in a query
- create and run a parameter query
- create and run an update query
- edit the SQL of a SELECT query
- use SQL to create Access 2007 queries
Programmability and Administration in Access 2007
- determine how to move data to a SharePoint site
- specify how to publish data to a SharePoint site
- create an Access view of a SharePoint list
- work with SharePoint lists
- take SharePoint list data offline
- work offline and track data in Access 2007
- move data to SharePoint using the Move to Sharepoint Site wizard
- publish a database to a Sharepoint site |w
- import a SharePoint list to Access 2007
- view different versions of a SharePoint list item
- create and edit Access 2007 macros
- run Access 2007 macros
- use VBA to create an event handler in Access 2007
- work with event handlers in Access 2007
- create an Access 2007 macro
- run an Access 2007 macro
- edit an Access 2007 macro
- create an event handler in Access 2007
Database Administration in Access 2007
- customize datasheets in Access 2007
- recognize how to compact and repair a database
- illustrate how to convert earlier Access database formats to Access 2007
- specify how to back up databases and restore database files
- customize the datasheet view in Access 2007
- convert an earlier Access database to Access 2007 format
- change the default file format of an Access 2007 database
- outline how to view and change object dependencies in Access 2007
- illustrate how to analyze objects for performance
- outline how to use the database documenter and the Table Analyzer wizard to optimize database performance
- use the performance analyzer
- use the Database Documenter
- use the Table Analyzer wizard
- view an object's object dependencies
- identify how to enable content for an Access 2007 database
- recognize how to hide a database object
- summarize how to encrypt a database by setting a database password
- restate how to protect VB code in Access 2007
- determine how to split a database and repair database links
- use an Office Access 2007 database in a trusted location
- restate how to package, sign, and distribute an Office Access 2007 database
- protect a database by setting a database password
- add a new location to the trust center
- split a database
- create a signed package
- outline how to work with switchboards and the Navigation Pane
- outline how to create a custom group and add objects to it
Price: USD $299.00
USD
