MS Access Crash Course

Learn microsoft access as a database application in office, and master tables, forms, queries, reports, and data import export, plus linking tables with primary keys.

Create an MS Access table in design view. Define fields such as serial number, name, phone number, subject, date of birth, and apply data types, input masks, and lookups.

learn to create a form from a table in MS Access using the wizard, link the form to the table, and see entries reflect in the source data.

Learn to create a blank form in MS Access by adding text boxes, labels, and common form controls in design view, then switch to form view and save.

Create an Access report by selecting the target table and fields, then configure the layout. Preview and print the report, choosing landscape or portrait orientation to fit your data.

Learn to import and export data in MS Access by exporting a table to various formats and importing from Excel or other files, using headings and primary key settings.

Learn to build and run MS Access queries by selecting a table, choosing fields, sorting by name, applying filters with wildcards, and saving reusable criteria.

Learn to write basic SQL queries in MS Access to fetch information from a database, including selecting columns, using distinct, filtering with where, and ordering results in part 1.

Learn how to use SQL insert, update, and delete commands in MS Access to modify table data, enter new records, and manage changes.