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.
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.
The curriculum includes a specific multi-stage process for importing Excel data and designing correct table structures to resolve duplicates.
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.
This course is best suited for Excel users who need a clear, comparison-sited introduction to Access objects to manage their existing data more effectively.
Score breakdown
The curriculum covers essential objects like tables, queries, and forms, though one signal suggests an imbalance toward form creation over query depth.
The course uses real-world examples, but one signal indicates it lacks sufficient interactivity for hands-on application.
Learner signals highlight clear, concise instruction that relates new concepts back to existing Excel knowledge.
The curriculum includes a specific note regarding an Access 2016 workaround, but no other current version evidence is present.
The curriculum aligns well with the goal of transitioning from Excel to Access through structured data migration.
