Module 1 - Introduction to MS Access Databases

	Begin your MS Access experience with an informative introduction to the MS Access interface.
	Cover the essential tools, learn to navigate around the software, use the quick access toolbar, the Ribbon, and opening the database correctly.
	Uncover the basics of opening a new database, using database templates and closing and exiting the MS Access program correctly.

Module 2 - Tables pt. 1

	You'll start with an introduction to tables, how to create tables and how to save tables.
	You'll learn to create tables via datasheets, viewing data, adding data to the table and how to move the columns in the data sheet.
	I'll demonstrate creating new columns, adjusting width, renaming columns, inserting and deleting columns, copying columns and hiding/unhiding columns.
	You'll learn the various ues of tables to manage data fields, create database relationships, create primary keys, use foreign keys and look at why you should use auto numbers.

back to main page

Module 3 - Tables pt. 2

	Here we'll examine relationships - this useful section will show you relationship diagrams, relating tables, deleting relationships and what 'many to many' relationships are.
	Here we'll cover how to work with data types - move columns in design table view, rename tables, copy tables and print tables.
	Access is all about data and I'll cover the essentials of entering data into the datasheet, selecting rows, deleting data & rows and using scroll bars & navigation buttons.

Module 4 - Tables pt. 3

	See how to manage records by using datasheet filters, using datasheet filtering by form, finding and replacing data, copying records, learning to format fields, create Input Masks, make table fields require data, index to prevent duplicate entries and set defaults to eliminate typing errors.
	Understand how to create data validation rules, lookup fields, select multiple lookups and create custom lookup lists.

back to main page

Module 5 - Tables pt. 4

	Edit data by using autocorrect options, add, edit, copy & paste data and relocate, insert, rename, copy & delete columns, plus change column row height & width.
	Conclude this module with creating append only memo fields, memo fields that prevent deletion of existing data and look at creating attachment fields & sub datasheets.

Module 6 - All about building forms

	In this lesson I'll show you how to create a simple form, use the wizard to create a form and work in form design view for custom forms.
	You'll discover how to create a multiple-items form, add form controls, use controls wizard and delete controls.
	See how to correctly use form labels, control form properties and create sub forms.
	You'll see an overview of Access controls and a demonstration of how to add and use a date picker calendar control.
	Learn how to create a sub form and a split form.
	I'll show you the difference between a list box and a combo box.
	Last of all, be sure you have total control of your data when I show you how to set up and use an option group control.

back to main page

Module 7 - The power of queries

	Reviewing your data is the focus of this module and I'll demonstrate everything you need to know about queries.
	You'll know how to create a query using the wizard, how to create a detail query, how to create a summary query, the different uses of queries, different types of query data and how to use wildcards in a query.
	Through this module you'll come to know how to work in the query design view, adding tables and fields to the query, saving queries, using AND OR, creating calculated queries and using function queries.

Module 8 - More on Grouping & Queries

	In this lesson I'll demonstrate how to use grouping, how to use a grouping sum and advanced grouping.
	You'll learn the ins and outs of using the query expression builder, how to use sorting in a query, inner and outer query joins and how to create a parameter query.
	Continuing with queries, you'll understand how to create a make table query, an update query, a delete query, an append data query and a crosstab query.
	Finally, we'll cover how to use the query to find the highest and lowest values, the top 10 records and how to find duplicates and unmatched records in the database.

back to main page

Module 9 - Using Access to create reports

	In this video you'll learn how to manually create a report, how to create summary reports, how to create a report using the wizard and how to create a sub report.
	You'll see a demonstration of working in report layout view, how to modify an existing report and learn how to create a calculated field in the report.
	I'll show you how to use wizard grouping, work with grouping levels, reorder and delete grouping levels and create mailing labels.

Module 10 - Enhance forms and reports

	In this video I'll show you how to create quality reports from your data.
	In this module see how to bold text, underline and use auto format on your text.
	Here we'll cover positioning of text, vertical and horizontal alignment and how to use conditional formatting.
	You'll know how to change the background colors, fore colors and how to include lines, borders and back colors.
	Here you'll know how to include special effects, use gridlines and how to color alternate rows.
	Finally, I'll help you with a demonstration of how to total a datasheet, how to add, embed or link to a picture and how to work with an image.

back to main page

Module 11 - Create charts for reporting and easy interpretation of your data

	Bring your reports to life with charts - you'll have the means to do so when you complete this module that shows you how to create charts.
	You'll learn how to format chart elements and change the number format.
	See demonstrations showing you precisely how to customise the chart Axes, change the chart gridlines and switch between using pie charts, bar charts or both.
	Learn how to include a quality chart legend and how to alter the chart text box.

Module 12 - Get MS Access working harder - use a range of tools to manage your data and interact with other programs

	Learn how you can embed, link objects and manipulate objects in MS Access.
	Watch demonstrations on inserting an Excel chart & worksheet, importing tables from other databases and link to tables in other databases.
	Master the creation and use of hyperlinks.
	Import data into MS Access from Excel, text files and xml data.
	Manage the exporting of data by sending to other databases as text or xml.
	See how you can save an object from MS Access as a web file
	Interact with other MS Office programs, uncovering the ins and outs of analyzing MS Access data with Excel, publishing MS Access data using Word and using Outlook to collect data from email messages and import it to MS Access.

back to main page

Module 13 - Administer a database

	Managing the database and allowing user access is a crucial factor - and this is what we'll cover in this module.
	Learn how to set and remove user passwords.
	Manage locking of database records.
	Uncover the means of creating a switchboard.
	Establish your database start-up option and document your database accurately.

Module 14 - Customizing MS Access

	Learn how you can customize the program to more efficiently manage your individual database needs.
	Macros are one of the key tools for customizing your database, learn how to create them, step through a macro, create macro groups and run your macros from screen form buttons.
	I'll demonstrate how you can add or delete macro steps, add buttons on your quick access toolbar and create macro message boxes.
	Manage your options correctly to present your data more dynamically and use the Autocorrect options available in MS Access.

back to main page

Module 15 - Presenting data dynamically

	In this module I'll help you to be sure you present the data you have collated in your database more dynamically.
	You'll learn to demonstrate the options available to you to harness the power of Pivot Tables and to create outstanding Pivot Charts.

Module 16 - Additions

	We'll conclude the course with a breakdown of how you do those last few things to get the most from your database.
	We'll cover the steps you can take to split your Access database.
	You'll learn the important aspects of how to backup an Access database, so you can preserve your information.
	Learn the essentials of protecting your data with an ACCDE file and what different database security warnings mean, as well as how to set up trusted locations.
	Here you'll learn to save your MS Access documents in PDF format and how to incorporate rich text boxes.
	Complete the Access Mastery program with a look at using Access to analyze and improve your data.

$79.77