77-730 Microsoft Access Certification

Name: 77-730 Microsoft Access Certification
Rating: 4.7 (24 reviews)

Complete Techniques for the 77-730 Microsoft Access Certification Exam

Highest Rated

Created byDave Murphy

Last updated 6/2021

English

English [Auto],

What you'll learn

All techniques for the Microsoft Access 77-730 Certification Exam
How to prepare for the exam
Be ready to pass the 77-730

Course content

26 sections • 100 lectures • 9h 27m total length

Course Introduction and Structure3:58
Navigate the 77-730 microsoft access certification objective domain, covering five sections from create and modify databases to format reports, with emphasis on end-of-section exercises and the accompanying PDA.

1.1.1 Create a blank desktop database5:02
1.1.2 Create a database from a template2:41
Explore the template gallery, create a database from a task management template, name and save it on the desktop, view the description and optional welcome video, and then customize.
1.1.3 Create a database by using Import objects or data from other sources5:39
1.1.4 Delete database objects3:29
Delete database objects with caution, as relationships and dependencies can trigger warnings and impact related forms, reports, or tables. Use object dependencies to verify dependents before deleting.

1.4.1 and 2 Compact and Repair a Database2:37
Compact and repair a database to reclaim disk space and improve performance, then enable automatic compact on close and understand the importance of backups for corruption.
1.4.3 Back up a database2:26
1.4.4 Split a database6:01
1.4.5 Encrypt a database with a password3:19
Guard database access by encrypting with a password, which requires opening in exclusive mode and a strong, case-sensitive password; you can decrypt to remove protection.
1.4.6 Recover data from backup2:38

2.1.1 Create a table9:25
2.1.2 Import data into tables5:17
2.1.3 Create linked tables from external sources4:53
Create linked tables from external sources in Access to view current data without copying it, with updates reflecting source changes and one-way linking to sources like Excel and text files.
2.1.4 Import tables from other databases1:56
2.1.5 Create a table from a template with application parts4:29

2.2.1 Hide fields in tables2:51
2.2.2 Add total rows1:24
Learn to add a total row in Access datasheet view and apply aggregate functions - average, count, max, min, standard deviation, and variance - to numeric columns, with count for non-numeric columns.
2.2.3 Add table descriptions1:40
Add and edit table descriptions in Access using the property sheet's description, up to 255 characters, visible in the navigation pane's detail view.
2.2.4 Rename tables1:32

Requirements

Copy of Microsoft Access 2016

Description

This course will prepare you to successfully pass the 77-730 Microsoft Access certification exam. The 77-730 is the only exam officially recognised by Microsoft for Access 2016. Every aspect of the exam is covered in detail, together with exercises and solutions. Delivered by a University professor with many years experience in teaching databases to undergraduate students, and who is also a Microsoft Office Specialist examiner, if you take this course and follow the guidelines provided, you will enhance your chances of obtaining this extremely valuable qualification. Prove your database skills by obtaining independent certification from Microsoft.

Who this course is for:

All students who wish to obtain the Microsoft Access 77-730 certification.
No prior knowledge is assumed. Suitable for students at all levels.

77-730 Microsoft Access Certification

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 4min

1.1 Create and Modify Databases4 lectures • 17min

1.2 Manage Relationships and Keys8 lectures • 46min

1.3 Navigate through a Database5 lectures • 15min

1.4 Protect and Maintain Databases5 lectures • 17min

1.5 Print and Export Data3 lectures • 15min

Objective Domain 1 Exercises and Solutions1 lecture • 20min

2.1 Create Tables5 lectures • 26min

2.2 Manage Tables4 lectures • 7min

2.3 Manage Records in Tables5 lectures • 16min

Requirements

Description

Who this course is for: