Access Course: Strengthen Your Database Management

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje

Access Intermediate Curso Describir

Aprendizaje verificado

Habilidad	Pre-evaluación	Lección	Post-evaluación
Create Relational Databases
Table Relationships and Relationship Types Manage table relationships and their types	No empezado	No empezado	No empezado
Create Relationships Between Tables Set Access table relationships and integrity	No empezado	No empezado	No empezado
Enforce Referential Integrity Maintain referential integrity in Access tables	No empezado	No empezado	No empezado
Print and Delete Relationships Print relationship diagrams or remove links	No empezado	No empezado	No empezado

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Work with Queries			Cuenta requerida
Create a Query How to create a query in Access step by step
Hide, Remove, and Sort Fields Hide remove and sort fields in Access
Use AND and OR Operators in a Query Combine criteria with AND and OR in Access
Create a Multiple Table Query Build a multiple table query in Access
Create a Calculated Field Create calculated fields in Access with formulas
Work with Expressions and the Expression Builder Expression Builder in Access for quick formulas
Format Fields within Queries Format query fields for clear data in Access
Use an IIF Function Access IIF function for conditional results
Summarize Groups of Records Summarize data in Access with group totals
Display Top or Bottom Values Show top or bottom results with query limits
Parameter Queries Create parameter queries in Access with prompts
Find Duplicate Records Access query to identify duplicate values
Find Unmatched Records Use the Unmatched Query Wizard to spot gaps
Crosstab Queries Access crosstab query to pivot and summarize
Delete Queries Remove records safely with an Access delete query
Append Queries Add records with an Access append query
Make-Table Queries Create a new table with a make table query
Update Queries Bulk edit records with an Access update query

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Work with Forms			Cuenta requerida
Create a Form with the Form Wizard Build forms fast with Access Form Wizard
Create and Use a Form Access form design fields controls data entry
Modify a Form in Layout View Refine form layout in Access with live tweaks
Form Design View Basics Access Design View for form layout and controls
Change the Tab Order Access form tab order navigation
Work with Control Properties Adjust control properties for Access forms
Work with Form Properties Edit form properties in Access
Change a Controls Data Source Set the Control Source property in Access
Create a Calculated Control Compute values with calculated control in Access
Change a Controls Default Value Set default values for controls in Access
Create a Subform How to create a subform in Access
Work with and Modify Subforms Edit Access subforms layout and links
Create and Modify a Navigation Form Build an Access navigation form with tabs

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Work with Reports			Cuenta requerida
Create a Report Build and format reports in Access
Use the Report Wizard Build reports fast with the Access Report Wizard
Use the Label Wizard Create labels fast with Access Label Wizard
Work in Layout View Edit forms live in Access Layout View
Format Fonts Change text size color and style in Access
Copy Formatting Copy styles across Access fields fast
Change Text Alignment Align text left, center, or right in Access
Insert a Logo and Background Image Add a logo and background image to reports
Adjust Page Margin and Orientation Adjust page margins and orientation in Access
Add Page Numbers and Dates Insert page numbers and dates in Access
Group and Sort Group and sort records in Access reports
Summarize Data using Totals Add Totals to quickly summarize Access data
Understand Report Sections Access report sections from header to footer

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Advanced Topics			Cuenta requerida
Use Conditional Formatting Conditional formatting in Access highlights data
Work with Number Formatting Access number formats currency percent
Use Themes Apply and customize themes in Access
Import Information How to import data from Access to Excel
Export Information Send Access data to Excel, CSV, or PDF
Link External Information Link external data sources to Access tables
Mail Merge Records to Word Merge Access records into Word documents
Use Hyperlink Fields Add and open hyperlinks in Access tables
Database Object Dependencies View object dependencies in Access
Compact and Repair a Database Reduce size and fix errors in Access databases
Convert an Access Database Upgrade Access database format safely
Back Up and Restore a Database Safely back up and restore your Access database
Password Protect a Database Protect Access database with a password
Split a Database Separate front end and backend for faster Access

Descargas para estudiantes

Concise, easy-to-use guide for quick learning and reference.

Obtenga un certificado de finalización

Comparte tu certificado con posibles empleadores y tu red profesional.

Su Nombre

Para habilidades verificadas en: Access Intermediate

Emitido el mayo 15, 2026