Microsoft Office 2010 Suite
Our Microsoft Office 2010 computer training offers you the fastest and easiest way to learn MS Office 2010 applications, including Word, Excel, Access, PowerPoint, and Outlook. These courses also follow the curriculum for the Microsoft Office Specialist exams on Microsoft Office 2010.
Price: USD $299.00
Microsoft Office 2010 Full Suite
Using Microsoft Office Word 2010
This course will cover getting started with Word 2010, 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 2010. The training introduces student to tables, charts, graphics, advanced data manipulation and advanced document features.
Upon successful completion of this Microsoft Office Word 2010 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-881 MOS: Microsoft Office Word 2010. All of our Microsoft Office 2010 training courses map to MOS certification paths.
Learning Objectives: 
Getting Started with Word 2010
- Recognize tasks you can perform in Word 2010
- Open a Word 2010 document
- Create a new document in Word 2010
- Distinguish between the various ways of entering, selecting, and deleting text in Word 2010
- Distinguish between the primary functions of key Word 2010 user interface components
- Use basic features of Word 2010
Formatting and Working with Text in Word 2010
- Use the Mini toolbar to apply formatting in Word 2010
- Use the Format Painter in Word 2010
- Use the Home tab to apply formatting in a Word document
- Cut, copy, and paste text in a Word document
- Undo and redo actions in Word 2010
- Create a list in Word 2010
- Format text in Word 2010
Organizing and Arranging Text in Word 2010
- Create a custom border and apply it in Word 2010
- Apply basic shading and borders in Word 2010
- Work with hidden text and formatting marks in Word 2010
- Change margins in Word 2010
- Create indents in Word 2010
- Adjust spacing in Word 2010
- Create columns in Word 2010
- Organize and arrange text in Word 2010
Moving Around in Word 2010
- Identify features and tools for moving around in a Word 2010 document
- Use the Navigation Pane in Word 2010
- Use the Find and Replace feature in Word 2010
- Use the Zoom feature in Word 2010
- Use Full Screen Reading view in Word 2010
- Use Outline view in Word 2010
- Use the features and tools in Word 2010 to view and move around a document, for a given scenario
Structuring Word 2010 Documents
- Use the Navigation Pane to restructure headings and content in Word 2010
- Change how Word inserts automatic page breaks
- Use section breaks in Word 2010
- Add headers and footers to documents in Word 2010
- Add custom page numbers to documents in Word 2010
- Add page numbers to documents in Word 2010
- Use headings, breaks, and page numbers to structure a document in Word 2010
Reviewing Documents in Word 2010
- Use the Research feature in Word 2010
- Use the Help feature in Word 2010
- Use the automatic spelling and grammar checker in Word 2010
- Run the spelling and grammar checker in Word 2010
- Use comments in Word 2010
- Use track changes in Word 2010
- Spellcheck and review a document in Word 2010
Saving, Sharing, and Printing in Word 2010
- Save a document in a different format in Word 2010
- Save a Word 2010 document
- Change the default save options in Word 2010
- Save and send a document in Word 2010
- Print a document in Word 2010
- Save, send, and print documents in Word 2010
Customizing the Behavior and Appearance of Word 2010
- Create a Quick Style
- Apply a Quick Style
- Make document-wide style changes in Word 2010
- Use AutoCorrect in Word 2010
- Undo an AutoCorrect action in Word 2010
- Create a document from a template in Word 2010
- Save a document as a template in Word 2010
- Customize the Ribbon in Word 2010
- Customize the appearance and behavior of Word 2010
Drawing and Inserting Graphics in Word 2010
- Add clip art to a document
- Use Word 2010 to take and add a screenshot to a document
- Add a picture to a document in Word 2010
- Add a shape to a document and edit it in Word 2010
- Add WordArt to a document and edit it in Word 2010
- Add a text box to a document in Word 2010
- Add SmartArt to a document and edit it in Word 2010
- Add graphics to a document and edit them in Word 2010
Using Themes, Backgrounds, Watermarks, and Quick Parts in Word 2010
- Apply, modify, and save a theme in Word 2010
- Create theme colors in Word 2010
- Create theme fonts in Word 2010
- Add a custom text watermark to a document
- Add a picture watermark to a document
- Add a picture background to a Word document
- Add an item to the Quick Parts gallery
- Create AutoText in a Word document
- Use themes, watermarks, and Quick Parts in a Word document
Adding Tables of Contents, Footnotes, Hyperlinks, and Bookmarks in Word 2010
- Create a custom table of contents in Word 2010
- Update a table of contents
- Add footnotes and endnotes to a document
- Customize footnotes and endnotes in a document
- Create a hyperlink in a Word document
- Create a bookmark in a Word document
- Create and update a table of contents
- Customize footnotes and endnotes
- Create a hyperlink and a bookmark
Forms, Fields, and Mail Merge in Word 2010
- Add content controls to a form
- Apply protection to a form
- Add a field to a document
- Modify a field in a document
- Start a mail merge and specify a data source
- Add mail merge fields to a document
- Add and modify fields in Word 2010
- Perform a mail merge in Word 2010
- Add content controls to a form and protect a form in Word 2010
Managing, Inspecting, and Recovering Word 2010 Documents
- Restrict editing in a Word document
- Use Word 2010 to create your own digital ID for documents
- Modify the properties of a document
- Prepare a document for sharing
- Recover a document that was closed before saving
- Use the Document Recovery pane to save a recovered document
- Recognize how to access the Word tools that can repair damaged files
- Recover a document, modify its properties, and restrict its editing
Creating and Formatting Tables in Word 2010
- Create tables in Word
- Apply a style to a table
- Modify a table style
- Select table elements and manipulate their alignment
- Insert and format a table in Word 2010
Manipulating Tables in Word 2010
- Insert and delete table elements
- Split cells in a table in Word
- Manipulate cell size in a table
- Sort a table in Word
- Add a formula to a table
- Modify and sort a table
Embedding Charts and Tables into Word 2010
- Add tables from Excel to Word documents
- Add a chart to a Word document
- Change a chart's type, layout, and style
- Change individual elements of a chart's layout
- Change the style of a chart element
- Add a chart and Excel worksheet to a Word document
Using Microsoft Office Excel 2010
This course will cover getting started with Excel 2010, manipulating, formatting data and Worksheets, reviewing and printing. The training also teaches you Excel 2010 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 2010 workbooks.
Upon successful completion of this Microsoft Office Excel 2010 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-882 MOS: Microsoft Office Excel 2010. All of our Microsoft Office 2010 training courses map to MOS certification paths.
Learning Objectives:
Getting Started with Excel 2010
- Start Excel 2010 and open an existing workbook
- Identify the features of spreadsheets
- Recognize the functions of key Excel 2010 interface elements
- Create a new workbook
- Enter data in a given scenario
- Open a workbook based on an existing template
- Open an Excel workbook
- Enter data into an Excel workbook
Applying Basic Data Formatting in Excel 2010
- Apply basic text formatting
- Apply and copy cell formatting
- Format text and cells
- Recognize how alignment commands change the position of text
- Apply and modify number formats
- Match number formats with examples
- Align text in a cell
- Modify and apply a number format
Moving and Getting Around in Excel 2010
- Move around a worksheet
- Recognize how to navigate around Excel in a given scenario
- Get Help on Excel tasks or commands
- Alter your view of the worksheet
- Recognize how Workbook Views alter the appearance of a worksheet
- Recognize how to zoom in or out of a worksheet
- Work with different windows in Excel 2010
- Work with panes in Excel workbooks
- Move around a worksheet
- Alter your view of a worksheet
- Arrange and view workbook data
Moving Data and Modifying Worksheets in Excel 2010
- Copy and move data
- Use paste options to preview and control how data displays
- Insert and delete rows and columns
- Format rows and columns
- Insert and delete worksheets
- Copy or move worksheets
- Copy and paste data
- Modify rows and columns
- Copy and modify worksheets
Saving, Sending, and Printing Excel 2010 Workbooks
- Save a workbook in a different format
- Save an Excel workbook
- Change the default save options in Excel 2010
- Share and send a workbook
- Use the Page Setup settings to prepare a worksheet for printing
- Print an Excel 2010 workbook
- Save a workbook
- Share a workbook
- Prepare and print a workbook
Using Conditional Formatting, Tables, and Sparklines in Excel 2010
- Format data as a table
- Sort and filter table data in a given scenario
- Apply conditional formatting rules
- Recognize when to use specific conditional formats
- Use sparklines to show data trends
- Format sparklines
- Sort and filter table data
- Use conditional formats to highlight data
- Use sparklines to highlight trends in data
Reviewing and Protecting Content in Excel 2010
- Use Excel's proofing tools
- Use the Excel comments feature
- Use track changes in Excel 2010
- Select statements that describe Excel's track changes tool
- Apply worksheet and workbook protection
- Check spelling in worksheet and add notes using comments
- Use Excel's track changes feature
- Protect elements of a worksheet
Using Basic Formulas in Excel 2010
- Identify elements of a formula
- Recognize how Excel calculates precedence in a formula
- Recognize examples of reference types used in Excel formulas
- Create and insert formulas
- Use names in formulas
- Correct common error values
- Edit formulas
- Create a formula
- Define a name reference and use it in a formula
- Copy and paste a formula between cells
Using Basic Functions with Excel 2010
- Identify the characteristics of functions in Excel
- Perform basic calculations using Excel's most commonly used functions
- Use financial functions
- Use date and time functions
- Use logical functions to help perform calculations on worksheet data
- Perform basic calculations
- Use a financial function to determine the monthly repayment of a loan
- Use a date function and a logical function
Inserting Basic Charts in Excel 2010
- Recognize when to use different Excel charts
- Insert a chart
- Identify the elements of an Excel chart
- Update an existing Excel chart's style, layout, or location
- Change the data range on which a chart is based
- Insert a chart
- Update a chart's type, layout, and style
- Update the chart's source data and change chart's location
Adding Visuals, Themes, and Styles to Excel Workbooks
- Insert illustrations, including pictures, clip art, shapes, and SmartArt graphics, into a worksheet
- Use Excel's image editing tools to format illustrations
- Insert a screenshot into a workbook
- Add text features to a worksheet
- Use cell styles to apply consistent formatting
- Apply an Excel theme to a worksheet
- Add a picture and clip art to a worksheet
- Add a screenshot to a worksheet
- Apply a theme and a cell style
Customizing Visual Elements in Excel 2010
- Manually adjust a chart's layout and formatting
- Save and apply a chart template
- Manually format illustrations using the Format object dialog box
- Customize and save Excel themes and styles
- Save an Excel template and apply to a new workbook
- Adjust individual chart elements
- Format Excel illustrations
- Create a new cell style
- Create an Excel theme
Customizing Workbook Settings, Conditional Formatting, and Number Formats
- Customize workbook settings using Excel Options
- Change workbook properties
- Create a custom number format
- Recognize how to alter code strings to create custom number formats
- Create a conditional format based on a new formatting rule
- Manage conditional formatting rules
- Customize workbook settings and the Quick Access Toolbar
- Create and apply a custom number format
- Create a new conditional formatting rule
Organizing Data and Objects in Excel 2010
- Sort data in more than one column or row
- Create a custom filter
- Outline data using the Subtotal, Auto Outline, or Group commands
- Arrange objects on a worksheet page
- Recognize how you can arrange data to fit a specified page layout for printing
- Create a hyperlink
- Modify hyperlinks
- Sort and filter data
- Create an outline so you can group and summarize data
- Arrange objects on a page
- Create a hyperlink from a worksheet to a web page
Ensuring Excel 2010 Data and Formulas are Right
- Use Excel's formula auditing tools to evaluate and correct formulas
- Use the Watch Window to inspect, audit, or confirm formula calculations and results
- Use data tools to convert text to columns and remove duplicates
- Add data validation to worksheet cells
- List the different things you can use data validation for
- Use error checking to identify a formula error
- Separate text in one column into two columns
- Restrict data entry in specific cells
Automating Excel 2010 Tasks using Macros
- Identify the features of Excel 2010 macros
- Use the Macro Recorder to record and run a macro
- Identify the steps in recording a macro using the macro recorder
- Edit and delete macros
- Run a macro in different ways
- Prepare for recording a macro
- Record and run a macro
- Assign a macro to the developer tab on the Ribbon
- Add a macro the Quick Access Toolbar
Analyzing Data with What-if Analysis
- Use Goal Seek for data analysis
- Use Solver to perform data analysis
- Create scenarios using the Scenario Manager
- Manage Excel 2010 what-if scenarios
- Create a data table for what-if analysis
- Recognize how to project values in a series
- Use what-if analysis to find out how to achieve a desired result
- Use what-if analysis to determine the maximum or minimum value of one cell by changing other cells
- Use what-if analysis to forecast best-case and worst-case results
- Use what-if analysis to explore a possible set of outcomes at a glance
PivotTables and PivotCharts in Excel 2010
- Create a PivotTable report
- Rearranging data in PivotTable reports
- Customize PivotTable reports
- Modify a PivotTable report's design
- Create a PivotChart
- Modify a PivotChart report
- Create a PivotTable report
- Customize a PivotTable report
- Create a PivotChart report
PivotTable Filters, Calculations, and PowerPivot
- Use calculations in PivotTable reports
- Filter data in PivotTable reports
- Create and use slicers
- Identify the functions of elements of the PowerPivot interface
- Identify the features of PowerPivot for Excel add-in
- Change functions in PivotTable reports
- Create your own formula in a PivotTable report
- Enable multiple filters and apply a Report filter
- Use slicers to filter data in a PivotTable report
Also includes bonus modules - not required for Excel 2010 Exam 77-882 certification.
Automating Excel 2010 Tasks Using Macros
- Identify the features of Excel 2010 macros
- Use the Macro Recorder to record and run a macro
- Identify the steps in recording a macro using the macro recorder
- Edit and delete macros
- Run a macro in different ways
- Prepare for recording a macro
- Record and run a macro
- Assign a macro to the developer tab on the Ribbon
- Add a macro the Quick Access Toolbar
Analyzing Data with What-if Analysis in Excel 2010
- Use Goal Seek for data analysis
- Use Solver to perform data analysis
- Create scenarios using the Scenario Manager
- Manage Excel 2010 what-if scenarios
- Create a data table for what-if analysis
- Recognize how to project values in a series
- Use what-if analysis to find out how to achieve a desired result
- Use what-if analysis to determine the maximum or minimum value of one cell by changing other cells
- Use what-if analysis to forecast best-case and worst-case results
- Use what-if analysis to explore a possible set of outcomes at a glance
PivotTables and PivotCharts in Excel 2010
- Create a PivotTable report
- Rearranging data in PivotTable reports
- Customize PivotTable reports
- Modify a PivotTable report's design
- Create a PivotChart
- Modify a PivotChart report
- Create a PivotTable report
- Customize a PivotTable report
- Create a PivotChart report
PivotTable Filters, Calculations, and PowerPivot
- Use calculations in PivotTable reports
- Filter data in PivotTable reports
- Create and use slicers
- Identify the functions of elements of the PowerPivot interface
- Identify the features of PowerPivot for Excel add-in
- Change functions in PivotTable reports
- Create your own formula in a PivotTable report
- Enable multiple filters and apply a Report filter
- Use slicers to filter data in a PivotTable report
Using Microsoft Office PowerPoint 2010
This course will cover getting started with PowerPoint 2010, 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 2010.
Upon successful completion of this Microsoft Office PowerPoint 2010 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-883 MOS: Microsoft Office PowerPoint 2010. All of our Microsoft Office 2010 training courses map to MOS certification paths.
Learning Objectives:
Getting Started with PowerPoint 2010
- Identify key elements of the PowerPoint 2010 interface
- Change the view of a presentation
- Open, save, and close a PowerPoint presentation
- Recognize methods for opening a PowerPoint presentation
- Open a PowerPoint 2010 template
- Add and format text and text boxes on a PowerPoint slide
- Manipulate slides in a PowerPoint presentation
- Open a presentation and format text boxes
- Organize slides and save a PowerPoint presentation
Visually Enhancing PowerPoint 2010 Presentations
- Apply a theme to a PowerPoint 2010 presentation
- Modify a PowerPoint theme
- Create and format SmartArt in PowerPoint 2010
- Add WordArt to a slide and edit it
- Add a table to a PowerPoint slide
- Add a chart to a PowerPoint slide
- Format a table in PowerPoint 2010
- Format a chart in PowerPoint 2010
- Work with a theme in PowerPoint 2010
- Work with SmartArt in PowerPoint 2010
- Work with a chart in PowerPoint 2010
- Work with a table in PowerPoint 2010
Adding Images to Presentations in PowerPoint 2010
- Insert and format a picture used in a PowerPoint 2010 presentation
- Create a photo album in PowerPoint 2010
- Insert and format clip art using PowerPoint 2010
- Insert and format a shape using PowerPoint 2010
- Apply special effects to an image using PowerPoint 2010
- Add a hyperlink to an object using PowerPoint 2010
- Insert and edit a graphic image in a PowerPoint presentation
- Find and add clip art to a PowerPoint slide
- Format a shape and add a hyperlink in a PowerPoint presentation
Using Multimedia and Animations in PowerPoint 2010
- Insert a video into a PowerPoint presentation
- Insert an audio clip into a PowerPoint presentation and set playback options
- Apply slide transitions in a PowerPoint presentation
- Apply animations to a slide in a PowerPoint presentation
- Match types of animations with corresponding uses
- Add a video and an audio clip to a slide
- Apply a transition to a presentation
- Apply animations to multiple objects on a slide
Using Advanced Slide Show Tools in PowerPoint 2010
- Create a custom animation using PowerPoint 2010
- Apply triggers to animated objects on a slide
- Configure the settings for a custom slide show
- Match slide show types with corresponding examples of when you would use them
- Set up an action button for a user-run slide show presentation
- Recognize the procedure for recording narration and slide timings
- Recognize how to use presentation tools available in PowerPoint 2010
- Add multiple visual and audio effects to a slide
- Set up a slide show as per given specifications
- Use presentation tools during a slide show presentation
Collaborating and Sharing Presentations in PowerPoint 2010
- Use the proofing tools available in PowerPoint 2010
- Using the translation tools in PowerPoint 2010
- Use review tools in PowerPoint 2010
- Use the merge and compare tools in PowerPoint 2010
- Collaborate with one or more team members on a PowerPoint presentation
- Match file format options in PowerPoint 2010 with their corresponding purposes
- Use tools to distribute PowerPoint presentations over the Internet
- Protect a PowerPoint 2010 presentation
- Prepare a PowerPoint 2010 presentation for printing
- Proof and research words on a slide
- Finalize a reviewed version of a presentation and upload it to the Web
- Protect a presentation and prepare for printing
Using Microsoft Office Outlook 2010
This course will cover getting started with Outlook 2010, formatting and managing E-mail, how to use the calendar in Outlook 2010. 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 2010. Students will be introduced to customizing Outlook 2010, 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 2010 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-884 MOS: Microsoft Office Outlook 2010. All of our Microsoft Office 2010 training courses map to MOS certification paths.
Learning Objectives:
Getting Started with Outlook 2010
- Distinguish the main elements of Mail view and their functions
- Recognize how the features in Mail view are used
- Create a new e-mail message
- View incoming e-mail messages
- Respond to e-mail messages
- Create a new e-mail message
- View an incoming e-mail message
- Respond to an e-mail message
Managing Conversations and Organizing E-mail in Outlook 2010
- Manage e-mail conversations using the Conversation feature
- Organize e-mails in the Inbox
- Use color categories for e-mail messages
- Use flags with e-mail messages
- Create Quick Steps for e-mail messages
- Organize e-mail messages in Outlook 2010
Managing Attachments, Graphics, Signatures, and Autoreplies in Outlook 2010
- Manage e-mail attachments that you have received
- Send attachments in e-mails
- Add graphics to e-mail messages
- Add a table to e-mail messages
- Add hyperlinks to e-mail messages
- Add symbols, horizontal lines, and equations to e-mail messages
- Use a signature and print e-mail messages
- Set up automatic replies to e-mails that you receive
- Add items to an e-mail message and print the message
- Create an autoreply for messages that you receive
Using the Calendar for Appointments, Events, and Meetings in Outlook 2010
- Change the time period displayed in the Calendar
- Change the appearance of the Calendar
- Create appointments
- Create an event
- Schedule a meeting
- Change the Calendar time period, color, and font
- Schedule activities
Managing Meetings and Customizing the Calendar in Outlook 2010
- Respond to meeting requests
- Manage meeting responses
- Create additional calendars
- View the calendars of other Outlook users
- Customize Calendar settings
- Customize the To-Do Bar
- Respond to a meeting request
- Manage meeting responses
- Create an additional and a group calendar
- Set up free/busy information
Outlook 2010 Social Connector and Messaging
- Recognize the features of the Outlook Social Connector
- Work with the Outlook Social Connector
- Add a public IM contact to your Communicator Contact List
- Use Communicator
- Use text messaging in Outlook
- Use the Outlook Social Connector
- Use instant messaging in Outlook
- Use text messaging in Outlook
Working with Contacts in Outlook 2010
- Create contacts
- Create contact groups
- Modify your contacts
- Import your contacts from Google Gmail to Outlook
- Export your contacts from Outlook to Google Gmail
- Create contacts
- Modify your contacts
- Export your contacts from Outlook to Google Gmail
Using the Tasks, Notes, and Journal Features in Outlook 2010
- Create tasks
- Assign a task to someone
- Respond to a task assignment
- Create notes
- Use the Journal
- Create and manage tasks
- Create a note
- Create a journal entry
Formatting E-mail and Configuring Message Options in Outlook 2010
- Create a format for your e-mail messages
- Save e-mail messages
- Format e-mail messages
- Check the spelling and grammar of your e-mail messages
- Track e-mail messages
- Configure message options when sending e-mail
- Set the format type of an e-mail message
- Format an e-mail message
- Check the spelling and grammar of an e-mail message
- Add outgoing e-mail options
Customizing Outlook 2010 and Managing Accounts
- Customize the Outlook 2010 Ribbon
- Create custom views
- Customize the Navigation Pane
- Customize the Reading pane
- Customize the To-Do Bar
- Configure the settings for an account in Outlook
- Customize the ribbon
- Create custom views
- Customize the Navigation pane and Reading pane
- Update the settings for an Exchange account
Managing E-mail with Rules, Automatic Replies, and Alerts in Outlook 2010
- Create rules using Outlook rule templates
- Run rules manually
- Create a rule based on the sender of an e-mail message
- Import rules into an existing rules list
- Use automatic replies
- Use Desktop Alerts
- Create rules
- Set an automatic reply
- Turn on a Desktop Alert
Working with Files and Folders and Using Search and RSS Feeds in Outlook 2010
- Use your own folders
- Import files into Outlook 2010
- Export files from Outlook 2010
- Create Search folders
- Perform Instant Searches for e-mail messages
- Use RSS feeds
- Export files from Outlook 2010
- Search for e-mail messages
- Manage RSS feeds
Implementing Security with Outlook 2010
- Set security options using the Trust Center
- Use digital signatures with your e-mail messages
- Encrypt your e-mail messages
- Filter junk e-mail using the Junk E-mail Filter
- Filter phishing e-mail messages using the Junk E-mail Filter
- Secure your e-mail correspondence
- Filter your e-mail correspondence
Data Files, Archiving, and Send/Receive Groups in Outlook 2010
- identify key characteristics of Outlook data files and offline Outlook data files
- manage Outlook data files
- specify AutoArchive settings for archiving your Outlook items
- manually archive your Outlook items
- use the Mailbox Cleanup tool to manage your mailbox
- use Send and Receive Groups
- archive your Outlook items
- work with Outlook Data Files
- use Send/Receive groups
Accessing Exchange Remotely and Using Forms in Outlook 2010
- use OWA
- configure Outlook for using the Outlook Anywhere feature
- recognize how Outlook forms are used
- create a customized form
- publish forms
- connect remotely to Outlook 2010
- create and publish a custom form
Using Microsoft Office Access 2010
This course covers getting started with Access 2010, basic tables, basic forms, queries, reports, importing and exporting data and data presentation in Access 2010. The training will also teach you how to use advanced data management, programmability and administration as well as database administration in Access 2010.
Upon successful completion of this Microsoft Office Access 2010 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-885 MOS: Microsoft Office Access 2010. All of our Microsoft Office 2010 training courses map to MOS certification paths.
Learning Objectives:
Getting Started with Access 2010
- Recognize the fundamentals of Access 2010 databases
- Plan a basic Access 2010 database
- Recognize key features of the Access 2010 interface and their functions
- Create a database using a template
- Create a blank database
- Create a database from a template
- Create a blank database
- Add application parts to a database
Creating Basic Tables in Access 2010
- Recognize the correct naming convention for tables
- Create tables in Design view
- Create tables in Datasheet view
- Create a primary key for a table
- Create input masks for table fields
- Create indexes for table fields
- Create validation rules
- Modify tables
- Create a basic table
- Modify a basic table
Data Manipulation and Simple Relationships in Access 2010
- Modify how data is presented in datasheets
- Sort and filter records in datasheets
- Find and replace data in records
- Import data from an Excel spreadsheet into an Access database
- Export data from one Access database to another
- Recognize key characteristics of table relationships
- Create table relationships in a database
- Edit table relationships
- Sort and filter records
- Find and replace data
- Import and export data
- Create and edit table relationships in a database
Introduction to Forms in Access 2010
- Create basic forms
- Recognize how Layout view and Design view are used when modifying basic forms
- Configure controls on a form
- Configure a Web Browser Control on a form
- Configure input masks for bound controls
- Configure a control that refers to a control in another form
- Create a basic form
- Configure controls on a form
Modifying Basic Forms in Access 2010
- Customize forms
- Format forms by creating your own themes
- Manage records in forms
- Sort and filter records in forms
- Work with navigation forms
- Use a theme to format a form
- Manage records in forms
- Create a navigation form
Introduction to Queries in Access 2010
- Recognize the basic characteristics of queries
- Create basic select queries
- Modify queries
- Use calculations to refine query data
- Apply grouping and calculating functions to query results
- Create crosstab queries
- Create unmatched queries
- Create find duplicates queries
- Create and modify a Select query
- Refine a query using groupings and calculations
- Create a Crosstab query
- Create a Find duplicates query
Introduction to Reports in Access 2010
- Distinguish between the tools used to create reports
- Create reports using client-compatible and web-compatible report tools
- Create reports using non-web-compatible report tools
- Organize Access reports
- Add controls to a report
- Apply data bars to a report control to present data
- Create a chart in a report to present data
- Create a report using a client-compatible and web-compatible report tool
- Create a report using a non-web-compatible report tool
- Group data in a report
- Add controls to a report
Advanced Importing and Exporting with Access 2010
- Import data from one Access database into another Access database
- Import data from SQL Server into an Access database
- Link an Access database to data in SQL Server
- Export data from an Access database to a Word document
- Export data from an Access database to an Excel spreadsheet
- Export data from an Access database to an XML document
- Collect data by using e-mail messages
- Import Outlook 2010 contacts to a new Access 2010 table
- Import data in Access
- Export data from Access to other applications
- Use e-mail messages to collect data in Access
- Import an Outlook 2010 folder to a new Access 2010 table
PivotTables and PivotCharts in Access 2010
- Identify key characteristics of Access PivotTables
- Create a PivotTable in an Access database
- Use a PivotTable to analyze data
- Create a PivotChart in an Access database
- Use a PivotChart to analyze data
- Create a PivotTable and manipulate its data
- Create a PivotChart and manipulate its data
Retrieving, Validating, and Attaching Data in Access 2010
- Create a lookup field for data entry
- Modify the behavior of a lookup field
- Validate control data on a form using the Expression Builder
- Identify ways that attachments can be used in Access 2010
- Add an attachment to a table
- Add an attachment to a form
- Create a lookup field and change its behavior
- Validate control data on a form
- Add an attachment to a table
- Add an attachment to a form
Subforms, Subreports, and Conditional Formatting in Access 2010
- Create subforms
- Set the default view of a subform
- Create subreports
- Make design change subreports
- Apply conditional formatting to data in a report
- Change the priority of a conditional formatting rule
- Add a subform to a form and set it's default view
- Add a subreport to a report and prepare to make subsequent design alterations
- Use conditional formatting in a report
Joins, SQL, and Action Queries in Access 2010
- Create and edit joins in Access 2010 databases
- Creates a parameter query
- Modify data in existing tables
- Create a new table from data in other tables
- Delete data from an Access 2010 database
- Identify how to create a union queries
- Modify an object within a database using a data-definition query
- Access a hosted database with a view to running a pass-through query
- Remove duplicate records from a table using a subquery
- Specify a join in a query
- Use action queries to modify a database
- Create and refine queries using SQL
Using Access 2010 with SharePoint and Access Services
- Identify key characteristics of SharePoint and its integration with Access 2010
- Share data by linking Access to a SharePoint list
- Share data by exporting Access tables to SharePoint
- Share data by moving Access tables to SharePoint
- Use templates to create new SharePoint lists in Access
- Identify key characteristics of publishing Access 2010 applications on SharePoint
- Publish the entire Access application to SharePoint
- Share Access and SharePoint data
- Publish the entire Access application to SharePoint
Access 2010 Macros and VBA
- Create macros
- Execute macro actions conditionally
- Create data macros
- Work with data macros
- Recognize situations when you should use macros or VBA
- Convert macros to VBA
- Create macros
- Create a data macro
- Convert a macro to VBA
Optimizing, Securing, and Sharing Access 2010 Databases
- Use the Performance Analyzer to assess and improve database performance
- Use the Object Dependencies pane
- Use the Database Documenter to create a report on database objects
- Use the Table Analyzer Wizard to analyze and organize new data
- Describe how the Access 2010 security architecture works
- Manage signed packages
- Split a database
- Create a package solution for installing a database application on a client computer
- Specify an appropriate method of sharing an Access database
- Optimize the performance of an Access database
- Secure an Access database
- Share an Access database
Price: USD $299.00
USD
