Access 2013 Expert 1 Day Workshop in Miami, FL on June 21st, 2024

Access 2013 Expert 1 Day Workshop in Miami, FL on June 21st, 2024

Offers: Group of 5 - 10 people 10% Discount, Group of 11 - 20 people 15% Discount

By Academy for Pros

Date and time

Friday, June 21 · 9am - 5pm EDT

Location

For venue details reach us at info@academyforpros.com, PH: +1 469 666 9332

Miami Miami, FL

Refund Policy

Contact the organizer to request a refund.

Agenda

Module One: Customizing Apps (I)


● Creating a Custom App from Scratch ● Adding a Template Table Adding a Blank Table ● Importing Access 2010 Tables ● Module One: Review Questions

Module Two: Customizing Apps (II)


● About Custom Actions ● Adding a Custom Action ● Editing a Custom Action ● Deleting a Custom Action ● Module Two: Review Questions

Module Three: Customizing Apps (III)


● About User Interface Macros ● Creating an Embedded Macro ● Creating a Standalone macro ● Saving Your App as a Package ● Module Three: Review Questions

Module Four: Working with Validation Rules and Messages


● Creating a Field Validation Rule ● Creating a Field Validation Message ● Creating a Validation Rule ● Creating a Validation Message ● Testing Validation Rules ● Module Four: Review Questions

Module Five: Working with Macros


● Creating a Before Change Event ● Working with the Macro Tools Design Tab ● Working with the Action Catalog ● Creating an After Event ● Creating a Named Macro ● Renaming or Deleting Macros ● Module ...

Module Six: Advanced Query Tasks


● Using Query Design View ● Creating Ad Hoc Relationships ● Creating an Update Query ● Creating a Parameter Query ● Comparing Two Tables by Using a Join ● Module Six: Review Questions

Module Seven: Designing Forms


● Common Formatting Tasks ● Using Themes ● Working with Controls ● Adding Header and Footer Elements ● Arranging Form Elements ● Formatting Forms ● Module Seven: Review Questions

Module Eight: Advanced Reporting Tasks


● Using Report Sections ● Using Conditional Formatting ● Grouping and Sorting Data ● Adding Calculated Controls ● Creating Labels ● Module Eight: Review questions

Module Nine: Advanced Database Tools


● Using the Database Documenter ● Analyzing Table Performance ● Analyzing Database Performance ● Repairing a Database ● Compacting a Database ● Module Nine: Review Questions

Module Ten: Working with the Access Environment


● Working with Database Properties ● Encrypting a Database with a Password ● Using Save Object As ● Setting Access Options ● Module Ten: Review Questions

Module Eleven: Wrapping Up


● Words from the Wise ● Review of Parking Lot

About this event

  • 8 hours

Certificate: Course Completion Certificate

Language: English

Duration: 1 Day

Credits: 8

Refreshments: Snacks, Beverages and Lunch included in a classroom session

Course Delivery: Classroom

Course Overview:

This workshop is designed to teach you a deeper understanding of Access 2013 in a practical way. This workshop is designed for the advanced users of Access 2013. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

This workshop is meant to provide a safe learning environment where they can practice and learn Access 2013 Expert functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

Target Audience:

Anybody who is interested in learning Access 2013 Expert Skills

Learning Objectives:

After completing this course, Individuals will be able to demonstrate their understanding of:

  • Customizing Apps
  • Working with Validation Rules and Messages
  • Working with Macros
  • Advanced Query Tasks
  • Designing Forms
  • Advanced Reporting Tasks
  • Advanced Database Tools
  • Working with the Access Environment

Prerequisites:

None

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

eBook download and activation instructions

Business Case Writing Training: Business strategy execution depends upon developing and implementing the best solution. Success however, relies upon basing the solution on the right requirements, drawn from a sound and robust Business Case.This one day program will introduce participants to the principles of developing an effective Business Case, within the context of an interactive course driven by a case study.This workshop will provide participants with a working knowledge of the principles of writing an effective, comprehensive and compelling Business Case.The course is driven by participation in a case study, promoting immediate workplace transference.

Business Succession Planning Workshop: Business succession planning is all about being prepared. The loss of valuable leadership can cripple even the strongest of companies. Succession planning is an essential component to the survival and growth of any business. Whether it is grooming employees to become leaders, or preparing for an employee”s retirement your participants will identify common obstacles and how to overcome them.

Our Business Succession Planning workshop will show you the differences between succession planning and mere replacement planning. How you prepare people to take on leadership responsibilities is just as important as hiring the right person for the job. Every company should have a form of succession planning in its portfolio.

Project Management Basics Training: With this Course you will gain a basic understanding of Project Management based on the Guide to the Project Management Body of Knowledge® – 5th Edition. The Course covers information on project Management theory, Principles, techniques, and methods.

During the Course, exercises are made based upon a case study. The case study may be one of three pre-defined case studies or a customized case study from the participant’s organization (see below: customization).

Change Management Foundation Training: Do you understand the psychology, the mechanisms and the options for helping staff cope with change issues and of establishing new ways of working so that change is effective?

Global competition brings change. Mergers and acquisitions bring change. New governmental statutes and regulatory directives bring change.

As the developed world moves from a production-based, to a service-based economy, you need to know the characteristics of different organizational structures, how they work and the issues that you will face as you try to help them change.

The Change Management Foundation course deals with the theories of how change impacts on and is affected by the Individual, the Team, the Organization, and the Change Leader.

This course will provide you with underpinning knowledge of the behavioral associated with managing change in organization life, and of many key models and tools used by practitioners to address these issues effectively.

Based on the acclaimed book, “The Effective Change Manager’s Handbook ” this course provide the opportunity to attain certification for Change Management Foundation issued by APMG-International.

Internet Marketing Fundamentals Training: Marketing has changed dramatically over the last decade. Marketing is all about communicating, and the Internet has completely changed the way people communicate. The Internet is a marketer”s dream come true, especially with Social Media, as you have a low cost marketing tool that can reach a large audience.

Internet Marketing Fundamentals will provide your participants with a great set of skills to market your business online. Content is the king of Internet marketing, and your participants will need to know how to utilize your great content. If you want your business to grow then your participants need to understand Internet Marketing Fundamentals.

Marketing Essentials Workhop: This Training, ‘Marketing Essentials’ cover the basics of marketing and are intended not only for people who are new to a marketing role, but just about anybody in the organisation. A basic understanding of the subject is particularly valuable to people in management, selling and customer service roles.

Training course contents:

Effective marketing is vital to ensure the survival and growth of any business. It does not matter whether the business is large or small or what products or services the business supplies, the truth is that effective marketing cannot be ignored and is essential for any successful organisation.

Elements of Risk Management Workshop: The mission of every organization is affected by today’s global economy and the digital era. Organizations are critically dependent on information technology (IT) to better support their business Goals. Risk Management plays a critical role in protecting an organization’s information assets, and its mission therein, from IT-related Risk. An effective Risk Management Process is an important component of a successful IT security program. The principal goal of an organization’s Risk Management Process should be to protect the organization and its ability to perform their mission, not just its IT assets. Therefore, the Risk Management Process should not be treated primarily as a technical function carried out by the IT experts who operate and manage the IT system, but as an essential Management function of the organization.

Risk is the net negative impact of the exercise of a vulnerability, considering both the probability and the impact of occurrence. Risk Management is the Process of identifying Risk, assessing Risk, and taking steps to reduce Risk to an acceptable level. This Course provides an overview into the specific criteria, steps and actions necessary to implement and sustain a comprehensive Information Risk Management program.

Business Presentations Workshop: These business presentations training will provide you with the skills and knowledge required to deliver effective and persuasive business presentations that get results. It will help you to present in a style that changes the way people think about the topics they present to them while leaving the audience with key actions to take away.

You will be guided on how to prepare and deliver the message with impact and given the tools and techniques to ensure that their audience feel engaged and influenced by your delivery.

Business Ethics Workshop: A company”s ethics will determine its reputation. Good business ethics are essential for the long-term success of an organization. Implementing an ethical program will foster a successful company culture and increase profitability. Developing a Business Ethics program takes time and effort, but doing so will do more than improve business, it will change lives.

A company”s ethics will have an influence on all levels of business. It will influence all who interact with the company including customers, employees, suppliers, competitors, etc. All of these groups will have an effect on the way a company”s ethics are developed. It is a two-way street; the influence goes both ways, which makes understanding ethics a very important part of doing business today. Ethics is very important, as news can now spread faster and farther than ever before.

Tickets

Frequently asked questions

What Does Academyforpros provide me on the day of the course?

We provide Course Materials, Lunch, Beverages and Course Completion Certificate.

If I cancel my Enrollment, how can I claim my Refund?

You can request a refund by sending an email to info@academyforpros.com and within 7-14 working days you get your money back.

How do I enroll in a course?

You can reach us at info@academyforpros.com or enroll through our website.

Is the course available online or in-person?

We host the training through both the platform, Online and Classroom. The virtual training option can be chosen by busy professionals.

What is the duration of the course?

The duration of the training is 8 hours. The training will run from 9 AM to 5 PM.

Do you provide group discount?

Yes, we do provide great discount for the group registration. To enquire, reach us at info@academyforpros.com

Will I receive a certificate upon completion of the training?

Once you complete the training, you will receive a globally recognized Course Completion Certificate.

Can I switch my registration to different course if required

Yes. You can switch your registration to a different course with a week prior notice.

Are your instructors are qualified and certified?

Our subject matter experts are from relevant industries and are certified.

How many credits will I be eligible for?

You will be credited with 8 PDUs on completion of this training.

Organized by

We deliver training solutions to Corporate, Government Agencies, Public sectors, Multinational organizations and Private Individuals. Our Primary focus is to train in a wide range of areas from IT Technical, Personal Development, Human Resources and Management Courses to Project, Program and IT Service Management.

We have most experienced trainers in the Industry. Our Trainers are highly skilled in their subject areas and are uniquely positioned to provide participants with deep industry experience. They are motivated to transfer knowledge through practical support post and pre-training to provide participants with additional support outside the classroom.

Early bird discount