Laserfiche WebLink
encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features <br />separate database professionals from the casual database users or occasional designers. <br />Acquired Skills <br />Customize a form layout to improve usability and efficiency of data entry. <br />Share data across applications. <br />Use macros to improve user interface design. <br />Use VBA to enhance tasks. <br />Organize data into appropriate tables to ensure data dependency and minimize redundancy. <br />Lock down and prepare a database for distribution to multiple users. <br />Create and modify a database switchboard and set the startup options. <br />Access 2019 - Part 1 <br />Description <br />Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in <br />some way by the need to manage data. A relational database application such as Microsoft® Office Access® can <br />help you and your organization with this task. <br />Acquired Skills <br />Navigate within the Access application environment, create a simple database, and customize Access configuration <br />options. <br />Organize and manage data stored within Access tables. <br />Use queries to join, sort, and filter data from different tables. <br />Use forms to make it easier to view, access, and input data. <br />Create and format custom reports. <br />Access 2019 - Part 2 <br />Description <br />In this course, you will expand your knowledge of relational database design; promote quality input from users; <br />improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, <br />and reports. Extending your knowledge of Access will result in a robust, functional database for your users. <br />Acquired Skills <br />Provide input validation features to promote the entry of quality data into a database. <br />Organize a database for efficiency and performance, and to maintain data integrity. <br />Improve the usability of Access tables. <br />Create advanced queries to join and summarize data. <br />Use advanced formatting and controls to improve form presentation. <br />Use advanced formatting and calculated fields to improve reports. <br />Access for Office 365 - Part 1 <br />Description <br />In this introductory course, you will discover the capabilities of Microsoft® Access®, a relational database <br />application that can help you and your organization manage your complex data. <br />Acquired Skills <br />Navigate within the Access application environment, create a simple database, and customize Access configuration <br />options. <br />Organize and manage data stored within Access tables. <br />Use queries to join, sort, and filter data from different tables. <br />Use forms to make it easier to view, access, and input data. <br />Create and format custom reports. <br />Access for Office 365 - Part 2 <br />Description <br />you will expand your knowledge of relational database design; promote quality input from users; improve database <br />efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. <br />Extending your knowledge of Access will result in a robust, functional database for your users <br />Acquired Skills <br />