Study Guide for Exam 77-730 - Microsoft Access 2016

Anand Vemula

Summary

The Study Guide for Exam 77-730: Microsoft Access 2016 is designed to help candidates prepare for the Microsoft Office Specialist (MOS) certification exam. The guide offers a structured approach to mastering the core features and functionalities of Microsoft Access 2016. It focuses on essential topics, including database creation, table design, query formulation, form and report building, and maintaining data integrity.

The guide starts by covering how to create and manage databases, emphasizing database creation from scratch, the use of templates, and establishing relationships between tables. It also covers the application of primary and foreign keys, along with enforcing referential integrity to ensure consistent data.

Building tables is a major section, where candidates learn how to define field data types, use input masks, and apply validation rules to maintain data accuracy. The study guide dives deep into creating and modifying queries, including how to use select, action, and aggregate queries. Techniques for joining tables and using calculated fields are also taught.

Form and report creation are crucial aspects of the exam. The guide demonstrates how to design forms and configure their controls, apply formatting, and set properties for efficient data entry. Similarly, report creation focuses on grouping, sorting, and inserting key elements like charts and page numbers.

The guide also emphasizes maintaining data integrity through validation rules, as well as importing and exporting data to and from external sources like Excel. This study guide equips candidates with the skills needed to confidently sit for and pass the MOS 77-730 exam.

Available since: 06/05/2025.

Print length: 120 pages.

Other books that might interest you

St Louis Trailblazer Erma...

Mrs. Patricia Treacy

Breaking Glass Ceilings in St. Louis   Erma Mary Bergmann was a generation ahead of her time. She was born in a cold-water flat over a shoe store on South Broadway in St. Louis's Soulard area. Restrained by the Great Depression and the minority status of women in the 1930s and '40s, she hoped someday to climb out of poverty. When she was recruited to play baseball with the All-American Girls Professional Baseball League, her life changed. She pitched a no-hitter in 1947. She parlayed her natural athletic ability into two successful careers, baseball and policing. She spent twenty-five years as a policewoman, serving on the dangerous Decoy Squad. Author Patricia Treacy details the history of a pioneering woman.

Show book

Disabling Leadership - A...

Andrew Thomas Draper, Andrea...

People with disabilities are often excluded from full participation in church communities. Accessibility is a key component of the biblical ministry of reconciliation—but it's not enough. To truly work toward reconciliation, churches must both consider the theological implications of disability and also become places where people with disabilities lead.
Disabling Leadership presents a practical theology of disability for thoughtful church leaders and congregants. Written by practitioners and a scholar-pastor who are engaged in ministry together, this book encompasses cutting-edge theological ethics as well as stories of how such commitments are embodied in a real church community. The authors equip readers to explore key themes such as:

- what it means to be human
- how to understand suffering and healing
- how churches can be welcoming and accessible communities
- how to face common challenges and issues in resisting ableism
Disabling Leadership moves beyond paternalistic views of disability that seek to extract "inspiration" from another's story without engaging in the difficult work of just and dignifying relationships. When we foster genuinely inclusive leadership teams, the authors contend, our churches will be less likely to treat anyone as a "project" and will better reflect God's love as the body of Christ.

Show book

Daag

Natheneal Hathoaran

Daag by Natheneal Hathoaran is a deep psychological exploration of the human mind. Through the story of a girl and her complex relationships, the book dives into why thoughts of crime arise in the human mind and how they impact daily life. The author examines how society punishes not just with laws, but with lasting labels—symbols that a person must carry for life as a reminder of their actions. Daag reveals the hidden scars left by guilt, judgment, and memory.

Show book

Learn Urdu: Must-Know Urdu Slang...

Innovative Language Learning, ...

***Important: This Audiobook comes with 3 bonus Urdu “slang” and “curse words” conversation cheat sheets***
 

 
Want to speak Urdu like a native, understand daily conversations...
 

 
...and graduate from “knowing just a few basic textbook phrases”?
 

 
Then this the Audiobook is for you.
 

 
You’re about to learn 100+ Urdu slang words and phrases used in daily life. With the “Learn Urdu: Must-Know Urdu Slang Words & Phrases (Extended Version) by UrduPod101” Audiobook, our teachers explain and break down each word and phrase across 25 lessons!
 

 
And all YOU have to do is listen and repeat.
 

 
What you get with this Audiobook:
 
• 25+ Audio-based Lessons & Review Tracks
 
• 150 Minutes (2+ Hours) in Total 
 
• Includes a 120+ Page eBook
 
• BONUS! 3 Urdu Slang Conversation Cheat Sheets
 

 
Results you can expect:
 
• Master 100+ New Words & Phrases
 
• Improve Your Speaking & Listening Skills
 
• Become a Better Urdu Speaker
 

 
Download the PDF and read along

Show book

Mastering Habits: Unlocking the...

AHMED MUSA

“Mastering Habits: Unlocking the Secrets to Lasting Change and Success: Master Your Daily Routines to Achieve Lasting Positive Change” is a must-read for anyone who wants to change their life through the power of good habits. Within this informative book, the writer explores the scientific side of habit formation, giving readers a full picture of how habits are formed, kept up, and changed. The book gives useful tips to help readers figure out what habits they already have, how they affect their daily lives, and what steps they can take to create good habits that help them reach their goals.
“Mastering Habits” gives you a step-by-step plan for personal growth by combining research-based ideas with real-life examples. Readers will learn how important it is to set goals that are clear and attainable, how important regularity is for making habits, and how important self-awareness is for making changes that last. The author stresses that long-term success doesn't just come from being motivated; it comes from developing focused habits that become automatic over time.
This book makes difficult ideas easy to understand for a wide audience by using interesting writing and familiar stories. “Mastering Habits” gives you the tools and inspiration to change your daily habits, whether you are a student, a worker, or just someone looking to grow as a person. The book also talks about the importance of accountability and community, pushing readers to get help and share their stories with others.

Show book

A Falling of Angels

W T Delaney

A Falling of Angels is the second part of the Sam Holloway Trilogy of military, action/adventure audiobooks by W T Delaney. The story unfolds against the backdrop of the western world's current struggle against Islamic terrorism. It's London in 2019 and the Islamic State has crumbled, and a team of British-born jihadists is on its way home with revenge and mass murder in mind. When a British agent within Daesh reveals a suicide bomb plot, Samantha Holloway, an ex-British Army Intelligence Corps operator, and her team of former Special Forces soldiers, are contracted by the Security Services to help. Sam's team must race to prevent the attack against the gripping backdrop of a secret, complex, and morally dubious CIA plot, to locate and capture the terrorist mastermind. Has Sam's team been told the truth as the clock ticks towards an attack on the heart of government? All three interlinked novels are based against a factual historical backdrop. The team works together again in the final book of the series An Evil Shadow Falls. The author has drawn on his own experiences gathered while working as an intelligence officer in both Iraq and Afghanistan to craft the stories. The narrator served with him. ***** Five stars again for Delaney.***** I listened to this in two sessions.***** Brilliant, Delaney's background nails the authenticity once again.***** This audiobook is as gripping as the first. ***** Delaney is a tour de force! I literally couldn't put this book down. He makes the complex murky world of counterintelligence infinitely entertaining. Loved it!

Show book