Microsoft Access 2019/2021: Advanced

Learn advanced Access features

Description

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 separate database professionals from casual database users or occasional designers. This is the third part of a three-course series that covers the skills needed to perform database design and development.

Course Outline

Lesson 1: Importing and Exporting Table Data
  • Import and Link Data
  • Export Data
  • Create a Mail Merge
Lesson 2: Using Queries to Manage Data
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
Lesson 3: Creating Complex Reports and Forms
  • Create Subreports
  • Create a Navigation Form
  • Show Details in Subforms and Popup Forms
Lesson 4: Creating Access Macros
  • Create a Standalone Macro to Automate Repetitive Tasks
  • Create a Macro to Program a User Interface Component
  • Restrict Records by Using a Condition
  • Create a Data Macro
Lesson 5: Using VBA to Extend Database Capabilities
  • Getting Started with VBA
  • Using VBA with Form Controls
Lesson 6: Managing a Database
  • Back Up a Database
  • Manage Performance Issues
  • Document a Database
Lesson 7: Distributing and Securing a Database
  • Split a Database for Multiple-User Access
  • Implement Security
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

Prerequisites

Prior Course Recommendation:

  • Microsoft Access for Office 2019/2021: Part 1
  • Microsoft Access for Office 2019/2021: Part 2

Similar courses

Using Data Analysis Expressions to solve common business problems in Power BI

More Information

Start down the road to creating advanced workbooks and worksheets to help deepen understanding of organizational intelligence

More Information

Put the full power of Excel right at your fingertips: collaborate, automate, and use conditional logic to construct and apply elaborate formulas and functions

More Information

Provides a foundation for Excel knowledge and skills

More Information

Builds upon the foundational knowledge presented in the Microsoft Outlook for Office 365/2019: Part 1 course and will help you customize a communication system well-suited to your work style

More Information

Expand basic database management skills

More Information

Tackle more advanced features of Word

More Information

Analyze business data, visualize insights, and share those insights across the enterprise

More Information

This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment

More Information

Use Microsoft Project effectively and efficiently in a real-world environment.

More Information

Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data

More Information

Use the advanced PivotTable functionality in Excel to analyze your raw data

More Information

Create presentations that not only stand out from the crowd, but also don't consume all of your available time

More Information

How do you grab and maintain an audience's focus when you're asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® PowerPoint® can help you do.

More Information

SharePoint provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location

More Information

In this course, you will perform advanced data visualization and data blending with Tableau.

More Information

Includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.

More Information

You will learn fundamental Word skills

More Information

Use Outlook to compose and handle your email communications and to manage your calendar, contacts, and tasks.

More Information

Identify effective time-management strategies, including defining personal and professional goals, establishing priorities, and identifying the tasks that will be critical to achieving those goals. You will create a personal time-management action plan.

More Information

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.

More Information

This course is for individuals who are new to Adobe Acrobat Pro DC, but need to create and share PDF files and PDF portfolios.

More Information

The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes.

More Information

Students will benefit from this course by understanding the foundational principles of project management, improving their project management skills, utilizing tools and techniques to effectively manage projects, gaining a common project management language to improve communication, and learning frameworks to identify, manage, and mitigate risk. Concepts learned in this course are immediately applicable to ongoing projects.

More Information

Work with formatting options such as styles and section breaks to automate and troubleshoot document content including table of contents, list of figures, and more.

More Information

Course Objectives: In this course, you will use Microsoft Teams to communicate and collaborate with your colleagues. You will: Send messages to colleagues using Teams. Call and meet with people in Teams. Lead a meeting. Configure your Teams environment. Share files and app content. Create and configure Teams.

More Information

Course Objectives: In this course, you will use a typical SharePoint team site to work collaboratively with other team members. You will: Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site.

More Information

Upon successful completion of this course, students will be able to plan for change, learn to communicate change, manage the impact of change on your team members and successfully implement changes at work.

More Information

The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Tableau® software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports.

More Information

In this course, you will obtain knowledge and skills to become a top-notch team performer.

More Information

Upon successful completion, students will have gained the necessary skills for improved team efficiency, enhanced professional relationships, and more effective engagement.

More Information

The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.

More Information

In this course, you will use generative AI to assist you as you work with spreadsheets.

More Information

In this course, you will develop and deploy VBA modules to solve business problems.

More Information

This course provides comprehensive training on creating and modifying forms using Adobe Acrobat. Participants will learn to design, customize, and optimize interactive forms, both automatically and manually. The course covers essential techniques such as adding various form fields, working with actions, adjusting tab order, and implementing calculations.

More Information

This course introduces working with shared documents in the familiar Office 365 online apps—Word, PowerPoint®, and Excel®—as an alternative to installing the Microsoft® Office desktop applications. This course also introduces several productivity apps including Yammer™, Planner, and Delve® that can be used in combination by teams for communication and collaboration.

More Information

Learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues.

More Information

If you are someone with existing SQL or SQL Server knowledge (or someone highly versed in different data repositories), this is the Power BI course for you. This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.

More Information

In this course, you will use generative AI tools to help you develop business presentations.

More Information

Upon successful completion of this course, you will be able to use Adobe Illustrator CC to create illustrations that include graphics and text, draw complex illustrations, enhance artwork by using painting tools, customize colors and swatches, format type, enhance the appearance of artwork, prepare content for deployment, set up project requirements and prepare graphics for the web.

More Information

In this course, you will use Adobe® InDesign® to create and deliver professional looking printed and interactive documents. You will also learn advanced InDesign techniques to enhance the look and functionality of your documents.

More Information

This two-day course will prepare you to use the most common basic and advanced features of Adobe Photoshop.

More Information

In this course, you will use generative AI tools to help you develop text and images that you can use in your word processor or desktop publishing application.

More Information

This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft® Excel® or SQL Server® reporting services to perform numerical or general data analysis. This course is also designed for professionals who want to pursue the Microsoft Power BI Data Analyst (Exam PL-300) certification.

More Information

This course is intended for power users and IT professionals who are tasked with working within the SharePoint 2016 environment and conduct site collection and site administration. This course is for an on-premise SharePoint environment.

More Information

Business runs by the numbers. This course is designed to help explain the relations among numbers and how they affect decision-making. Accounting Essentials is about understanding the impact of financial data on day-to-day operations. Understanding more about financial decision making should enable you to communicate effectively throughout your organization and this course will introduce you to how financial data is collected, allocated and used within your organization.

More Information