Learn Access quickly and understand how it works with Excel. Master the basics of tables, queries, forms and reports.
InstructorBruce MyronInstruction covers essential Access objects including tables, various query types, forms with subforms, and report generation.
The curriculum includes a specific multi-stage process for importing Excel data and designing correct table structures to resolve duplicates.
Editorial course preview
These 4 complementary views highlight concrete, legible examples from the course presentation.
This screenshot shows a sample Excel dataset containing customer records with names and addresses, illustrating the raw data format used in this course.
This screenshot displays a Microsoft Access customer form interface featuring personal details like name and address alongside a linked subform showing specific order totals.
This Microsoft Access form displays customer information for Albert Snyder alongside a subform grid showing multiple related order records with dates and totals.
This interface demonstrates an Access database form used for order entry, featuring fields for customer information and a lookup table listing available products with their corresponding prices.
One signal suggests the course lacks sufficient opportunities for hands-on application of taught concepts.
A mixed signal indicates the curriculum may focus heavily on form creation at the expense of deeper query and database building instruction.
The curriculum aligns well with the goal of transitioning from Excel to Access through structured data migration.
