Advanced Microsoft Access 2013 Training Video

Learn to use input masks in Access to enforce consistent data entry, guiding date, numeric, and text inputs with the wizard or custom codes.

Learn how indexing in Access tables speeds data retrieval by sorting with primary keys and secondary indexes, and how date of birth and county indexes improve searches.

Configure composite primary keys by selecting multiple fields to prevent duplicate employee entries in the same race, using race id, race position, and employee id together.

Explore extended field properties in Access 2013, including data-type specific settings, default values, validation rules, captions, input masks, and Unicode compression for text, date, and numeric fields.

Learn to use Access's data table analyzer to normalize a table for improved performance, extract repeating values into separate tables, and build joined queries with proper relationships.

Identify unique values by querying distinct state province names and country regions. Apply the distinct or unique options to reveal 54 country-state pairings from 18,508 customers in six countries.

Learn to build parameter queries in Access that prompt users for runtime criteria, using square brackets, wildcards, and concatenation to filter results.

Learn to create formula fields in Access queries to compute profit as 10 percent of total purchases, format currency, concatenate first name initial with the last name, and calculate ages.

Explore how to use if conditions within a formula field in access to conditionally calculate the home owner tax and apply a 25 percent child rebate when eligible.

Explore altering join types between tables in Access 2013, using join properties to switch from inner joins to left and outer joins, and identify orphan records.

Learn to build crosstab queries with wizard, using a table or multiple tables, to set row and column headings and count or sum by department, county, gender, and marital status.

Learn to build cross-tab queries in Access 2013 without the wizard by configuring row and column headings and using counts or sums across fields like state and marital status.

Explore the expression builder in Microsoft Access 2013 to create computed fields in queries. Use date time functions and if statements to calculate length of service and segment Australian customers.

Explore action queries in Microsoft Access to update data, including increasing total purchase YTD and assigning titles by gender (and marital status), with run versus view and safety warnings.

Learn to create a parameterized update query in Microsoft Access that prompts for customer ID and new sale value, updating the total purchase ytd for selected customers.

Learn how to create a make table query in Microsoft Access 2013 to generate a table from a select query, enabling backups, data extraction, and exporting or importing across databases.

Build a single flat table from multiple tables with a make table query, including gender, title, first name, surname, amount, price paid, and a calculated total paid, ready for export.

Import new employee data into a new table, update gender to numeric, map fields, and append to employees while not appending to the id field to preserve primary keys.

Create delete queries in Access to remove records by criteria, such as all employees in a town, while backing up first to avoid irreversible loss.

Back up the employees data with a make table query before deleting, then restore with an append query from the backup, preserving IDs.

Demonstrate standard sql syntax and its use in access queries, covering select from where join group by and order by, with asterisk and square brackets for fields.

Learn to filter data with the where clause in Access SQL by building criteria for text, numbers, and dates, including multi-criteria and fields with spaces.

Learn to link multiple tables in Access using inner and left outer joins, with table aliases and prefixed fields to build precise, multi-table queries.

Group data by department and gender in Access 2013, count employees, and compute total or average salary using SQL aggregate functions; extend grouping to counties for regional insights.

Discover how to add formula fields in Access SQL select statements, perform calculations, use square brackets, and concatenate with ampersand or plus, with left for initials and as for aliases.

Explore the power of subqueries by using an in statement with a select inside, then group by state province, apply having count, and embed the result in an outer query.

Generate a union query in Access by combining employees and customers with matching columns. Use select statements and a flag field to distinguish records, creating a live email-ready list.

Master action SQL statements in Access 2013, using update, delete, make table, and append queries; learn syntax, where criteria, and field matching for precise data manipulation.

Add bound data objects to an Access form by using design and layout views, adding existing fields, resizing and aligning labels and data, and previewing in form and datasheet views.

Add unbound objects, including labels and images, in design view to enhance forms; embed logos and headers, format text and backgrounds, and keep unbound items static while navigating records.

Learn to manually configure combo boxes in a 2013 access form, binding fields like marital status, gender, and department, using value lists, distinct queries, and bound columns for user-friendly drop-downs.

Query and bind a combo box to show multiple columns, reference unbound columns to display first name, surname, and date of birth, and compute age with cdate and 365.25.

Explore navigation forms in Access 2013, building a multi-form interface with horizontal top tabs and vertical tabs on the left or right; drag forms in layout view and save structure.

Learn to create non-data forms as menus and dialogs in advanced Microsoft Access 2013, using modal dialog boxes and menu forms, command buttons, and customized captions for clear prompts.

Create command buttons for your forms using the command button wizard, enabling close, open form, view children, and quit application actions within Microsoft Access 2013.

Open a form filtered by another using a bound combo of employees, then click a command button to open the employees form filtered by the selected id.

Create and customize command buttons without the wizard using VBA to open and close forms, apply where clauses, and handle on click events in Microsoft Access 2013.

Create a listbox bound to employee data and enable double-click to open the employees form in normal view, filtering by the selected ID.

Create a simple search form in Access to filter employees by first name and surname using a search box, a where condition, and wildcards for partial matches.

Filter list and combo boxes dynamically in Access forms by using distinct country values and after update events to refresh related lists, enabling country and profession based filtering.

Embed a chart on a blank form using the customers table to show sales by country with total purchase ytd. Customize the chart type, fonts, and legend.

Create a report from scratch in Access 2013 using design view and a data source, then set page layout and align fields in a tabular, print-ready format.

Discover how to add titles and a logo to an Access 2013 report using design view, with report header formatting, image insertion, and page header options.

Learn to format Access reports by removing borders, adjusting fonts, and configuring alternating background colors and horizontal lines, then verify results with print preview.

Add page numbers and the current date to Access reports using header/footer controls or a custom date box, then display current and total pages with Page and Pages fields.

Learn to add calculated fields directly in a Microsoft Access report, computing profit from total purchases YTD and age from birth dates, without using a query.

Learn to sort and group data in Access reports, customizing sort orders and creating group headers and footers, with totals and repeat headers for multi-page printing.

Create a grouped report in design view attached to the employees table, set margins, format fields, and add department totals with salary sums and a group count.

Create a salary summary report in Access 2013 by grouping employees by department, calculating count, total salary, and average salary, with a clean header and currency formatting.

Learn how to concatenate multiple address fields into a single field with carriage returns, using chr(13) and chr(10), conditional logic, and formatting in a Microsoft Access report.

Open a report filtered by the current record from a form using a button, passing the customer id in a where clause to show the preview.

Add a chart to a report with the chart wizard to visualize sales by country from the IPT customers table, then adjust chart type, axes, and labels in design view.

Add a pie chart to a report in Microsoft Access 2013, filtered by the group header and tied to department data showing salary by town for insights.

discover how bound and unbound subforms work in access, placing forms inside a master form, linking data, and reflecting changes across the master and subforms.

Create a master form with no data and embed three unbound subforms for employees, customers, and pets, each with its data source. Arrange them side by side as continuous forms.

Create a bound subform in a master form to display and filter related data from the shares table in Microsoft Access 2013, using a continuous form and master-detail relationships.

Explore using a tab control to host multiple subforms on a master form, with pages for shares, children, and department members, and how to tailor links between master and subforms.

Learn to add a bound subreport to a master report, filter it by the current employee, and adjust layout, headers, and linking to show purchases per employee.

Use unbound subreports to combine two unrelated reports into a single master report, one summarizing salary by department and the other total purchases by country.

Discover how Access stores commands as macros that replay on demand, triggered by form buttons, ribbon buttons, or keyboard shortcuts, using the macro list and sample database.

Learn to create macros in Access 2013, including opening forms and reports, choosing window modes, and enabling data entry or read-only experiences.

Learn to trigger macros from Access 2013 form buttons by mapping On click events to specific macros that open forms or reports and close the menu.

Create a new ribbon tab with a macros group, assign macros to icons, and rename them to easily trigger actions such as opening the employee form and running reports.

Use sub macros in Microsoft Access 2013 to group open form actions under a main macro. Create nested sub macros like new employee and assign them to buttons.

Create an auto keys macro in Access to bind function and control keys to run macros, such as f1 for start here and shift-f5 to open the new employee form.

Use macros to open a form or report filtered by a record, building a where condition and passing the identifier to display the selected employee.

Discover how to use if statements in Access 2013 macros to control flow and validate selections before opening forms and reports.

Learn how to use Access macros to run action sql from a macro, including updating salaries via a transaction, suppressing warnings, and triggering macros from a form button.

Add comprehensive comments to macros in Microsoft Access 2013 to explain what each macro and its commands do.

Configure the auto exec macro to run at database startup, show a welcome message, launch the start here macro, and insert a date-time log entry using the now function.

Add an ok/cancel confirmation dialog to Access macros using a form and a yes/no message box; the macro runs only if the user chooses yes, as shown with salary increases.

Discover how to compact and repair an Access 2013 database to reclaim wasted space, reduce file size, and improve speed by automating with macros and an auto exec reminder.

Learn to save an Access 2013 database in older formats, such as 2002-2003 and 2000, using save as, to ensure compatibility with older Access versions.

Back up your Access database easily with save as, using the backup option to create a date-stamped copy in the current location, incrementing when you back up again today.

Explore the object dependency tracking tool in Access to identify how tables, queries, forms, and reports depend on each other, trace data flow, and safely navigate or open linked objects.