Introduction to Microsoft Access

Understand Microsoft Access tables as the core data container, define fields with a single data type, use records, and apply normalization with a unique primary key to ensure data integrity.

Create and rename a Microsoft Access table, switch between datasheet and design views, and add fields like transaction date, customer name, product id, quantity, price, and remarks with data types.

Explore table and field properties in the property sheet, configuring format, default value, validation, and rules for date, short text, quantity (double), and price (currency) fields.

Learn how an autonomous field auto-assigns a unique long integer to each record, and how a primary key ensures unique records and links tables in Access.

Learn to save and view an Access table in datasheet view, adjust field widths, and apply captions to display user-friendly names, while entering records with default dates and mandatory fields.

Import data from Excel into Access by creating new tables, choosing sheets, setting the first row as headings, defining data types and primary keys, and navigating large imports.

Explore how Microsoft Access queries turn information into results, using select queries across tables and action queries to append, delete, or update data, plus crosstab and specialized queries.

Learn to create a query in Access using the query wizard or design view, selecting a table, choosing fields, and applying aggregation and grouping to generate and view results.

Learn to design Microsoft Access queries using the query builder to select tables and fields, switch between design, datasheet, and SQL views, and run to review results.

Learn how to add criteria to a Microsoft Access query, using design view and the expression builder to filter by text, price, and quantity.

Apply date criteria in an Access query design view using # around dates in the criteria area, then run to fetch records from 2016-01-01 to 2016-03-31.

Use the in operator in a query to filter a dataset by item codes, testing for multiple products (for example P2 and P6) with the expression builder.

Create a calculated field in a Microsoft Access query by multiplying quantity by price with the expression builder, naming it revenue, then save and run to see the total revenue.

Learn how to manipulate fields in Microsoft Access by changing field order in tables and queries using design view, dragging and dropping, and adding or deleting fields.

Group data in a Microsoft Access query by item code, sum quantities, and derive total revenue by quantity times price; view totals in design view.

Master IIf and Switch functions in Access queries to test conditions and return varying outcomes, including gift vouchers, discounts, or gift hampers, and explore nested IIf and search function.

Learn to convert a query into a parameter query in Microsoft Access, add date prompts, and use between with parameters to fetch dynamic results.

Learn how to create relationships in Access by linking primary and foreign keys across tables such as countries, customers, and sales. Avoid data duplication and enforce referential integrity.

Explore how one-to-many relationships link countries, customers, and sales, and build a multi-table query design in access to compute revenue and due dates with calculated fields.

Explore how Microsoft Access forms view, edit, add, and delete data. Create instant forms from queries or tables and customize with labels, text boxes, image controls, and ActiveX controls.

Create a very basic form in Microsoft Access using a query recordset, explore form, layout, design, data sheet, and split views, and adjust fields, properties, and navigation.

Create a form from scratch in Access using design view, connect to a query, add fields, and format labels, then switch to data sheet or form view and refine layout.

Create a form with start and end date controls, link them to a query using between criteria, and add a date picker and a run query button to fetch records.

Learn to configure a combo box in a Microsoft Access form, populate values from a table or list, and connect it to a query using a wild card.

Apply techniques to add a subform within a main form, link it to a query, and display aligned, filterable data on the same screen using combo boxes and text boxes.

Learn how to clear all controls on a Microsoft Access form with a single button, resetting text boxes, dates, a country combo box, and the subform.

Display country flags in a form using DLookup to fetch image paths from external files, avoiding embedding images and enabling dynamic updates as countries change.

Explore access reports for a customized view of data, viewable on screen or printable, with grouping, sorting, and totals, using bound, unbound, or calculated controls.

Create an instant Microsoft Access report from a table or query data source, then tailor layout, borders, alignment, and formatting, and preview the print output.

Create a report from scratch in Microsoft Access by linking to a query, adding fields and a header, and applying grouping and sorting by country and customer, hiding duplicates.

Learn to add subtotals and averages in an Access report by switching to layout view, using the totals dropdown for sum and average, and formatting results.

Learn to add a calculated field in a Microsoft Access report using the expression builder, balance bound and unbound fields, and create subtotals and grand totals.

Preview the report in print preview, switch to design view, and resize fields to ensure complete numbers before printing.

Highlight prices under 25 in an Access report using conditional formatting in design view, applying bold text and a green background to draw user attention.

Learn how Microsoft Access macros automate tasks and add functionality to forms and reports, using a simple stepwise language built from dropdown-selected actions that require no code.

Automate report sharing in Microsoft Access by adding a button that opens a report, then use a macro to email the PDF attachment via Outlook, including country-filtered data.

Create a startup homepage in access by turning a full-screen centered interface and setting it to open on startup. Add command buttons and macros to open related forms.