77-730 Microsoft Access Certification

Create a blank desktop database by using the blank database template, name and save it, then Access opens a blank datasheet for the first table (Table1).

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.

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.

Explore the core concepts of relationships in relational databases—one-to-one, one-to-many, and many-to-many. Understand how Access implements these with primary and foreign keys, referential integrity, and junction tables such as orders.

Explore one-to-many relationships between customers and orders, highlight referential integrity and cascade options, and explain how two one-to-many links form a many-to-many relationship via an intermediate table.

enforce referential integrity by using the relationships editor to link the owners and products tables via product ID, creating a one-to-many relation, and explore setting foreign keys.

Navigate access datasheet records with a record number box and first, previous, next, and last buttons, keeping the cursor in the field, and note that record numbers differ from IDs.

Choose a startup form in file options, current database, to display at open. You can also hide the navigation pane and restart to apply changes.

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.

Back up an Access database regularly to protect data by compacting and repairing it, and create backups before design changes using the Save As backstage option.

Split a database to improve performance and reduce corruption by separating data into a back-end database and objects into a front-end. Distribute front-end to users while back-end remains centralized.

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.

Explore objective domain 1 exercises and solutions in Microsoft Access 77-730, guiding you through creating blank databases, importing Excel and text data, building relationships, and configuring startup, security, and exports.

Learn how to import data from Excel into new or existing Access tables using the external data tab and the import wizard, including options to append, overwrite, or link.

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.

Import tables from another Access database by selecting the file and the tables to import, then use options to import table structure, data, or both (queries as tables optional).

Create tables, forms, and reports quickly by using Access application parts templates; define one-to-many relationships, customize forms, and select predefined parts like comments to accelerate database design.

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.

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.

Add, update, and delete records in Microsoft Access using the new record button or bottom row, navigate fields with arrow keys, and watch records sort by primary key.

Use the replace tab of the Find and Replace dialog to search the entire database for a value found with find what, and replace it with a new value.

Sort records in the datasheet by any field with ascending or descending options, while default order uses the primary key, and sorting does not change the table’s physical order.

Filter records in a data sheet using criteria to isolate results, with options including equals, between, and ends with, and clear the filter to show all records.