This Microsoft Access 2013 Exam 77-424 is designed for candidates who have a fundamental understanding of the Access 2013 environment and the ability to complete tasks independently. They should know and demonstrate the correct application of the principal features of Access 2013.
The new Access 2013 certification exam uses practical, performance-based scenarios to evaluate their real-world capabilities with project and standards-based outcome testing.Certified candidates will demonstrate their ability to use principle Access 2013 features to independently create custom, browser-based database applications. Tasks will include creating and managing a database, building tables, creating queries, creating forms and creating reports.
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area in the exam. The higher the percentage, the more questions you are likely to see on that content area in the exam.
Create and manage a database (20–25%)
Build tables (25–30%)
Create queries (15–20%)
Create forms (15–20%)
Create reports (15–20%)
The Microsoft Access 2013 exam is more relevant than past exams, featuring comprehensive, project-based testing. This means candidates are responsible for demonstrating the ability to complete a realistic Microsoft Office Specialist Access 2013 project.
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
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
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
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
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
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
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
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
Welcome! to the Knowledge factory by ClayDesk. My name is Syed Raza, and as the CEO of ClayDesk, I am delighted to provide learning solution to my students. My fellow co-instructors play an important part in building these courses to ensure quality and latest trends in learning - I encourage you to browse through our courses and enroll.
1) We teach with passion and purpose! Every course is delivered with our students in mind. Teaching a combined student population of over 160,000.
2) Our courses will help you gain real world skills and knowledge and change your life today!
3) Our dedication to the teaching profession and teaching online. Udemy has named our instructors as one of its top instructors.
ClayDesk creates and distributes high quality technology training content. Our certified team of industry professionals have been training manpower for more than a decade. We aim to teach technology the way it is used in industry and professional world. We have professional team of trainers for technologies ranging from Mobility, Web to Enterprise and Database and Server Administration.
Mission Statement- ClayDesk e-learning is dedicated to provide superior e-learning and outsourcing services worldwide.
Why are 80,000+ students (and counting) enrolled in my courses?
1) As the CEO of ClayDesk, I teach with passion and purpose! Every course is delivered with my students in mind.
2) My courses will help you gain real world skills and knowledge and change your life today!
3) My dedication to the teaching profession and teaching online. Udemy has named me one of its top instructors.
► Try enrolling in a course with me and see for yourself! ◄
Want to learn how to become A Professional Web Developer?
Would you like to Boost Your Career?
Then Enroll in my Courses Today! You too can be doing this - and so much more!
About Syed Raza:
Syed graduated from University of Wisconsin in 1995 with a BBA in Finance. Subsequently, he obtained an MBA from Concordia University, LLB and DBL degrees from University Law College, and PhD in Management Sciences. Having obtained MCSE (Microsoft Certified Systems Engineer), MCP+I (Microsoft Certified Professional + Internet), and MCT (Microsoft Certified Trainer), Syed has provided training to thousands of students. ClayDesk provides e-Discovery and cloud computing services including technical training to a wide range of clients globally.
Syed Raza is an entrepreneur running his own e-learning site along with providing e-discovery and cloud computing consulting and services to a global client base. Syed is a Microsoft Certified Trainer and a Systems Engineer, and his solid finance and management background gives him a competitive edge. He has taught thousands of students in the United States and continues to inspire students of all ages.
Mission Statement- ClayDesk e-discovery and cloud computing is dedicated to provide superior e-learning and outsourcing services worldwide.
Qasim graduated from the University of Wisconsin with a BA in Interpersonal Communications; going on to obtain an MBA in Marketing from LUMS University. Alongside the exciting academic thrill seeking, he has a passion for IT, having obtained a MCSE (Microsoft Certified Systems Engineer), MCT (Microsoft Certified Trainer), A+ Hardware Certification and a MCP+I (Microsoft Certified Professional + Internet).
Qasim has been making this world more knowledgeable since 2003, having trained and molded thousands of minds across the globe.
I am the youngest Instructor present on Udemy Platform and have several years of experience in development environment as programmer. I have been programming since the age of 13.
On the other hand, I have expertise and experience in all phases of project life cycle namely analysis, design, coding, testing and implementation phases. I have experience in working with different operating systems, with keen focus on SharePoint development.
Also have efficiently managed the team and took care in delivering quality deliverables from my team which proved my managerial and leadership skill. Moreover, I have high web developing skills as a web developer and can make websites using WordPress, Joomla, and Drupal. Additionally, can migrate them from one host to the other. I have worked within the following realms:
- Developed script in Python programming language for 3D mapping using raspberry pi and quad-copter
- Developed system for processing data in parallel with data collection
- Redesigned tracking systems to work with tabular data
- Developed tools in Python for vehicle tracking and post-data-collection processing
- Data parsing, statistical analysis