Comprehensive Software Search

Viewing: 126 - 150 of 8416.

Access 2016: Advanced Tips and Tricks

These tips and techniques will help Access developers create a better user experience and transform a boring database into a fast, efficient, and even fun environment. Access expert Adam Wilbert shows how to remove typical Access interface elements (like the Welcome screen) for a better startup experience, and borrow some tricks from web design to make your database more attractive and interactive. Plus, learn how to clean up a cluttered navigation pane, leverage hidden system objects, filter long lists with cascading combo boxes, and build in contextual help and keyboard shortcuts that your power users will thank you for.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Access 2016: Building Dashboards for Excel

Using Excel, you can optimize reporting for Access databases. Learn how to build powerful dashboards to visualize your data, using tools such as slicers, timelines, charts, and PivotCharts. Instructor Robin Hunt shows how to analyze, query, and export Access data for use in Excel, and connect directly to Access from Excel, so that you always have a live view of your data. Then learn how to build dashboards with slicers, timelines, and charts, and create macros that make your dashboards more user friendly. By the end of the course, you should be able to extend your current reporting capabilities and create more engaging visualizations.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Access 2016 Essential Training

Learn how to build databases to store and retrieve your data more efficiently with Access 2016. Adam Wilbert shows how to use the powerful program to wrangle your data and create your first table, and highlights smart strategies to edit and modify fields and records.

The course also shows you how to build queries and action queries, create and design forms, use macros, integrate Access with the rest of the Office 2016 suite, and maintain your databases over time.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Access 2016: Forms and Reports

Learn how to use Access forms and reports to control and organize the display of your data, as well as gather parameters for queries. Access expert Adam Wilbert starts with the basics of form design and leveraging controls such as buttons, links, and macros. He combines these ideas in a chapter that shows how to build an application-like framework for getting around an Access 2016 database.

Then the course dives into reports: creating efficient and readable layouts, grouping data into categories, tying reports to queries, and using conditional formatting rules to highlight key takeaways from the data. Finally, Adam demonstrates how to link forms and reports and print your results, and introduces unique ways to save time filling out paperwork and generating form letters.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Access 2016: Queries

Learn how to find and translate complex raw data into information you can use to make better decisions, with Access queries. Access expert Adam Wilbert explains how to create real-world queries to filter and sort data and perform calculations, as well as refine query results with built-in functions, all while offering challenges that help you master the material. Find out how to identify top performers, automate repetitive analysis tasks, make queries more flexible with parameter requests, and increase accuracy and consistency in your database using program flow functions. Adam closes with an assortment of useful query tricks. Take the challenges posed along the way to test and practice your new Access skills.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Access 2016: Reporting to Web Systems

Access databases typically live on your desktop and are shared with a limited number of users over a local network. Microsoft SharePoint integration allows you to share data on the web, but this solution can be complicated for many users. There are several alternatives that you can consider. By leveraging web-friendly data formats—such as a basic HTML table or machine-readable XML, CSV, and JSON data files—or connecting to a hosted Microsoft Azure database, Access users can expand the reach of their data and reports.

In this course, Adam Wilbert shows you how, by exploring options for getting your data out of Microsoft Access, making it easier to share with others. He covers Access data export options, and demonstrates how to modify exported files with a text editor. He also explains how to link Access to an Azure SQL database to provide a cloud storage solution for your Access tables.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Access: Building a Sales Database

Whether you work in sales or customer service, you need a way to track your sales activity, relationships, and contacts. Microsoft Access is a powerful relational database program that can help you do all that and more. In this course, Laurie Ulrich shows you the ins and outs building a customized database solution, designed for the way you go about selling. If you don't have a satisfactory customer relationship management (CRM) application, you'll appreciate the power Access puts literally at your fingertips to design a completely customized tool. The sales solution database you design—with Laurie's help and examples—will allow you to build and store customer data, look up customer orders, and generate reports such as product price lists and order totals. Along the way, you can learn more intermediate and advanced Access features, such as validation rules, lookup tables, and macros. Plus, learn how to build a navigation form that puts key forms and reports in a single, easy-to-access location.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Access: Building a Sales Database

Whether you work in sales or customer service, you need a way to track your sales activity, relationships, and contacts. Microsoft Access is a powerful relational database program that can help you do all that and more. In this course, Laurie Ulrich shows you the ins and outs building a customized database solution, designed for the way you go about selling. If you don't have a satisfactory customer relationship management (CRM) application, you'll appreciate the power Access puts literally at your fingertips to design a completely customized tool. The sales solution database you design—with Laurie's help and examples—will allow you to build and store customer data, look up customer orders, and generate reports such as product price lists and order totals. Along the way, you can learn more intermediate and advanced Access features, such as validation rules, lookup tables, and macros. Plus, learn how to build a navigation form that puts key forms and reports in a single, easy-to-access location.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Access Grid Tutorials

This tutorial provides the information needed to determine the benefits of establishing an Access Grid Node at your organization and the resources you will need to set up and operate it. Note that this tutorial is a compilation of the set of twelve AG Tutorials previously offered in CI-Tutor. The content is no longer being updated and addresses older AG Software but the general information provided may still be useful for learning about the Access Grid.

Affiliation: UIUC
Provider: CI-Tutor
Type: Streaming Resource

Accessibility for Web Design

Are you doing everything you can to make sure your sites are accessible and easy to use? Learn practical accessibility techniques to ensure your web designs can be viewed and used by everyone. Internationally recognized accessibility expert Derek Featherstone walks through examples of common web interaction flows, and then steps through considerations and tactical strategies for each component, to assure that people with disabilities can easily complete those tasks. Learn the proper use of color, contrast, and motion, and find out how to design keyboard interactions and touch interfaces; incorporate images, sound, and video; design accessible forms; structure content at the tag level; and balance responsive design with accessibility.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Accessibility Outreach

Accessibility Outreach ensures departmental and group resources and services meet the accessibility requirements mandated by the Illinois IT Accessibility Act and Section 508 of the Rehabilitation Act.

Affiliation: UIUC
Provider: Technology Services
Type: Web Publishing And Communication

Accessing Existing Databases with Entity Framework Core

Not every .NET development project starts from scratch. Often you're rewriting applications to take advantage of different data sources, or to make connections to legacy data in more efficient ways. Entity Framework (EF) plays extremely well with existing databases, and it can generate some of the data-access code for you automatically. Using the practical techniques shown in this course, you will be able to use EF Core with existing relational databases, and modify the generated code as necessary. Richard Goforth shows how to connect to a database, scaffold a model from it, and begin improving on that model. He uses shadow properties, backing fields, inheritance relationships, concurrency tokens, and other techniques to best map a database to an application. No matter how untidy your tables and fields, EF will help you write clean, cross-platform code that is easy to maintain in the long run.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Access: VBA

Enhance productivity by automating routine tasks and providing custom functionality not built into Access with a few basics in VBA code. Author Curt Frye introduces object-oriented programming and provides database designers with a foundation in the Access object model and the Visual Basic for Applications (VBA) programming language. The course covers automating tasks with macros, working in the Visual Basic Editor, writing functions, adding logic, reading data, controlling forms, and more.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Accounting Foundations

Learn about external financial statements, internal managerial accounting reports, income tax systems and how they interact in business decision-making. Brothers and professors of accounting at Brigham Young University Jim and Kay Stice review the accounting equation, the three primary financial statements, how to use accounting to aid decision making, and how income taxes figure into business and personal decisions. They use real-world example data from Walmart and other business so you can see how numbers drive everything from wages and product costs to home budgets.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Accounting Foundations: Bookkeeping

Accountants use the credits and debits recorded in ledgers or "books" prepared by bookkeepers to create a company's financial statements. In this course, accounting professors Jim and Kay Stice walk you through the four key steps in the bookkeeping process: analyzing, recording, summarizing transactions, and preparing financial reports. They explain the components of a journal entry (debits and credits) and the essential questions a bookkeeper/accountant asks in reviewing those transactions. They also explain how accountants translate ledger information into financial statements, and the role of computer programs such as Quicken in helping businesses manage their accounts.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Accounting Foundations: Budgeting

Growing companies don't have a long history to guide management decisions. But they can't go on reacting to one crisis after another without a plan. Such companies need to harness the power of budgeting to identify and solve problems on paper before they arise in the real world.

This course covers purchase budgets, production budgets, hiring budgets, overhead budgets, and cash budgets. Professors Jim and Kay Stice help you weigh the impact of strict versus more moderate budgeting on employee morale, and show how budgets pay off in the future, when you can use them to evaluate your business performance.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Accounting Foundations: Managerial Accounting

Managerial accounting helps managers make decisions using an organization's financial data. An understanding of managerial accounting helps you figure out how much a product costs, analyze when your company breaks even, and budget for expenses and future growth. In this course, accounting professors Jim and Kay Stice cover all the fundamentals, including costs and cost behaviors, cost-volume-profit (CVP) relationships, cost flows, standard costing and activity-based costing, and budgeting.

Want to hear more from Jim and Kay? Learn about all three types of accounting—financial, managerial, and income tax—in their Accounting Fundamentals course.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Achieving Your Goals

Setting achievable goals is one of the first steps toward a successful career and meaningful personal development. In this business skills course for lynda.com, author Dave Crenshaw shows smart ways to create a vision, develop a quantifiable goal, turn that goal into actions, and share that commitment publicly to establish accountability.

Along the way, discover the importance of celebrating successes and reviewing your progress in order to stay motivated and establish a pattern of successful goal setting.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Acing Your Interview (2013)

Ace your interview and land the job you want. Join author Valerie Sutton as she explores the different types of interview questions and styles you might expect, and how to prepare for them by researching the company and practicing your answers. Uncover the best ways to create a good first impression and navigate the interview, as well as handle the tricky questions and identify the unlawful ones. Plus, learn how to assess your own performance, thank the company for their time, and follow up on a decision.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Acoustic Guitar Lessons: 1 Picking, Fretting, & Chords

The bluegrass style is one of the most rewarding and technically demanding ways to play guitar. Unlike acoustic guitar, it concentrates on rhythm, groove, and playing as part of an ensemble—the skills Grammy-winning flatpicker Bryan Sutton emphasizes in his series, Bluegrass Guitar Lessons. Part 1 concentrates on the fundamentals of bluegrass guitar: picking and fretting, posture, and flatpicking flow. Bryan covers everything from holding the guitar and pick to strumming, fingering the fretboard, and using downstrokes, upstrokes, and repetition to reproduce popular picking patterns. He also helps you develop a sense of rhythm, muscle memory, and consistent sound and tone, and breaks down a selection of popular bluegrass tunes that are important for the repertoire of any bluegrass guitarist.

Note: This course was recorded and produced by ArtistWorks. We are honored to host this training in our library.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Acoustic Guitar Lessons: 2 Scales, Walking Bass, Hammer-Ons, and Pull-Offs

The bluegrass style is one of the most rewarding and technically demanding ways to play guitar. Learn how to play bluegrass guitar or improve your current flatpicking and fretting skills in this course—part 2 of the Bluegrass Guitar Lessons series with Grammy-winning flatpicker Bryan Sutton. Learn how to build strength and fingerboard awareness, and expand what you can do with the rhythm guitar with "walking bass" movement and advanced scales. Find out how to create more expressive sounds and play more efficiently with hammer-ons and pull-offs, and how to use a capo and slide.

Watch at your own pace; start and stop where and when you need. Everything that Bryan breaks down he puts back together in chapters 4 and 5, where he shows how to apply what you've learned to a selection of popular bluegrass tunes that are important for the repertoire of any bluegrass guitarist.

Note: This course was recorded and produced by ArtistWorks. We are honored to host this training in our library.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Acoustic Guitar Lessons: 3 Rhythm & Voicings

Learn how to play bluegrass guitar—one of the most rewarding and technically demanding ways to play guitar. In part 3 of the Bluegrass Guitar Lessons series, Grammy-winning flatpicker Bryan Sutton concentrates on big-picture techniques that will help you develop your own personal sound. Learn intermediate techniques for fretting without tension and embellishing your sound with hammer-ons and pull-offs. Find out how to move beyond basic rhythms into more complex bass strum patterns, phrasing, and scale walking. Open up the fretboard with some exciting new scales and chord shapes. Bryan shows how to apply what you've learned to intermediate versions of popular bluegrass tunes, such as "Turkey in the Straw" and "Soldier's Joy." Watch at your own pace; start and stop where and when you need. Each lesson helps you add a challenging new dimension to your sound, and improve your overall musicality.

Note: This course was recorded and produced by ArtistWorks. We are honored to host this training in our library.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Acoustic Guitar Lessons: 4 Feel & Crosspicking

The bluegrass style is one of the most rewarding and technically demanding ways to play guitar. Once you've mastered the basics, you can play most songs. But becoming a great bluegrass guitarist has a lot to do with feel and dexterity—skills you can only master with the help of a great teacher. Bryan Sutton is arguably the best flatpick guitarist since the late great Doc Watson. In this course, part 4 of Bluegrass Guitar Lessons, he shares his Grammy-winning techniques with you.

Learn how to maintain flatpicking flow—consistent tone, groove, and musicality. Find out how to play along role-oriented lines, and find more musical opportunities. In chapters 3, 4, and 5, Bryan shows how to apply what you've learned to intermediate versions of popular bluegrass tunes. Each lesson helps you add a challenging new dimension to your sound, and improve your overall musicality.

Note: This course was recorded and produced by ArtistWorks. We are honored to host this training in our library.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Acoustic Guitar Lessons: Intermediate

Once you've mastered the basics of acoustic guitar, you're ready to expand your repertoire and tackle more challenging techniques. Join guitarist Jared Meeker as he guides you through intermediate concepts like soloing patterns and altered tunings in a relaxed, easy-to-follow instructional style. Learn about suspended chords, tuning with harmonics, and slides. Take on a variety of new styles, including acoustic funk, New Orleans grooves, modern Celtic rhythm guitar, bluegrass, and Delta blues. Jared also touches on harmony for writing and arranging, as well as Drop D, Double Drop D, Open G, and Open D tuning. Tune in and take your acoustic guitar skills to the next level.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource

Acrobat 9 Pro: Creating Forms

PDF forms can be much more than something to print, fill out by hand, and fax back. Interactive fields allow for a web-like user experience, and submission via email or server can enable a truly paperless exchange of information. Acrobat 9 Pro makes interactive form creation and distribution more powerful and flexible than ever, but such a wealth of features and options can be daunting. Brian Wood focuses exclusively on the nuances of this process in Acrobat 9 Pro: Creating Forms. He discusses the fundamentals of Acrobat forms, fields, and distribution, and explores the built-in form creation tools available in Acrobat 9. Brian also demonstrates the XML-driven forms that can be created by the Windows-only LiveCycle Designer application, included with Acrobat 9 Pro and Pro Extended. Example files accompany the course.

Affiliation: UIUC
Provider: Lynda.com
Type: Streaming Resource



Pages