Get Microsoft Access 2013 Certified (MOS) Exam 77-424 from Udemy

What's inside

Learning objectives

Prepare for the microsoft 2013 access 2013 certification exam
Learn how to create a database and work with basic functions
Understand tables and their usage

Work with queries to search for information from existing data
Create forms and work with controls
Generate reports, including customization and branding

Prepare for the microsoft 2013 access 2013 certification exam
Learn how to create a database and work with basic functions
Understand tables and their usage
Work with queries to search for information from existing data
Create forms and work with controls
Generate reports, including customization and branding

Syllabus

This section details out the course agenda and sets the objectives

This lesson is about the course and the instructor bio

This is the course agenda

This sections introduces students to Microsoft Access 2013 Ribbon area

This lesson demonstrates how to work with existing templates and modifying those templates. You will also learn the location of the templates and how to access them.

Download and work with Access online templates

In this lesson, you will learn how to work with various tools on the Ribbon area. You will also get familiar with the Access 2013 Ribbon and its usage

This sections introduces students to working with Microsoft Access 2013 Databases

In this lesson, you will grasp an understanding of various Microsoft Access 2013 options

In this lesson, you will understand the concept of an existing database. You will also open the database and explore various aspects.

Everything you need to know about the table is covered in this lesson such as fields and much more

Create 5 tables in this practice exercise

In this lesson, you will learn how to add a new record to an existing table, and navigating between tables

This sections introduces students to creating a new database from scratch and working with tables

In this lesson, you will learn how to create a new table and rename it

In this lesson, you will learn about different data types in Access 2013. For example, string, integer, and more

There are several data types. In this lesson, you will learn about each data type such as string, integer and others.

In this practice task, the real challenge is to create a calculated filed in your tables while you add data

This sections introduces students to queries in Access 2013

When you want to search for information or fetch information from your data, you need to create a query. In this lesson, you will learn how to create queries using the Query Wizard

In this lesson, you will learn how work with the design view of the query and customize various options

Queries are an important element of Access 2013. You can create query to fetch information from existing data. In this lesson you will learn how to create a new query to find duplicate values

This sections introduces students to Forms in Access 2013

In this lesson, you will learn how to use the forms wizard to create forms for use data input

The lesson demonstrates the working of forms design view and how to work with different controls.

In this lesson, Form Controls are detailed out and learn how to place controls on your Access 2013 forms

Practice Task:

In this practice task, create a form using the Forms Wizard, and then within design view, insert a sample logo of you choice.

You can insert any image.

In this task, create a report and later customize it for branding purposes

This sections introduces students to Reports in Access 2013

Using the Report Wizard, you will learn how to create and generate a report in Access 2013

Placing controls on reports is demonstrated in this lesson

Brand management and report customization is demonstrated in this lesson, You will learn various techniques on how to customize and brand your reports

Create a complete Access 2013 Project

This sections recaps learning concepts

In this lesson, we will recap the course to re-enforce learning concepts

Exam details and information on how to go about registering for the exam

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Taught by ClayDesk, which has a strong reputation for quality online courses

Designed for beginners who want to prepare for the Microsoft Access 2013 certification exam

Covers essential topics such as creating and managing databases, building tables, creating queries, creating forms, and creating reports

Hands-on labs and interactive materials provide practical experience

Requires students to have a fundamental understanding of the Access 2013 environment

Reviews summary

Solid preparatory course

According to students, this course is well received and can be of help in preparing for the MOS certification test. Students remark that the course content is of good quality and that the instructor is helpful.

Instructor is a great help.

"I think it was a good experience to take this course."

The course content was great.

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Get Microsoft Access 2013 Certified (MOS) Exam 77-424 with these activities:

Organize and review course materials

Show steps

Organizing and reviewing course materials can help reinforce learning and improve retention.

Show steps

Gather all course materials, including notes, assignments, and quizzes
Organize the materials into a logical structure
Review the materials regularly to refresh your memory

Read 'Access 2013 Bible' by John Walkenbach

Show steps

This book provides a comprehensive reference and guide to Access 2013, enhancing understanding of key concepts and advanced techniques.

View Excel 2019 Bible on Amazon

Show steps

Acquire a copy of the book
Read through the relevant chapters and sections
Take notes and highlight important concepts

Follow tutorials on creating basic queries

Show steps

Following video tutorials can provide more concrete examples and opportunities to practice creating queries.

Browse courses on Queries

Show steps

Search for online tutorials for basic Access queries
Follow along with the tutorial to create a simple query
Experiment with different query options

Four other activities

Expand to see all activities and additional details

Show all seven activities

Complete practice exercises for table creation

Show steps

Completing practice exercises helps solidify understanding of table creation and reinforces concepts.

Browse courses on Tables

Show steps

Download the practice exercise from the course materials
Create the tables as per the instructions
Add data to the tables

Attend an Access 2013 workshop

Show steps

Attending a workshop can provide hands-on practice, expert guidance, and networking opportunities to enhance learning.

Browse courses on Database Management

Show steps

Search for Access 2013 workshops in your area
Register for a workshop that aligns with your learning needs
Attend the workshop and actively participate in activities

Create a custom report for a specific scenario

Show steps

Creating a custom report provides hands-on experience with report customization and allows for application of learned concepts.

Browse courses on Reports

Show steps

Identify a specific scenario or use case
Design the report layout and structure
Add data and formatting to the report
Preview and refine the report

Develop a sample database application based on course concepts

Show steps

Creating a sample database application provides a comprehensive and practical way to apply the skills and knowledge gained in the course.

Browse courses on Database Applications

Show steps

Define the purpose and scope of the application
Design the database schema and tables
Develop the application's functionality
Test and debug the application
Document the application's design and implementation

Career center

Learners who complete Get Microsoft Access 2013 Certified (MOS) Exam 77-424 will develop knowledge and skills that may be useful to these careers:

Database Designer

Database Designers design and develop databases for businesses and organizations. They work with users to identify needs, design solutions, and implement and test databases. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential database design skills, including creating and managing databases, designing and implementing database schemas, and troubleshooting problems. This course can help you build a foundation for a successful career as a Database Designer.

See salaries and explore the career path for Database Designer

Data Architect

Data Architects design and develop data architectures for businesses and organizations. They work with users to identify needs, design solutions, and implement and test data architectures. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential data architecture skills, including creating and managing databases, designing and implementing data architectures, and troubleshooting problems. This course can help you build a foundation for a successful career as a Data Architect.

See salaries and explore the career path for Data Architect

Data Scientist

Data Scientists use data to identify trends and patterns and make recommendations for businesses and organizations. They work with users to identify needs, design solutions, and implement and test data science solutions. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential data science skills, including creating and managing databases, designing and implementing data science solutions, and troubleshooting problems. This course can help you build a foundation for a successful career as a Data Scientist.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts work with businesses and organizations to improve their processes and systems. They use data analysis and modeling techniques to identify areas for improvement and develop solutions. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential business analysis skills, including creating and using queries to extract data from databases, creating reports to visualize data, and using statistical techniques to analyze data. This course can help you build a foundation for a successful career as a Business Analyst.

See salaries and explore the career path for Business Analyst

Data Analyst

Data Analysts collect, clean, and analyze data to identify trends and patterns. They use this information to make recommendations for businesses and organizations. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential data analysis skills, including creating and using queries to extract data from databases, creating reports to visualize data, and using statistical techniques to analyze data. This course can help you build a foundation for a successful career as a Data Analyst.

See salaries and explore the career path for Data Analyst

Business Intelligence Analyst

Business Intelligence Analysts use data to identify trends and patterns and make recommendations for businesses and organizations. They work with users to identify needs, design solutions, and implement and test business intelligence solutions. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential business intelligence skills, including creating and managing databases, designing and implementing business intelligence solutions, and troubleshooting problems. This course can help you build a foundation for a successful career as a Business Intelligence Analyst.

See salaries and explore the career path for Business Intelligence Analyst

Information Systems Manager

Information Systems Managers plan, implement, and maintain information systems for businesses and organizations. They work with users to identify needs, develop solutions, and ensure that systems are running smoothly. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential information systems management skills, including creating and managing databases, designing and implementing systems, and troubleshooting problems. This course can help you build a foundation for a successful career as an Information Systems Manager.

See salaries and explore the career path for Information Systems Manager

Statistician

Statisticians collect, analyze, and interpret data. They work with users to identify needs, design solutions, and implement and test statistical models. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential statistical skills, including creating and managing databases, designing and implementing statistical models, and troubleshooting problems. This course can help you build a foundation for a successful career as a Statistician.

See salaries and explore the career path for Statistician

Market Researcher

Market Researchers collect, analyze, and interpret data to identify trends and patterns in the market. They work with users to identify needs, design solutions, and implement and test market research studies. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential market research skills, including creating and managing databases, designing and implementing market research studies, and troubleshooting problems. This course can help you build a foundation for a successful career as a Market Researcher.

See salaries and explore the career path for Market Researcher

Database Administrator

Database Administrators design, implement, and maintain databases. They may also be involved in data analysis and security. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential database concepts and skills, including creating and managing databases, building tables, creating queries, creating forms, and creating reports. This course can help you build a foundation for a successful career as a Database Administrator.

See salaries and explore the career path for Database Administrator

Financial Analyst

Financial Analysts use data to identify trends and patterns and make recommendations for businesses and organizations. They work with users to identify needs, design solutions, and implement and test financial models. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential financial analysis skills, including creating and managing databases, designing and implementing financial models, and troubleshooting problems. This course can help you build a foundation for a successful career as a Financial Analyst.

See salaries and explore the career path for Financial Analyst

Actuary

Actuaries use mathematics and statistics to assess risk and uncertainty. They work with users to identify needs, design solutions, and implement and test actuarial models. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential actuarial skills, including creating and managing databases, designing and implementing actuarial models, and troubleshooting problems. This course can help you build a foundation for a successful career as an Actuary.

See salaries and explore the career path for Actuary

Web Developer

Web Developers design, develop, and maintain websites and web applications. They work with users to identify needs, design solutions, and implement and test websites and web applications. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential web development skills, including creating and managing databases, designing and implementing web applications, and troubleshooting problems. This course can help you build a foundation for a successful career as a Web Developer.

See salaries and explore the career path for Web Developer

Computer Programmer

Computer Programmers write and maintain computer code. They work with users to identify needs, design solutions, and implement and test code. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential computer programming skills, including creating and managing databases, designing and implementing code, and troubleshooting problems. This course can help you build a foundation for a successful career as a Computer Programmer.

See salaries and explore the career path for Computer Programmer

Software Engineer

Software Engineers design, develop, and maintain software applications. They work with users to identify needs, design solutions, and implement and test software. The Microsoft Access 2013 certification exam, which this course prepares you for, covers essential software engineering skills, including creating and managing databases, designing and implementing software applications, and troubleshooting problems. This course can help you build a foundation for a successful career as a Software Engineer.

See salaries and explore the career path for Software Engineer