Research Resource Discovery

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

With Acrobat 9, Adobe continues to evolve the venerable PDF from a simple paperless document into a collaborative hub for many forms of digital communication. In Acrobat 9 Pro Essential Training, Brian Wood explores the many new and enhanced features in version 9 of Acrobat Standard, Acrobat Pro, and Acrobat Pro Extended. He demonstrates different ways to create and modify PDFs, including the enhanced OCR tool, and shows how to combine them with other files into a PDF Portfolio. Brian covers collaboration in detail, including the new Collaborate Live and Shared Review options. He also investigates redaction and other security features. Example files accompany the course.

Accessibility means making sure your content is available to as many people as possible. When you make your PDFs accessible, it means adding tags, bookmarks, alt text, and other information that makes the files readable to users who are visually or mobility impaired. Using Acrobat DC, and other tools such as Microsoft Word and Adobe InDesign, it's now much easier and faster to create valid, accessible PDF files. In this course, Chad Chelius explains why accessibility is important and what features an accessible PDF should include, and shows how to streamline the process of creating accessible PDFs using Word, Excel, PowerPoint, InDesign, and Acrobat DC.

Learn how to take static PDF documents and turn them into interactive forms with Acrobat DC. Garrick Chow shows how to add interactive form fields—everything from text and check boxes to radio buttons and list boxes—and how to trigger actions with buttons. The course also explores how to automate form creation with the Form Wizard, perform calculations, work with signatures, distribute forms, and use the data gathered from forms.