14 Microsoft Access courses delivered Live Online

MICROSOFT ACCESS TRAINING COURSE DESCRIPTION A hands on course providing a solid grounding in Microsoft Access. WHAT WILL YOU LEARN * Use and customise the Microsoft Access environment. * Select, use and customise queries. * Define tables. * Design forms and reports. * Recognise the use of macros. MICROSOFT ACCESS TRAINING COURSE DETAILS * Who will benefit: Anyone wishing to work with Microsoft Access. * Prerequisites: Database fundamentals * Duration 3 days MICROSOFT ACCESS TRAINING COURSE CONTENTS * Introducing databases Flat file databases, Relational databases, the objects defined in an Access database, planning a simple relational database. * Open Access and create a database The database wizards, tables, creating and amending tables, using field properties to improve the quality of data entry and system performance, the primary key. * Working in datasheet view View, add, modify and delete records, find records. Advantages and disadvantages of entering data directly into a table. * Queries Sort and select records form a single table, advantages and disadvantages of entering data via a query, define simple calculated expressions, use 'Totals' queries. * Forms Use the form wizards, basic editing of objects created using the form wizards, Data-entry in form view. * Reports Use the report wizard, basic editing of objects created using the report wizard, print reports. * The multi table environment Plan and create a related table, define a one-to-many relationship, write multi-table queries and use the 'AutoLookup' feature, use the form wizard to create a subform and carry out data-entry in a main/subform, print and amend reports, use the report wizard to create reports based on multi-table. * Relationships Working with one-to-one and one-to-many relationships, recognising and handling many-to-many relationships, referential integrity. * Select queries Select queries based on related tables, parameter queries, Crosstab, find unmatched queries and Find Duplicate, the implications of the Join properties in a relational query, conditional expressions, and working with the expression builder. * Action queries Make table queries, append queries, update queries, delete queries. Customising forms. Using the Toolbox, calculated controls, Combo and List boxes, query by form, working with form and control properties, domain aggregate functions. * Reports Report and control properties, customising sorting and grouping, calculated controls on reports, Sub-reports, editing and altering a report's source. * Macros Introduction to macros.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students looking to establish a foundational understanding of Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. Overview In this course, you will create and manage an Access database. You will: Navigate within the Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports. Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft© Access© can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access. Microsoft© Access© for Office 365?: Part 1 (this course): Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. Microsoft© Access© for Office 365?: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports. Microsoft© Access© for Office 365?: Part 3 : Focuses on managing the database and supporting complex database designs, including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database. This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. LESSON 1: WORKING WITH AN ACCESS DATABASE * Topic A: Launch Access and Open a Database * Topic B: Use Tables to Store Data * Topic C: Use Queries to Combine, Find, Filter, and Sort Data * Topic D: Use Forms to View, Add, and Update Data * Topic E: Use Reports to Present Data * Topic F: Get Help and Configure Options in Access LESSON 2: CREATING TABLES * Topic A: Plan an Access Database * Topic B: Start a New Access Database * Topic C: Create a New Table * Topic D: Establish Table Relationships LESSON 3: CREATING QUERIES * Topic A: Create Basic Queries * Topic B: Add Calculated Columns in a Query * Topic C: Sort and Filter Data in a Query LESSON 4: CREATING FORMS * Topic A: Start a New Form * Topic B: Enhance a Form * Lesson 5: Creating Reports * Topic A: Start a New Report * Topic B: Enhance Report Layout ADDITIONAL COURSE DETAILS: Nexus Humans Microsoft Access for Office 365: Part 1 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft Access for Office 365: Part 1 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Microsoft 365. Overview In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports. Your training and experience using Microsoft© Access© has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access.Microsoft© Access© for Office 365?: Part 1 : Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.Microsoft© Access© for Office 365?: Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.Microsoft© Access© for Office 365?: Part 3 : Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. LESSON 1: PROMOTING QUALITY DATA INPUT * Topic A: Restrict Data Input Through Field Validation * Topic B: Restrict Data Input Through Forms and Record Validation LESSON 2: IMPROVING EFFICIENCY AND DATA INTEGRITY * Topic A: Data Normalization * Topic B: Associate Unrelated Tables * Topic C: Enforce Referential Integrity LESSON 3: IMPROVING TABLE USABILITY * Topic A: Create Lookups Within a Table * Topic B: Work with Subdatasheets LESSON 4: CREATING ADVANCED QUERIES * Topic A: Create Query Joins * Topic B: Create Subqueries * Topic C: Summarize Data LESSON 5: IMPROVING FORM PRESENTATION * Topic A: Apply Conditional Formatting * Topic B: Create Tab Pages with Subforms and Other Controls LESSON 6: CREATING ADVANCED REPORTS * Topic A: Apply Advanced Formatting to a Report * Topic B: Add a Calculated Field to a Report * Topic C: Control Pagination and Print Quality * Topic D: Add a Chart to a Report

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students looking to establish a foundational understanding of Microsoft Access for Office 365, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. Overview In this course, you will create and manage an Access database. You will: Navigate within the Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports. In this introductory course, you will discover the capabilities of Microsoft© Access©, a relational database application that can help you and your organization manage your complex data. WORKING WITH AN ACCESS DATABASE * Topic A: Launch Access and Open a Database * Topic B: Use Tables to Store Data * Topic C: Use Queries to Combine, Find, Filter, and Sort Data * Topic D: Use Forms to View, Add, and Update Data * Topic E: Use Reports to Present Data * Topic F: Get Help and Configure Options in Microsoft Access CREATING TABLES * Topic A: Plan an Access Database * Topic B: Start a New Access Database * Topic C: Create a New Table * Topic D: Establish Table Relationships CREATING QUERIES * Topic A: Create Basic Queries * Topic B: Add Calculated Columns in a Query * Topic C: Sort and Filter Data in a Query CREATING FORMS * Topic A: Start a New Form * Topic B: Enhance a Form CREATING REPORTS * Topic A: Start a New Report * Topic B: Enhance Report Layout PROMOTING QUALITY DATA INPUT * Topic A: Restrict Data Input through Field Validation * Topic B: Restrict Data Input through Forms and Record Validation IMPROVING EFFICIENCY AND DATA INTEGRITY * Topic A: Data Normalization * Topic B: Associate Unrelated Tables * Topic C: Enforce Referential Integrity ADDITIONAL COURSE DETAILS: Nexus Humans Microsoft Access for Office 365 (Desktop or Online) - Part 1 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft Access for Office 365 (Desktop or Online) - Part 1 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for Students taking this course are database administrators or prospective database administrators who have experience working with Access for Microsoft 365 and need to learn advanced skills. Overview In this course, you will manage an Access database and add complex database features to improve its usability, efficiency, performance, and security. You will: Share data across applications. Use action, unmatched, and duplicate queries to manage data. Create complex reports and forms. Use macros to improve user interface design. Use VBA to extend database capabilities. Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting. Implement security strategies and distribute a database to multiple users. You've covered many of the basic functions of Microsoft© Access©, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separates database professionals from the casual database users or occasional designers.This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access.Microsoft© Access© for Office 365?: Part 1 : Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.Microsoft© Access© for Office 365?: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.Microsoft© Access© for Office 365?: Part 3 (this course): Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. LESSON 1: IMPORTING AND EXPORTING TABLE DATA * Topic A: Import and Link Data * Topic B: Export Data * Topic C: Create a Mail Merge LESSON 2: USING QUERIES TO MANAGE DATA * Topic A: Create Action Queries * Topic B: Create Unmatched and Duplicate Queries LESSON 3: CREATING COMPLEX REPORTS AND FORMS * Topic A: Create Subreports * Topic B: Create a Navigation Form * Topic C: Show Details in Subforms and Popup Forms LESSON 4: CREATING ACCESS MACROS * Topic A: Create a Standalone Macro to Automate Repetitive Tasks * Topic B: Create a Macro to Program a User Interface Component * Topic C: Filter Records by Using a Condition * Topic D: Create a Data Macro LESSON 5: USING VBA TO EXTEND DATABASE CAPABILITIES * Topic A: Introduction to VBA * Topic B: Use VBA with Form Controls LESSON 6: MANAGING A DATABASE * Topic A: Back Up a Database * Topic B: Manage Performance Issues * Topic C: Document a Database LESSON 7: DISTRIBUTING AND SECURING A DATABASE * Topic A: Split a Database for Multiple-User Access * Topic B: Implement Security * Topic C: Convert an Access Database to an ACCDE File * Topic D: Package a Database with a Digital Signature

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Office 365. Overview In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification. IMPROVING TABLE USABILITY * Topic A: Create Lookups Within a Table * Topic B: Work with Subdatasheets CREATING ADVANCED QUERIES * Topic A: Create Query Joins * Topic B: Create Subqueries * Topic C: Summarize Data * IMPROVING FORM PRESENTATION * Topic A: Apply Conditional Formatting * Topic B: Create Tab Pages with Subforms and Other Controls CREATING ADVANCED REPORTS * Topic A: Apply Advanced Formatting to a Report * Topic B: Add a Calculated Field to a Report * Topic C: Control Pagination and Print Quality * Topic D: Add a Chart to a Report * IMPORTING AND EXPORTING TABLE DATA * Topic A: Import and Link Data * Topic B: Export Data * Topic C: Create a Mail Merge USING QUERIES TO MANAGE DATA * Topic A: Create Action Queries * Topic B: Create Unmatched and Duplicate Queries * CREATING COMPLEX REPORTS AND FORMS * Topic A: Create Subreports * Topic B: Create a Navigation Form * Topic C: Show Details in Subforms and Popup Forms CREATING ACCESS MACROS * Topic A: Create a Standalone Macro to Automate Repetitive Tasks * Topic B: Create a Macro to Program a User Interface Component * Topic C: Filter Records by Using a Condition * Topic D: Create a Data Macro USING VBA TO EXTEND DATABASE CAPABILITIES * Topic A: Introduction to VBA * Topic B: Using VBA with Form Controls * MANAGING A DATABASE * Topic A: Back Up a Database * Topic B: Manage Performance Issues * Topic C: Document a Database DISTRIBUTING AND SECURING A DATABASE * Topic A: Split a Database for Multiple-User Access * Topic B: Implement Security * Topic C: Convert an Access Database to an ACCDE File * Topic D: Package a Database with a Digital Signature

DATABASE DESIGN TRAINING COURSE DESCRIPTION Although this course mentions Microsoft Access the same course can be run with a variety of different databases. The duration of the course is dependent on the experience of the delegates. WHAT WILL YOU LEARN * Name and give 3 types of database structure. * Explain the difference between standard SQL and different flavours. * Use SQL statements to query databases. * Use SQL statements to query and define databases. * Describe the principles of relational database design and 3 types of relational joins. * Normalise a given flat file table into relational tables. DATABASE DESIGN TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to be able to design an efficient, watertight database following the best practice of the principles of Relational Database design. * Prerequisites: None. * Duration 3 days DATABASE DESIGN TRAINING COURSE CONTENTS * Database structure and terminology. * Principles of Relational Database Design. * Types of relationship. * Normal Forms. * Practical examples of relational database design. * Hands-on creation of a database. * On paper design a relational database applicable to the delegates work.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS * Topic A: Create a Running Total Field * Topic B: Modify a Running Total Field * Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS * Topic A: Create a Cross-Tab Report * Topic B: Format a Cross-Tab Report * Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS * Topic A: Insert a Subreport * Topic B: Edit a Subreport * Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT * Topic A: Create a Drill-Down * Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING * Topic A: Create a Report Using SQL Queries * Topic B: Summarize Report Data * Topic C: Create Joins Using SQL * Topic D: Create Subqueries * Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS * Topic A: Work with Loops * Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS * Topic A: Create Charts * Topic B: Create a Chart with Drill-Down * Topic C: Create a Top N Chart * Topic D: Create a Cross-Tab Chart * Topic E: Create Charts for Grouped Data * Topic F: Format a Chart * Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY * Topic A: Organize Data Based on a Hierarchy * Topic B: Create a Dynamic Image * Topic C: Create a Report Alert * Topic D: Create a Geographic Map 9 - APPENDIX * Appendix A: Managing Reports * Appendix B: Processing Data on the Server * Appendix C: Detecting and Fixing Problems

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE * Topic A: Explore Crystal Reports * Topic B: Use Crystal Reports Help * Topic C: Customize Report Settings 2 - WORKING WITH REPORTS * Topic A: Create a Report * Topic B: Modify a Report * Topic C: Display Specific Report Data * Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS * Topic A: Create a Formula * Topic B: Edit a Formula * Topic C: Filter Data by Using a Formula * Topic D: Work with Advanced Formulas and Functions * Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS * Topic A: Create a Parameter Field * Topic B: Use a Range Parameter in a Report * Topic C: Create a Prompt 5 - GROUPING REPORT DATA * Topic A: Group Report Data * Topic B: Modify a Group Report * Topic C: Group by Using Parameters * Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT * Topic A: Format a Report * Topic B: Insert Objects in a Report * Topic C: Suppress Report Sections * Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA * Topic A: Create a Report Based on Excel Data * Topic B: Modify a Report Generated from Excel Data * Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA * Topic A: Export Data * Topic B: Create Mailing Labels 9 - APPENDIX * Appendix A: Setting Up and Configuring Data Sources * Appendix B: Using Report Processing Techniques * Appendix C: Using Functions in Formulas

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: * Plan and create a database * Sort and filter records * Use field data types * Work with tables * Create and manage a query * Create and work with forms, and use the form wizard * View, create and print reports 1 ACCESS INTRODUCED * Planning a database * Creating a blank database * Opening an existing database * Security warnings * The navigation pane * Previewing database components * Closing an Access database 2 TABLES INTRODUCED * Viewing and navigating table data * Navigating using keyboard shortcuts * Editing table data * Adding records to tables * Selecting and deleting records * Finding and replacing data * Filtering tables * Summing table data 3 QUERIES INTRODUCED * Opening a query in datasheet view * Opening a query in design view * Adding fields to a query * Sorting query results * Modifying datasheet view * Saving and closing queries 4 FORMS INTRODUCED * Working with form data * Sorting records * Filtering records * Working in design and layout views * Changing object attributes 5 REPORTS INTRODUCED * Opening and viewing reports * Viewing a report in design view * Previewing and printing report data * Creating reports with auto report * Creating reports with the report wizard * Changing field attributes 6 CREATING A NEW DATABASE * Creating database tables * Creating table fields * Selecting field data types 7 TABLE RELATIONSHIPS * Introducing relationships * Establishing table relationships * The one-to-many relationship type * Establishing referential integrity 8 CREATING QUERIES * Streamline query criteria using wildcards * Creating summary queries * Creating queries based on criteria * Running date queries * Formatting field properties * Building queries from multiple tables * Summing in queries 9 CREATING FORMS * Creating a new form * Inserting form fields * Working with the property sheet * The command button wizard * The command button wizard * Programming without typing * Creating forms with embedded sub forms * Creating forms with the sub form wizard * Creating forms with the form wizard 10 CREATING REPORTS * What are report bands? * Managing report controls * Basing reports on multiple tables * Basing reports on queries * Sorting and grouping records