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.

Import database objects from another source to create a new Access database, using the external data wizard to import tables, queries, forms, reports, macros, and modules.

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.

Create and manage a one-to-one relationship between employees and cars in Access, linking car_id as a foreign key, enforcing referential integrity, and reviewing cascade update and delete options.

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.

Create and modify one-to-many relationships between customers, orders, and products in the relationships pane, enforce referential integrity, ensure compatible data types, and use lookup fields to simplify data entry.

Set and enforce a primary key to uniquely identify each record in an Access table. Learn single and composite keys and the auto number option.

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.

Identify and implement foreign keys to link child tables to primary keys in Access, ensuring compatible data types and field sizes across relationships.

View and manage Access database relationships using the relationships window and database schema. Model one-to-many, many-to-many, and one-to-one relations with primary and foreign keys, including junction tables.

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.

Create a navigation form in Access with horizontal tabs that link forms and reports. Drag items onto tabs, save, and rename tabs to customize the navigation interface.

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.

Explore displaying and organizing database objects in the navigation pane through filtering, view options, and sorting, then use show hidden objects and navigation options to adjust display.

Access offers object views; tables use datasheet or design view, while reports provide design, layout, print preview, and report views; switch via the home tab view command.

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.

Learn how to recover data from a backup in Access by importing the employees table with the Get External Data wizard, while noting that relationships may need manual restoration.

Navigate print options in access to print datasheets and reports, using print preview, page setup, margins, orientation, and export to excel or other formats for distribution.

Create and save user-defined database templates in Microsoft Access using the Save As tab. Customize names, descriptions, icons, and related options to share reusable database structures.

Export data from Access to Excel and other formats using the export wizard, choosing the object, destination, and whether to export with or without formatting to a named file.

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.

Create and name a staff details table in a Microsoft Access database. Define fields with appropriate data types, designate a primary key, and switch between design view and datasheet view.

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 manage large datasheet views by hiding fields, resizing and moving columns, and freezing columns while preserving the underlying table structure.

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.

Rename tables in Microsoft Access by right-clicking the object in the navigation pane and typing a new name, with name auto correct updating references in reports, forms, and queries.

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.

Append records from an external data source to an existing Access table without overwriting data, using the external data wizard to match field names and data types.

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.