Microsoft Access Tutorial

What is Microsoft Access? Microsoft Access is a desktop relational database application. It stores data in tables and gives you forms for entry, queries for questions and reports ...

Create a Database Start Access → Blank desktop database, name it and Create. A blank table opens automatically in Datasheet view . Design View - the Right Way Right-click the ...

Why Stories Need Joins A customer places many orders; an order has many lines; each line points at one product. These are one-to-many links that relate tables instead of repeating ...

What a Select Query Does A select query picks specific fields and records from one or more tables and shows the answer in a grid. Queries are reusable - create once, run anytime. ...

Parameter Queries - Ask at Run Time In criteria type [Enter City:] . When you run the query Access asks for the value - one query, many questions. Great for reports: Totals ...

Why Forms Datasheet grids are fine for maintenance, but users need friendly entry screens. A form shows one record at a time with labeled boxes, lists and validation. Create a ...

Why Reports Reports present data for reading - grouped, sorted, summed and formatted for print or PDF. They read data only and never change it. Create a Report (Wizard) Select a ...

External Data - Hello Excel External Data tab → New Data Source → Excel. Import into a new table or link to the workbook: Import - copies the data into Access; a ...

Field-Level Validation In a field's Design view properties set Validation Rule and Validation Text: Table Validation In Table Design, the Validation area of the properties sheet ...

Macros - No-Code Automation Create → Macro opens the designer. Actions like OpenForm , RunSQL , MessageBox and SetValue chain with conditions: Attach macros to command ...

The Scenario Build a small order tracker: Customers, Orders, Products and OrderLines. This ties together every concept from the course. 1. Tables 2. Relationships Customers 1-< ...