The Ultimate Microsoft Office 2010 Training Bundle 48 Hours

Master advanced Excel 2010 graphing and charts, including spark lines and ribbon changes, with a functional approach to selecting chart types and applying conditional formatting for data visualization.

Master a four-step workflow to create charts in Excel 2010: select the data, insert the chart, choose a layout and design, and customize the chart.

Create and customize charts in Excel 2010, selecting contiguous or non-contiguous data and choosing 3D cylinder or pie chart types. Move charts, set defaults, and use F1 shortcuts to insert.

Learn to create and refine charts in Excel 2010 by using select data, switch rows and columns, edit series, choose chart types and layouts, and apply themes.

Explore how to format charts in Excel 2010 using the layout tab, customize the chart title and axis titles, and apply fills, borders, and 3D effects to chart elements.

Master positioning and formatting chart legends in Excel 2010, including left, top, or bottom placements, overlap handling, and data labels or data table options to boost readability.

Analyze how to format axes and grid lines in Excel 2010 charts, covering primary horizontal and vertical axes, tick marks, labels, display units, and major and minor grid lines.

Learn to create trend charts in Excel 2010 by plotting totals over years, adjusting titles, axis labels, and formatting for clear iPod sales trends.

Learn to reveal complex trends in quarterly sales by using line charts, trend lines, and moving averages, and to refine chart titles and axes for clarity.

Explore how Excel 2010 handles trends in charts, distinguishing date vs text axes, using trendlines and forecasting, and converting text quarters into proper dates for accurate trend analysis.

Learn to use bar charts to compare values and reveal differences between entities, including single and double bars, sorting data, reversing axis, and 2d and 3d bar charts.

Learn to build and format pie charts in Excel 2010, including 2D/3D pies, pie of pie, bar of pie, exploded variants, and data label options with leader lines.

Explore the limitations of pie charts with many categories and apply corrections like rotation, exploding slices, and highlighting; or use pie of pie or bar of pie for clearer comparisons.

Explore alternative charting methods in Excel 2010 for comparing land use across African countries, including pie, bar, donut, and 100 percent stacked column charts, with formatting tips.

Explore relationships using scatter charts and trend lines in Excel 2010, linking inquiries to season and to policies sold, and forecast outcomes with the trend line equation and R-squared.

Learn to present relationships with charts in Excel, using stacked bar charts with negative values, bubble charts for three variables, and radar charts to compare targets and scores.

Learn to chart financial information by analyzing stock prices and historical data from Yahoo! Finance, download data to a spreadsheet, and adjust for dividends and splits for Excel charts.

Learn to chart financial data in Excel 2010 by plotting adjusted closing prices, adding a secondary volume axis, and combining line and column charts for clear visual analysis.

Create high-low-close and candlestick charts in Excel 2010, using adjusted open, high, low, and close data, customize markers and colors, and incorporate volume for finance analysis.

Create a live percent-change chart in Excel 2010 that tracks FTSE 100 and Dow Jones via Yahoo Finance. Enable one-minute refresh and keep the data hidden for a clean dashboard.

Explore sparklines in Excel 2010 to visualize trends with line, column, and win/loss sparklines, manage grouped data, customize axes, and embed labels in cells.

Discover how to use data bars, color scales, and icon sets in Excel 2010 to visualize numbers, manage conditional formatting rules, and compare data across rivers, sales, and months.

Unlock powerful data analysis with pivot tables and pivot charts in Excel 2010 by converting data to a table, selecting fields, applying filters, and adjusting value settings.

Format pivot charts and tables in Excel 2010, adjusting data selections and chart types. Learn to add data labels, manage field lists, and group dates by month for sales analysis.

Filter pivot tables and charts to focus on monthly and yearly sales, create custom groupings (Eastern, Western, USA), and apply report filters and slices in Excel 2010.

Explore Excel 2010 pivot tables and charts by using slicers to filter data, adjusting groupings, and creating calculated fields to enhance analysis.

Explore Excel 2010 graphics tools, from drawing shapes and smart art to formatting, resizing, and aligning graphics that float over worksheets, using keyboard constraints and customization.

Learn to present sales data in Excel 2010 using SmartArt graphics, convert to shapes for live progress indicators toward monthly targets, and prepare visuals for transfer to Word.

Export Excel charts to Word and other Office 2010 components using paste options, links, and embedded workbooks. Control automatic updates, destination themes, and data integrity.

Explore exporting charts from Excel to Word or PowerPoint, weighing linking versus embedding, and using web publishing and formats like PNG, PDF, and XPS.

Start Word 2010 from the start menu or desktop shortcut, then explore the Word window, ribbons, Quick Access Toolbar, and Backstage view for recent documents and view modes.

Learn to customize the word workspace using the status bar and quick access toolbar, explore split views and zoom, and access online help.

Explore the word workspace basics, including dialog boxes, font options, and navigation shortcuts. Learn backstage view to manage files, printing, sharing, and word options in word 2010.

Create and customize Word 2010 documents using backstage view, templates, and new from existing options, then tailor page setup, including size, orientation, margins, and columns, and manage document properties.

Learn to manage formats across versions, open and save in backstage view, convert older documents to the format with save as, and use the document inspector to check for issues.

Master text editing in Word 2010 by selecting text, using copy and paste, performing cuts, undoing mistakes, and dragging and dropping paragraphs with keyboard shortcuts and the clipboard.

Edit with ease in Word 2010 by deleting characters, using Ctrl shortcuts to remove words, toggling insert versus overtype mode, and using the navigation pane to find and replace.

Learn automatic and manual hyphenation, auto-correct options, and undo/redo workflows in Word to improve document layout and editing accuracy.

Learn practical text formatting by selecting fonts, adjusting sizes, and applying bold, italic, underline, and color, plus using the font dialog and mini toolbar for quick edits.

Master paragraph formatting in the home tab by adjusting alignment (left, right, center, justify), line spacing via the ruler, margins, indents, and tab stops for selected paragraphs.

Explore using bullets, numbering, and multilevel lists to structure information. Apply borders and shading through the borders and shading dialog to enhance Word 2010 documents.

Explore creating and saving Word templates, using the templates folder and backstage view, and managing the normal template. Learn to apply and save styles, including elegant and custom style sets.

Learn how to create new paragraph styles, apply them across a document, modify and delete styles, use quick styles and the style inspector to reveal formatting.

apply themes across Word, Excel, and PowerPoint to create professional documents with a balanced palette of colors, fonts, and effects; save and customize themes for Office 2010.

Insert graphics and format pictures in Word 2010, using clipart or your own photos, resize, wrap text, and adjust layout for precise positioning.

Utilize picture tools in Word 2010 to apply styles, effects, and layouts to images. Adjust corrections, color, and artistic effects, and crop, crop to shape, remove background, and rotate options.

Master inserting screenshots and screen clipping in Word 2010 to capture full or partial screen images, then create stylized text with WordArt and its effects.

Create clear diagrams with smart art in Word 2007+, selecting categories, entering text, and formatting with smart art styles. Build an organization chart and adjust layouts using smart art tools.

Learn how to insert and format tables in Word, including empty, quick, and drawer tables; select, modify, and justify cells, rows, and columns for polished layouts.

Master Word 2010 table formatting by inserting a heading row, auto fit window, right aligning numbers, adjusting margins, and applying table styles, borders, and sorting.

Learn to insert and edit charts in Word with the insert chart tool and Excel data, switch chart types, apply styles, save templates, and delete charts.

Craft a bar chart from data pasted from an existing table of the world's 10 most populous countries, refine titles, axis labels, grid lines, and data labels for clear presentation.

Explore desktop publishing in Word to blend text, graphics and effects, mastering drop caps, watermarks, borders, shading, and page color for professional, publication-ready documents.

Explore how to create multi column layouts in Word 2010, adjust column width and spacing, and insert text boxes with wrap options for dynamic page design.

Learn to insert and resize shapes in Word, maintain proportions with corner handles, use the shift key for circles or squares, add text, rotate, and apply fills and effects.

Learn to align and stack objects in Word, use grid lines and snapping for precise placement, and group or ungroup shapes with the selection pane.

Learn to split long documents among multiple authors using outline view, manage heading levels, and create master and sub documents with continuous flow and section breaks.

Expand and collapse sections in a master document using outline view and section breaks, then insert subdocuments and manage document properties and cover pages.

Learn to insert and customize a table of contents in Word 2010, apply levels and tab leaders, and use header and footer tools with quick parts and document properties.

Master line numbering options in Word 2010; manage bibliographies and citations with various styles and insert an index with cross-reference entries for technical documents.

Reveal formatting marks to see hidden codes, manage sections as mini documents with unique margins, headers, footers, and page numbering, and master subdocuments while updating tables of contents and indexes.

Learn to insert symbols and equations in Word 2010, using auto correct, shortcuts, and building blocks to add auto text, quick parts, and dynamic content like text boxes.

Learn to insert footnotes and endnotes, add bookmarks, and create cross references to link related content, while using the navigation pane and go to features to navigate long documents.

Master mail merge in Word 2010 using the wizard, from preparing Excel data to selecting recipients, inserting address blocks, and previewing personalized letters.

Set up and run a manual mail merge in Word to create personalized letters and labels from CSV or Outlook data, preview results, and print or email.

Learn how to perform spelling and grammar checks in Word 2010, manage proofing options, use the custom dictionary, and apply ignore and auto correct rules for accurate documents.

Explore Word's research, thesaurus, and translate tools to enhance writing and language quality. Learn to print with page setup, margins, orientation, and printer options for precise document proofing.

Publish Word documents to the web by saving as html or single-file web pages, preview in a browser, and access or edit pages within Word.

Explore document protection in word 2010, using the trust center, document inspector, password encryption, and editing restrictions to control access, permissions, and privacy.

Discover how to collaborate in Word 2010 by creating and navigating comments, changing user identity, and tracking edits with accept/reject changes and show mark-up controls.

Explore how to customize Word 2010 settings to suit your workflow, including live preview, toolbars, display of formatting marks, auto recover, language options, and ribbon customization.

Explore how to expand word functionality with add-ins, VBA and macros, including recording macros, assigning keyboard shortcuts, and building forms with rich text controls, date picker, and ActiveX tools.

Learn how Word 2010 imports and exports data with other programs. Explore copying, pasting, saving as PDF, linking and embedding Excel data, and transferring outlines between Word and PowerPoint.

Keep Word 2010 up to date by checking updates, use autosave and auto recover, compare versions, recover unsaved documents, start in safe mode, and repair Office installations.

Explore Outlook 2010 on Windows 7, including the ribbon, navigation pane, and reading pane, and learn to compose, send, and manage emails with inbox and sent items.

Invite learners to leave a five-star review if they gain value, share feedback to improve training material, and feel free to update the review later.

Navigate Outlook 2010's calendar, contacts, tasks, notes, and journal to manage appointments, invites, and reminders. Create and view entries, customize contact views, and log activities across modules.

Learn how to add and remove Outlook 2010 email accounts (MAPI, IMAP, POP) from Backstage view, set default accounts, and manage sending from multiple addresses.

Use the to-do bar in outlook 2010 to manage appointments, tasks, and flagged emails, customize categories, and adjust display options such as months shown and date navigator.

Learn how to create new tasks, modify details, set reminders and flags, and manage recurring tasks in Outlook 2010, including inline edits, keyboard shortcuts, and calendar views.

Explore the Outlook 2010 calendar, switch views, and navigate with the date picker and go-to date features; learn to create, edit, drag to move, adjust duration, and delete appointments.

Explore Outlook 2010 help options and master add, edit, and delete contacts in Outlook's contact views. Learn to create new contacts, customize fields, and set follow-up reminders.

Create, edit, and forward notes in Outlook 2010. Explore notes in the notes module with icon view, list view, and last seven days view, and use search and categorization.

Explore Outlook 2010 journal feature, enabling automatic or manual entries for emails, meeting requests, and tasks; view timelines and lists, and learn to drag appointments into the journal.

Customize the Quick Access Toolbar and the Ribbon in Outlook 2010, explore backstage view and options, and learn to add groups, tabs, and commands.

Learn to customize Outlook 2010 workspace views, including list and table views, by adding and resizing columns, sorting by multiple fields, and removing grouping for clearer contact and calendar layouts.

Explore how to customize the Outlook 2010 workspace, including viewing options, column management, sorting and grouping, and saving personalized views for contacts, tasks, and calendar.

Navigate Outlook data files and folders in backstage view, learn locations for inbox, sent items, deleted items, and junk mail, and create custom folders for centralized storage.

Explore how the Outlook Connector synchronizes a Windows Live Hotmail account with Outlook, merging email and contacts across local data files, while organizing with folders and the reading pane.

Learn to automate Outlook 2010 emails by creating rules for sent and received messages, moving items to folders, flagging with alerts, and configuring send and receive schedules.

Explore formatting email messages in Outlook 2010, comparing plain text, rich text, and HTML; apply themes and styles, attach files, add signatures, run spell check, and save drafts.

Explore Outlook 2010 general mail options, including composing messages, spell check, signatures, stationery and fonts, desktop alerts, conversations, replies and forwards, drafts, recipient checking, and high or low importance flags.

Learn how to create and assign tasks in Outlook, set start and due dates, priorities, and progress, and complete or forward tasks while tracking status and using task views.

Learn to forward and share contact details as business cards or vcards, customize business cards, create and manage contact groups, and print individual or full contact lists in various layouts.

Schedule meetings in Outlook 2010 by inviting attendees, checking availability, setting reminders, and using calendar options like time zones, all-day events, and hyperlinks.

discover how rss, or really simple syndication, provides a standard format to access content from podcasts, blogs, and social media, and how to set up rss feeds in outlook.

Organize RSS feeds with folders and mark items as read, then subscribe to YouTube feeds and connect contacts through Outlook 2010's social connector for LinkedIn and Facebook.

Explore junk mail management in Outlook 2010 by configuring the junk email options, including blocked senders, safe senders and recipients, phishing protections, plus international and encoding filters for handling.

Explore Outlook 2010 filters and advanced search to block junk mail and locate messages fast, using unread filters, refined criteria, and search folders that view items without copying.

Understand how archiving controls Outlook data file growth and supports regulatory retention, using auto archive or manual archive settings to manage inbox, calendar, and deleted items.

Back up Outlook data files regularly by copying them when Outlook is closed, and protect with antivirus, optional password, and encrypted email using digital IDs along with Exchange offline features.

Explore PowerPoint 2010 from basics to presenting across four chapters, covering the ribbon and backstage, slides, text, templates, multimedia, animations, and cross-application sharing.

Explore PowerPoint 2010 basics by navigating the PowerPoint window, the ribbon, and the backstage, learning to start, open, save, close, and configure options, and review available views.

Learn how to start PowerPoint 2010 using desktop icons, start menu, or double-clicking files, and how to exit with save prompts and cancel options.

Explore the PowerPoint 2010 window, including the slide pane, outline pane, ribbon, quick access toolbar, and bottom controls, and learn to manage slides, outlines, views, themes, and zoom.

Explore the PowerPoint 2010 ribbon organization, including default and contextual tabs and tab groups, and the backstage file tab. Learn how selection activates font, paragraph, and design commands.

Explore the PowerPoint 2010 backstage view to open, save, and close presentations, access recent files, new blank or template-based slides, and manage sharing options and permissions.

Explore PowerPoint 2010 options in the backstage, learn how nine general categories influence current and future presentations, and review key settings like color scheme, proofing, and embedded fonts.

Master the four PowerPoint 2010 views—normal view, slide sorter, slideshow, and reading view—and learn to switch between them, edit slides in normal view, and present with slide show options.

Explore how to work with slides by managing slide appearance and text. Utilize outlining slide management, shapes, tables, smart art, templates, and themes to craft cohesive presentations.

Master slide appearance in PowerPoint by using slide masters and layout masters to apply global formatting, customize bullets and fonts, and manage footers across multiple masters.

Master text handling in PowerPoint 2010, from placeholders and layouts to advanced formatting, word art, and headers and footers, with practical insertion and slide show previews.

Outline your PowerPoint presentations effectively by using the outline pane to organize slides, points, and text, demote or promote points, switch to slide view, and print outlines for review.

Learn to navigate, insert, move, duplicate, and reuse slides from other presentations using the slide sorter and normal view, while managing source formatting and the slide master.

Learn to insert and draw shapes in PowerPoint, combine simple shapes into complex forms, and place text and word art inside them for dynamic slides.

Learn to create, insert, and manage tables in PowerPoint slides. Configure rows and columns, merge cells, and apply borders, shading, and table styles for a professional look.

Explore smart art in PowerPoint, including lists, processes, cycles, hierarchies, relationships, matrices, pyramids, and pictures; know your audience, level of knowledge, and work style per Moedas perspective, and use animation.

Learn how templates control PowerPoint themes, colors, fonts, and effects, and how to save, apply, and test custom themes across slides using the design tab and slide show view.

Learn to use predefined and custom templates in PowerPoint 2010, apply them to new or existing presentations, and edit slide masters and layout masters.

Explore beyond the basics by adding hyperlinks, clip art, screenshots, and multimedia in PowerPoint 2010, then apply animation, transitions, compare and merge presentations, and share with other Office 2010 apps.

Learn to create and manage PowerPoint hyperlinks to websites, files, emails, and other presentations, with security prompts, text links, and hidden-slide navigation via action buttons.

Explore how to insert and format clip art, pictures, and screenshots in PowerPoint 2010, crop and resize, apply borders and effects, and use smart art and animations.

Learn to insert and control audio and video in PowerPoint presentations, including clip art audio, file audio, full-screen video, playback options, trimming, fading, looping, and slide-triggered playback.

Master animation in slides by applying entrance, emphasis, exit, and motion path effects with precise timing, sequencing, on-click triggers, and animation pane controls.

Explore PowerPoint transitions, including slide motions, direction, speed, and optional sounds. Apply transitions globally or per slide, manage hidden slides, and preview in slide sorter view.

compare two versions of the same presentation, designate a final version, and merge changes using outline mode, comments, and review features to streamline editing.

Discover how to share content across Office 2010 apps using a shared clipboard, embed Excel objects in PowerPoint, and convert Word outlines into slides.

Master PowerPoint basics by creating notes, handouts, and printing slides, and by building automated or self-running shows, while learning to annotate during presentations.

Use PowerPoint 2010 notes to add slide scripts beneath slides; print them as handouts. Format notes with the notes master, add headers and footers, use presenter view with dual monitors.

Create customized PowerPoint handouts that accompany presentations, offering one to nine slides per page or electronic pre-distribution, with flexible headers, footers, and print options.

Print your PowerPoint with flexible options, including hidden slides, outline view, notes or handouts, headers and footers, and color, grayscale, or black and white printing.

Learn to create automated self-running PowerPoint presentations by recording slide timings, looping until escape, and managing animation to suit trade shows and conferences.

Annotate slides in PowerPoint 2010 during presentation using pen and highlighter, adjust ink colors and laser pointer, and decide to keep or discard annotations after the slideshow.

Learn how effective presentations reduce misunderstanding and audience resistance, reinforce key ideas, and keep attention, while PowerPoint supports the verbal message with visual emphasis; avoiding death by PowerPoint through planning.

Explore how to navigate Access 2010 using backstage view, the ribbon, and the quick access toolbar, customize commands, and use the navigation pane to manage database objects.

Discover ways to start Access 2010, access help and training, and work with four views—form view, datasheet view, layout view, and design view—while saving North Wind databases and templates.

Explore the basics of databases with the North Wind Traders example, defining databases as structured records and fields and reviewing core objects like tables, forms, queries, and reports.

Explore how to design and build a database using the North Wind Traders example, identifying tables, primary keys, and foreign keys to establish relational structure.

Learn to create a blank Access 2010 database, build a private tutor database from scratch, and explore templates like North Wind to manage students, courses, exams, and billing.

Build a private tutor database by creating tables for students and invoices with primary keys and auto numbers. Establish a one-to-many relationship with referential integrity to link invoices to students.

Create a tasks table with Access 2010 application parts and QuickStart, link it to students, and import courses from Excel as a table with course code as primary key.

Learn how to define data types and enter records in Access tables, set primary keys, prevent duplicates, and paste append data from Excel to expand the database.

Learn to customize table appearance and manage data in access by copying, renaming, deleting records, adjusting row height and column width, freezing fields, and handling cascade deletes.

Explore how to design and manage fields in Microsoft Access tables, including adding, renaming, deleting, and rearranging fields, selecting data types, and using datasheet views with captions and descriptions.

Explore table and field properties in Access 2010, including text and date/time data types, field size, captions, validation, indexing, input masks, and the lookup wizard with examples.

Explore how auto-create data entry forms in Access 2010 improves efficiency, with a form wizard guided creation, searching, filtering, and task-focused layouts for courses and employee records.

Learn to create and customize forms in Access using the form wizard, blank form, datasheet form, multiple items form, and split form, plus subforms and design and layout view.

Improve the look, feel, and usability of forms by editing subforms in design and layout views, resizing and rearranging fields, removing layouts, and applying Office 2010 themes.

Learn how to add an existing field to a subform, manage a width of 19 centimeters, and align the new priority field with proper tab order in design view.

Explore the expression builder in Access 2010 to perform calculations, comparisons, and data validation with built-in date and time functions like now, and set a 30-day default for invoice dates.

Apply conditional formatting on Access 2010 forms and reports to flag upcoming due dates. Build calculated controls to implement a 10 percent prepaid discount with currency formatting.

Learn to sort and filter data in the North Wind database using single and multi-field methods, advanced filters for state and last name, and date-time ordering.

Learn how to sort and filter data in form view and use multi-field filters in the North Wind database. Master find and replace in forms for safe, targeted updates.

Access 2010 reports teach presenting database data with headers, groupings, and totals, using the North Wind customer address book and quarterly sales report examples.

Create and customize simple and complex reports from the courses table using the report wizard, then preview and adjust layout and print settings to ensure accurate, well-formatted outputs.

Develop an advanced report for the private duty database that lists each student and their tasks, with fields from the student and tasks tables, sorted by due date and priority.

Add existing fields in design view, adjust borders, and use print preview; group by instrument and sort by course code, then export or email reports in PDF or Excel.

Master select queries in Access 2010 to filter, sort, and summarize invoices, apply defined criteria, and join tables to display related student names with the invoice details.

Modify query fields and sort order across joined tables while previewing results. Use numeric criteria, text criteria with like and wildcards, the expression builder, and parameters to build dynamic queries.

Explore update, append, and delete queries in Access to modify tables, add records from one table to another, and remove matching records, including calculating 90 percent of the hourly rate.

Explore inner and outer joins in Access, create make table queries to generate overdue invoice tables, and perform a mail merge with Word for automated reminders.

Explore Access 2010 security features, including password protection, database encryption, exclusive access, and user restrictions via VBA and the ribbon. Learn how to enforce modal login and log user activity.

Master advanced Access 2010 concepts, including production-ready database design, templates, and the use of macros and VBA modules, starting from the student database sample.

Explore macro basics in Access 2010, compare macros with VBA, and build a simple macro that shows a message box, then run and name it using recommended conventions.

Discover how the auto exec macro runs on opening an Access 2010 database, opening forms like student list or guardian list, and controlling startup options via a settings table.

Learn to distribute an access database by configuring current database options, including application title and icon, splash screens, document window settings, and navigation pane control via access special keys.

Explore key access 2010 database options, including compact on close, remove personal information, layout view, datasheet design changes, and navigation pane and ribbon customization.

Explore best practices for naming objects in an Access 2010 database, using prefixes like tibble for tables and efrem for forms, and avoiding spaces through camel case.

Explore how to work with Access 2010 tables, including field names, data types, and properties, and learn about primary keys, field sizes, validations, and input masks.

Discover how to set and use field properties in Access 2010, focusing on format and input mask to control data display, validation, and data entry across tables and forms.

Master validation rules and validation text, illustrated by date-of-birth constraints and form-versus-table validation. Learn about three-state fields, unicode compression, and text alignment in Access forms and tables.

Explore primary keys and auto number in Access, why unique identifiers matter, and composite keys, then learn indexing, trade-offs, and data normalization in database design.

Explore data normalization in Access 2010 by transforming a students courses table into first, second, and third normal forms, using primary and foreign keys to link student and course data.

Explore how to design and enforce relationships between students, attendance, and courses in an Access database, including one-to-many, many-to-many via join tables, and referential integrity with cascade options.

Learn to set up and manually manage table relationships in Access, including one-to-one and many-to-many via a junction table, with referential integrity and proper keys.

Design and run Access 2010 select queries on the students table, selecting last name, first name, and home phone, sorting and applying state criteria, with results usable in subqueries.

Explore advanced access 2010 queries by creating calculated fields that combine first and last names, sorting by surname, and handling missing guardian data with if is null expressions.

Master advanced access 2010 queries by nesting if statements, using inner, left, and right joins, and creating sub-queries that combine student and attendance data for reporting.

Explore datasheet view to enter and manage student data and guardians, applying quick sorts, advanced filters, and column customization with alternate row colors and grid lines.

Explore creating and working with forms in Access 2010, including datasheet view and form interfaces, form wizard, blank form, form design, navigation and split forms, and form properties.

Master the student list form in a Microsoft Access 2010 database, using open and new actions, a macro-driven workflow, and requery to view or add student details.

Learn how command buttons in access 2010 forms use embedded macros to add new students, open the student details form, and show or hide fields with a subform for courses.

Explore the NZ function for view or add modes and duplicate checks, and review key Access 2010 commands like close, save and new, Outlook contact, and attachments on the form.

Discover how to enhance Access 2010 forms with VBA and macros, including guardian details and guardian list forms, plus search and filter features and a splash screen.

Learn to use visual basic for applications (VBA) in the Microsoft Office suite, compare macros and VBA, and build portable, modular code for forms and timer events in Access 2010.

Learn to improve a student database using VBA by creating an about form with licensee, version, and copyright stored in table, adding a VBA close button, and introducing switchboard navigation.

Learn how to structure VBA code, organize into modules, and build a switchboard by wiring exit and open form commands, using string variables, dim, and option explicit.

Master VBA basics: manage variable scope with public and private declarations, implement runtime error handling with on error goto and message boxes, and control flow with if statements.

Package your Access project for distribution by finalizing buttons, splash screen, and autoexec. Create an acda file to protect design and compiled VBA while hiding the navigation pane.

Explore security techniques for access databases, including active format and runtime mode, encrypting with password, and protecting forms, tables, and VBA code for a secure student database.

Learn to import data from Excel, text, and XML into Access 2010 and to link to external sources, plus export data to XML.

Link data in Access 2010 by connecting to Excel workbooks and other databases, distinguishing linking from importing, and using the linked table manager to keep data synchronized and break links.

Separate the user interface from the data in Access 2010 by splitting the front end from the back end, including forms and reports, to support multi-user access, backups, and upgrades.

Explore how to configure multiuser access in Access 2010, balancing data safety and usability by choosing shared open mode, locking strategies, and performance settings like refresh intervals and update retries.

Explore advanced report features in Access 2010, including grouping and sorting with group sort and total, handling emergency contact information and guardian details for each student.

Examine advanced Access 2010 report features, focusing on grouping and sorting, including first-character alphabetical grouping, custom character options, and totals in address book and level-based reports.

Test your Access 2010 application thoroughly, including multi-user scenarios, before distribution. Package a runtime deployment with the package solution wizard, including clear installation, documentation, and user guidance.

Explore Copilot in Excel, Word, and PowerPoint, compare Copilot for Bing, Copilot Pro, and Copilot for Microsoft 365, and learn licensing, OneDrive, autosave, and hands-on demos.