Inhalt: Discover how to manage data entry and reporting tasks more efficiently with Access 2007. Author Adam Wilbert presents lessons 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. Umfang: 03:37:23.00
Inhalt: In Access 2007: Queries in Depth, 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. Exercise files are included with the course. Umfang: 02:08:44.00
Inhalt: 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. Umfang: 03:07:47.00
Inhalt: 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. Umfang: 03:02:09.00
Inhalt: 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. Umfang: 05:04:35.00
Inhalt: 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. Umfang: 04:58:01.00
Inhalt: 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. Umfang: 04:23:53.00
Inhalt: 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. Umfang: 02:50:22.00
Inhalt: 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. Umfang: 06:45:21.00
Inhalt: 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. Umfang: 02:40:43.00
Inhalt: 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. Umfang: 04:59:00.00
Inhalt: 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. Umfang: 04:10:42.00
Inhalt: 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. Umfang: 01:47:08.00
Inhalt: Learn how to wrangle your data and gain deeper insights by leveraging the power of Microsoft Access 2019. In this course, Access expert Adam Wilbert shows how to use Access to build databases that help you store and retrieve your data more efficiently. Adam begins by going over the concepts behind relational databases. He then discusses how to build tables-the foundation of any database-as well as how to define the relationships between tables and use queries to find and filter data. He also steps through how to build an interface for the database from forms, complete with combo boxes; create reports for printing and sharing; and take steps to maintain your database. Umfang: 03:40:27.00
Inhalt: Learn how to best use 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 discusses how to leverage controls such as buttons and links. He combines these ideas in a chapter that shows how to build an application-like framework for getting around a database. He then dives into reports, showing how to create efficient and readable layouts, build a report from a query, and use conditional formatting rules to highlight key takeaways from the data. Finally, Adam demonstrates how to link forms and reports as he steps through how to create a profit summary report. Umfang: 04:20:39.00
Inhalt: Macros are a great tool for developers who want to add functionality and interactivity to Access databases, without writing any additional code. With macros, you can take a list of time-consuming processes, such as launching a series of reports at startup, and run them automatically. This course covers how to build macros from the Access Actions catalog, adjust the execution and flow of macros with conditional logic and variables, and string together actions in multi-step sequences. Instructor Adam Wilbert also dives into macro security and show how to debug macros, gracefully handle noncritical errors, and leverage data macros to perform actions-such as logging and validation-when table data is changed. Umfang: 01:09:53.00
Inhalt: Learn how to find and translate complex raw data into information you can use to make better decisions. 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. Umfang: 03:56:10.00
Inhalt: Create a better experience for your Access users. This course covers tips and techniques that can help Access developers transform a boring database into a fast, efficient, and even fun environment. Access expert Adam Wilbert shows how to remove typical Access interface elements for a better start-up experience, as well as how to 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. Umfang: 02:29:09.00
Inhalt: Learn how to build Access databases to store and retrieve your data more efficiently. Access expert Adam Wilbert explains the concepts behind relational databases, before moving onto building tables-the foundation of any database. He then demonstrates how to define the relationships between tables and use queries to find and filter data. This 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; create reports for printing and sharing; and take steps to maintain the database you created. Umfang: 03:51:12.00
Inhalt: Learn to create and manage data, maps, and analytical models with ArcGIS. Author Adam Wilbert shows how to get around maps and start adding your own data and importing data from existing databases. He demonstrates how to select and edit individual map elements, and connect to advanced geospatial data sources. He explains the finer points of working with vector vs. raster data, and then shows how to style your map so it's easy for others to interpret, including finishing touches such as a legend, scale bar, and annotations. Plus, learn how to use ModelBuilder to sequence workflows and share them with the rest of your organization. Umfang: 05:31:23.00
Inhalt: Get data-mapping and geoprocessing power in a new, more intuitive work environment with ArcGIS Pro. ArcGIS Pro Essential Training shows how to use the new ribbon-based interface and editing environment in ArcGIS to accomplish common 2D and 3D mapping tasks. Learn to create project-centered files that gather local and online resources and geodatabases together into a single location-making management and creation of your maps that much easier. Create multiple 2D map views and 3D scenes in a single project and save project templates to reuse your layouts. Instructor Adam Wilbert also covers manipulating data using the included ArcGIS geoprocessing tools, adding styles and symbols, and sharing the final maps via ArcGIS Online or as standalone packages. Umfang: 04:25:37.00
Inhalt: Microsoft Azure Data Studio is a lightweight, cross-platform front end for working with SQL Server instances. It brings the power of databases to a wider audience. With Azure Data Studio, Windows, macOS, and Linux users have access to a robust GUI for managing and developing databases on SQL Server and in the cloud on Azure SQL Database. This course introduces the key features and workflows of Azure Data Studio. This includes the integrated T-SQL editor, server connection manager, built-in terminal, version control support, and more. Instructor Adam Wilbert shows you how to connect to a database server, create and edit data tables, and use the code editor to output data for Excel. Plus, learn how to work with sidebars and insight widgets and customize Azure Data Studio to meet your organization's needs. Umfang: 01:49:56.00
Inhalt: Ongoing, regular administration is critical to the security and performance of databases such as Oracle and SQL Server. It's also a key topic of the Microsoft Technology Associate (MTA) Exam. Whether you're studying to pass the test or simply to keep your admin skills up to date, this course will cover the most current techniques and best practices for administering a database. Adam Wilbert covers the core concepts, including securing the server with user authentication and roles, assigning object-level permissions, and performing a backup and restore. Along the way, he'll provide tips for working with SQL Server Management Studio and some challenges to help you practice what you've learned. Note: This course will also prepare certification candidates for the "Administer a database" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals. Umfang: 01:14:34.00
Inhalt: Ongoing, regular administration is critical to the security and performance of databases such as SQL Server. In this course-the fourth installment in the Database Foundations series-explore vital techniques and best practices for administering a database. Instructor Adam Wilbert covers a variety of core concepts, including how to secure a server with user authentication and roles, protect your database by setting up permissions for authorized user accounts, and perform a backup and restore. Adam also offers expert tips for ensuring that a database remains available, even through hardware maintenance, upgrades, and failures. Along the way, he provides tips for working effectively with both SQL Server and PostgreSQL. Umfang: 02:07:43
Inhalt: While learning about the individual components of a software development stack like databases, programming languages, and interfaces is important, combining multiple technologies that each contribute a piece to the whole is where all the knowledge really comes together. In this fifth and final course of his Database Foundations series, database expert Adam Wilbert explores the role of relational databases in the larger landscape of application development. He examines the architecture of modern apps and how databases integrate with presentation and logic, and how all these building blocks of software development fit together. To do so, Adam shows two different approaches of how to integrate a database with a web server and details the components that allow you to build custom interfaces for your data, in order to provide end users access to your databases from any web browser. Umfang: 01:49:00
Programm Findus Internet-OPAC findus.pl V20.235/8 auf Server windhund2.findus-internet-opac.de,
letztes Datenbankupdate: 08.05.2024, 10:13 Uhr. 728 Zugriffe im Mai 2024. Insgesamt 510.958 Zugriffe seit Januar 2009
Mobil - Impressum - Datenschutz - CO2-Neutral