Microsoft Access 2010 Training - Beginners/Intermediate

Discover the core database components in Access, including tables, records, and fields (attributes). See how forms, queries, reports, macros, and modules unlock data interaction with Northwind data.

Explore basics of database design using the Northwind Traders example, focusing on tables, primary keys, foreign keys, and the relationships that connect suppliers, purchase orders, and status.

Build a database from scratch in Access 2010, using Northwind as a guide and templates, and learn to design tables, forms, reports, and the navigation pane.

Learn to create tables in Access 2010, define primary keys and data types, and set up a one-to-many relationship between students and invoices with referential integrity.

Learn to create new tables in Access 2010 using application parts and quickstart, establish one-to-many relationships with primary and foreign keys, and import courses from Excel via a wizard.

Master entering data types into access tables, set primary keys and auto number IDs, and use datasheet view and paste append to add and edit records.

Master table attribute changes and data presentation in Access, including row height, column width, and freezing fields. Learn to copy and delete records while managing referential integrity with cascade delete.

Explore how to add, rename, delete, and reorder fields in Access tables, understand automatic data type assignment in datasheet view, and use design and datasheet views to manage table structure.

Examine table and field properties in Access 2010, including text and date/time data types, field size, caption, validation rules, indexing, input masks, date picker, and the lookup wizard.

Leave a review to share the value you gain and help improve the training material. Click stars to rate this course and add comments; you can update your review later.

Explore how to auto-create forms with the form wizard in Access 2010, design task-focused interfaces, and use built-in search and filter features to manage records efficiently.

Explore creating Access forms with the form, blank form, datasheet form, multiple items form, split form, and wizard subforms, then design, save, and link them to tables for data entry.

Learn how to add fields to existing forms in Access 2010, including bound controls, alignment, tab order, and using existing fields, labels, and checkboxes to refine a form.

Explore the expression builder in Access 2010 to perform calculations, define data entry rules, and create calculated values using date, time, and other built-in functions.

Apply conditional formatting in Access 2010 forms and reports to highlight due dates, and build calculated controls for discounts with the expression builder and currency formatting.

Sort data across tables using single or multiple fields with ascending or descending order, and apply advanced filtering to show only selected states and then sort by last name.

Master sorting, filtering, and find and replace in Access 2010 forms using the Northwind database; learn form view capabilities, property sheets, and multi-criteria filters.

Learn how Access 2010 builds reports with headers, footers, grouping, and totals, using queries to create fields like contact name and file as for quarterly sales.

Create and refine Access reports using the wizard, design and layout views, and print preview to ensure correct paging, with emphasis on tables, fields, sorting, and page numbers.

Create a student tasks report with the report wizard, selecting student and task fields, sorting by due date and priority, and refining the layout in design view.

Enhance access reports by adding existing fields, aligning and formatting borders, and using group and sort to organize data; explore print, export, email options, and adding totals for summaries.

Explore how to build and refine select queries in Microsoft Access 2010, including sorting, applying criteria, and joining tables to view related fields like student names.

Learn to build and refine Access queries by selecting fields from related tables, applying numeric and text criteria, using wildcards, and adding parameter prompts.

Learn how to create update, append, and delete queries in Access 2010, including updating fields with expressions and appending records from one table to another.

Explore inner and outer joins, create a make table query to save overdue invoices, and perform a mail merge with Word to send reminders.

Explore how to secure Access 2010 databases with password protection and encryption, manage user access with exclusive mode, and log activity for traceability.