Microsoft Access 2010 Training - Advanced

This lecture introduces macros in Access 2010, contrasts macros with VBA, and demonstrates creating a simple macro that shows a message box and is linked to a form button.

Explore the autoexec macro in Access 2010, which runs at database open after startup options, and learn to open forms and show the getting started form via the settings table.

Learn to distribute an Access database by configuring current database options, set the application title and icon, startup form or splash screen, and navigation pane and tabbed or overlapping windows.

Explore Access 2010 database options, including compact on close, remove personal information, layout view, design changes in datasheet, picture storage format, navigation and ribbon options, and auto correct settings.

Discover naming conventions in Access 2010 by prefixing objects (tables and forms), remove spaces to prevent up-sizing and linking issues, and learn how renaming affects queries, macros, and form references.

Master Access 2010 table design by exploring design view, field names, data types, and primary key and field properties for clean, standards-aligned databases.

Master field properties in Access 2010, focusing on format and input masks to control date display, text casing, and data entry for IDs and emails.

Learn to use captions and validation rules in Microsoft Access 2010 Advanced, including date of birth constraints and validation text.

Explore primary keys, auto number, and composite keys to uniquely identify records, then learn how indexing speeds reports while affecting update performance and space.

Explore data normalization in Access 2010 by turning a badly designed students courses table into first, second, and third normal forms, linking data with primary and foreign keys.

Explore advanced relationship design in Access 2010, including one-to-many and many-to-many links with foreign keys and join tables, and enforce referential integrity with cascade options.

Explore how to create and refine Access 2010 queries using the grid and design view, including select queries, sorting, criteria, aliases, and using results in forms, reports, or subqueries.

Explore advanced features of Access 2010 queries, including creating computed fields by concatenating first and last names, sorting by surname, and handling guardians with missing names using an if function.

Master creating complex queries in Access 2010 using if statements, joins and subqueries to integrate student and attendance data and reuse queries as inputs.

Leave a review and rate this course with stars, then share your comments to help improve the training material.

Master datasheet view for data entry in Access 2010, with quick sorts, filters, multi-field sort, and column customization for student and guardian records.