Comprehensive Software Search

Viewing: 151 - 175 of 10914.

Access 2007: Shortcuts

In Access 2007 Power Shortcuts, Access expert Alicia Katz Pollock shares hundreds of tips and shortcuts to vastly increase efficiency and get the full power out of Access 2007. The course includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Exercise files accompany the course.

Type: Streaming Resource

Access 2010 Essential Training

In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.

Type: Streaming Resource

Access 2010: Forms and Reports

Discover how to manage data entry and reporting tasks more efficiently using Access 2010. Author Adam Wilbert presents lessons on designing forms, organizing and displaying data with form controls, creating flexible queries, and building a form-based navigation system. The course also shows how to build reports from wizards and queries, highlight important data with conditional formatting, and automate reporting processes with macros.

Type: Streaming Resource

Access 2010: Queries

In this course, author Adam Wilbert illustrates how to create and leverage real-world queries and turn raw data into usable information. The course covers setting up queries, performing calculations, using the built-in Access functions to further refine query results, and identifying top performers or areas for improvement based on a range of criteria.

Type: Streaming Resource

Access 2010: Real-World Projects

In Access 2010: Real-World Projects, author Gini Courter uses real-world examples to explore Access's database creation and management features. Gini shows how to create professionally formatted forms and reports and make ugly databases a thing of the past using Office themes. Creating a database in Access is even easier with built-in navigation templates and reusable Application Parts. Gini also reviews how to save reports as PDFs for easy distribution and how to highlight important data. Exercise files accompany the course.

Type: Streaming Resource

Access 2010: Shortcuts

In Access 2010 Power Shortcuts, Access expert Alicia Katz Pollock shares hundreds of tips and shortcuts to vastly increase efficiency and get the full power out of Access 2010. The course includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Exercise files accompany the course.

Type: Streaming Resource

Access 2013 Essential Training

Join author and database expert Adam Wilbert on a tour of the essential features of Microsoft Access 2013 and discover how to build a database and store your data more efficiently. First, Adam explains the concepts behind relational databases, before moving onto building tables—the foundation of any database. He then shows how to define the relationships between tables and use queries to find and filter data. The course also shows how to apply rules and validation to minimize data entry errors; build an interface for the database from forms, complete with interactive buttons and combo boxes; create reports for printing and sharing; and automate these tasks and many others with macros.

Type: Streaming Resource

Access 2013: Forms and Reports

Make the information in your Access database more transparent and easier to navigate with forms and reports. This course demonstrates how you can use forms and reports to control and organize the display of your data, as well as gather parameters for queries. Author 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 the 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 together and print your results, and introduces unique ways to save time filling out paperwork and generating form letters.

Type: Streaming Resource

Access 2013: Queries

Get more out of your Access database than just the data you put into it, using queries—tools that help you translate complex raw data into information you can use to make better decisions. Join Adam Wilbert, as he explains how to create real-world queries to filter and sort data, perform calculations, and 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, and increase accuracy and consistency in your database using program flow functions.

Type: Streaming Resource

Access 2013: Tips & Tricks

Your tables are built, your relationships are defined, your queries and reports are ready to run. But is your Access database really ready for users? With these power tips, you can create a better user experience for your database and transform it into a fast, efficient, and even fun place to work. Adam Wilbert will show you how to remove typical Access interface elements (like the Welcome screen) for a better start-up 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, filter long lists with cascading combo boxes, and build in contextual help and keyboard shortcuts that your power users will thank you for. Adam also shows how to package the database for users who don't have Microsoft Access installed.

Type: Streaming Resource

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.


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.

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.

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.

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.

Type: Streaming Resource



Pages