-
Data Validation
Microsoft Access 2013 lets you create validation rules to help improve the accuracy of your tables by restricting input in table fields. In this video; Gary Leenhouts demonstrates how to use Access to create rules for validating fields within a table and create display messages for input that is not valid.
-
Enforcing Referential Integrity
As with any relational database; Microsoft Access 2013 lets you create specific relationships between tables and fields. There are a set of rules; also known as referential integrity; that ensure the table relationships are enforced. In this video; Lynn Tao demonstrates this concept and how to apply it in Access 2013.
-
Export Data from Access
Microsoft Access 2013 enables you to export Access data to other applications better able to manipulate it. In this video; Gary Leenhouts uses Access 2013 to export an Access query as a Microsoft Excel workbook to an external location.
-
Find Duplicates Query Wizard
Microsoft Access 2013 finds duplicates easily with its query wizard to keep redundant data out of your database. In this video; Lynn Tao demonstrates how to create a Duplicates query in Access 2013.
-
Find Unmatched Query Wizard
Microsoft Access 2013allows you to find unmatched records easily with its query wizard. In this video; Lynn Tao demonstrates how to create a Find Unmatched Query Wizard in Access 2013.
-
Hiding and Freezing Fields
Microsoft Access 2013 has features that let you manipulate the visibility of fields and columns. In this video; Lynn Tao discusses how to use these features by freezing / unfreezing and hiding / unhiding columns and fields.
-
Import Data to Access
Microsoft Access 2013 enables you to import data - by linking; appending; or creating a new file; from external storage locations in different formats; into your existing tables. In this video; Gary Leenhouts demonstrates how to import and append data from an Excel spreadsheet to an existing table.
-
Lookup Fields
Microsoft Access 2013's Lookup wizard eases data entry and enables you to create table relationships by listing predefined values for fields. In this video; Gary Leenhouts uses the Lookup Wizard to insert a lookup field; containing predetermined values; from one linked database table into another.
-
Multiuser Apps – Locking Splitting
Microsoft Access 2013's Database Splitter Wizard enables you to separate your database into a front-end interface database file containing non-configurable design elements; queries; forms; reports; and macros and a linked back-end file storing your table or other data. This conserves space and resources; and enhances security. In this video; Gary Leenhouts uses the Database Splitter Wizard to split a database.
-
Optimize Database – Analyze Performance
Microsoft Access 2013's Performance Analyzer reveals how a database's many objects are working together; recommends structural improvements; and accepts suggestions before allowing you to fix and optimize the database. In this video; Gary Leenhouts demonstrates how to run database tables through Access 2013's Performance Analyzer; and then selects Ideas and Analysis Notes for review.
-
Optimize Database – Analyze Table
Microsoft Access 2013's Table Analyzer Wizard enables you to test table data; normalize it by implementing recommended changes; and generate a query enabling forms and reports based on your original table to retain their functionality. In this video; Gary Leenhouts uses Access's Table Analyzer Wizard to identify issues; carry out several recommended changes; and generate a query.
-
Optimize Database - Compact and Repair
The Microsoft Access 2013 compact and repair feature helps you maintain optimal performance in your database by eliminating unused space; as well as attempting to recover corrupted files. In this video; Gary Leenhouts uses the Compact and Repair Database tool to schedule maintenance on a database and reduce the size of files.
-
Optimize Database – Database Documenter
Microsoft Access 2013's customizable Database Documenter enables you to document database object revisions and changes; and generate a detailed; printable report. In this video; Gary Leenhouts uses Access 2013's Database Documenter to generate and review a report on all object types in an Access database.
-
Sharing Access Databases
Microsoft Access 2013 enhances database security by allowing you to open Access databases in modes appropriate to their use. These modes include Open; Open Read-Only; Open Exclusive; and Open Exclusive Read-Only. In this video; Gary Leenhouts discusses the different mode in which databases can be viewed.
-
Splitting a Database
Microsoft Access 2013 allows you to split a database to improve its performance and minimize the chance of data corruption. In this video; Lynn Tao will discusses how to split a database.
-
Access and SharePoint
Microsoft Access 2013 makes it easy to collaborate with users of SharePoint sites by allowing you to export a copy of a selected database object and storing the copy as a list in SharePoint. In this video; Gary Leenhouts uses the Export Wizard in Access to export a table to a SharePoint site as a list.
-
Access and SharePoint - Import
Microsoft Access 2013 allows you to take lists from SharePoint and either creates copies of the lists in Access by importing the data or connects to the data by linking to it. In this video; Gary Leenhouts uses the Import Wizard in Access 2013 to create a link between Access and a SharePoint list.
-
Access and SharePoint - Moving Data to SharePoint
Microsoft Access 2013 lets you move all your data to a SharePoint site to be displayed as lists in SharePoint that are linked back to the existing database. In this video; Gary Leenhouts uses the Export Tables in SharePoint Wizard to move the tables in an Access database to a SharePoint site.
-
Access Data Email and Outlook – Export
Microsoft Access 2013 interacts with your Outlook e-mail client to allow you to distribute Access data in multiple formats to your Contacts lists. In this video; Gary Leenhouts uses the E-mail feature to exploit Access 2013's integration with Microsoft Outlook and e-mail information; already attached as an Excel Workbook; to another user.
-
Access Data Email and Outlook – Import
Microsoft Access 2013's integration with Microsoft Outlook enables you to link to; append; or import information from your Contacts folder. In this video; Gary Leenhouts uses the Import Exchange/Outlook Wizard to create a live lookup by linking to and naming an Outlook Contacts folder; which presents as a table in Access.
-
Access Event Model
Microsoft Access 2013 enables you to construct user-friendly interfaces from forms containing controls incorporating configured events or user-triggered actions. In this video; Gary Leenhouts uses Access 2013's Builder tool to configure several form controls' user-triggered actions or events; before saving and demonstrating their use.
-
Action Queries – Append Query
Append queries in Microsoft Access 2013 are a subtype of action queries and are used to select data from one or more data sources before copying the selected data to an existing table. In this video; Gary Leenhouts uses the append query type in Access 2013 to produce a query that adds records to an existing table.
-
Action Queries - Delete
Delete queries in Microsoft Access 2013 are a subtype of action queries that allow you to delete data in a table based on specific criteria. In this video; Gary Leenhouts uses the delete query option in Access 2013 to set criteria; whereby specific rows of data are deleted from a table.
-
Action Queries - Make Table
Make tables in Microsoft Access 2013 are typically used to retrieve data from one or more tables and place the data in another table in order to make a copy or archive data. In this video; Gary Leenhouts demonstrates how to extract information from a table and place it in new table in Access 2013.
-
Action Queries - Update
Update queries in Microsoft Access 2013 are a subtype of action queries and are used to change existing data in your tables. In this video; Gary Leenhouts uses the update query option from the DESIGN tab within the QUERY TOOLS tab to write an update expression in Query Builder in order to change the list prices in a table.
-
Archiving a Table
In Microsoft Access 2013; you can archive a table without using queries or macros. In this video; Lynn Tao demonstrates how to archive an entire table.
-
Archiving All Tables
Microsoft Access 2013 lets you replace all tables by replacing the backend database with an empty copy for archiving purposes. In this video; Lynn Tao demonstrates how to archive all tables in a database.
-
Archiving Records
Microsoft Access 2013 helps you organize large amounts of data by archiving older and active data. In this video; Lynn Tao demonstrates how to archive records.
-
Attachments
Microsoft Access 2013 lets you add attachment fields to your tables; allowing you to efficiently store different file types in a single field. In this video; Gary Leenhouts demonstrates how to add an attachment field into an Access table; as well as how to attach and manage files.
-
Conditional Formatting
Microsoft Access 2013 conditional formatting lets you format data in your forms and reports based on certain criteria; providing an easy way to highlight and display differences in data. In this video; Gary Leenhouts uses the Conditional Formatting option in Access 2013 to specify a formatting rule and set the formatting for a specified object within a report.
-
Creating a Crosstab Query
In Microsoft Access 2013; the crosstab query allows you to summarize information by grabbing data from different tables and organizing into a spreadsheet-like format for easy reading and reference. In this video; Lynn Tao demonstrates how to create a crosstab query in Access 2013.
-
Creating a Parameter Query
Microsoft Access 2013 allows you to prompt for values to include in a query which helps to run different variations with the same query. In this video; Lynn Tao demonstrates how to create a parameter query in Access 2013.
-
Customizing Fields
Microsoft Access 2013 makes it possible to customize fields to suit specific needs. In this video; Lynn Tao discusses how to customize fields by making it Required; changing the data types; field captions; Field Width; and the Default Value.
-
Customizing the Default Format of Datasheets
Microsoft Access 2013 is a great tool to customize the datasheets which will be more personalized and will visually stand out. In this video; Lynn Tao will demonstrate how to customize the default datasheets.
-
Customizing the List of Recently Opened Databases and Folders
In Access 2013; you can modify the number of databases and folders you want to be displayed as well as pin folders or include recent databases for quick access. In this video; Lynn Tao discusses how to customize the list of recently opened databases and folders.
-
Customizing the Ribbon and Quick Access Toolbar
Microsoft Access 2013 has features that help you customize its default interface. In this video; Lynn Tao will show how to personalize the Ribbon and the Quick Access Toolbar to make commonly used commands more accessible.
-
SQL Queries
Structured Query Language; or SQL; is what Microsoft Access 2013 uses when building any query. By having an understanding of SQL; you will be able to build and edit queries directly in the SQL window. In this video; Gary Leenhout uses Query Builder to create a query before explaining the syntax behind the query while in SQL View.
-
Subforms
In Microsoft Access 2013; you can use subforms; which are forms that are inserted in other forms; as a convenient way of displaying data between tables or queries that have a one-to-many relationship. In this video; Gary Leenhouts uses the Subform Subreport control in Access 2013 to embed a subform into a form.
-
Subreports
You can use subreports in Microsoft Access 2013; which are reports inserted in other reports; to display data from more than one table in a logical way in the same report. In this video; Gary Leenhouts uses the Subform Subreport control in Access 2013 to insert a report into another report to express a one-to-many relationship between two tables.
-
User Interface Macros
Microsoft Access 2013's macros ease and regulate data entry by automating interaction with the user interface through events customized in the Macro interface. In this video; Gary Leenhouts uses the Macro interface's Expression Builder to configure actions governing selected form field events.
-
VBA in Access
Microsoft Access 2013's embedded programming language; Microsoft Visual Basic for Applications (VBA) enables you to program the user interface through the macro tool. In this video; Gary Leenhouts uses Access 2013's Design view to open a macro and introduce the blocks of code making up submacros; which can be run independently when called from within form events.
-
Package and Sign Tool
Microsoft Access 2013's Package and Sign tool enables you to package and attach a secure digital signature to a database when deploying it into a production environment. In this video; Gary Leenhouts uses the Package and Sign tool to package a selected database and attach a certificate to it.
-
Proofing with AutoCorrect and Spelling
Microsoft Access 2013 has features to correct spelling and grammar inaccuracy. In this video; Lynn Tao discusses AutoCorrect; Spell Check and their associated tools.
-
Restricting Changes to the Front-end Database
Access 2013 allows you to save your databases in a compiled binary file or an ACCDE file that restrict design changes while still allowing you to edit the data. In this video; Lynn Tao discusses how to restrict design changes to front-end databases in Access 2013.
-
Creating a Web Query
In Microsoft Access 2013; the Web query allows you to grab any external data from web pages and web sites in plain text format. In this video; Lynn Tao demonstrates how to create a Web query in Access 2013.
-
Joins
Microsoft Access 2013 uses joins as a method of connecting multiple data sources; in order to perform a query based on the combined data values of the different sources. In this video; Gary Leenhouts performs a query on two related tables before demonstrating how to change the join between them and alter the query.
-
Security
Microsoft Access 2013 enables you to encrypt and password protect your organization's databases – in exclusive use mode – for secure use by individuals using mobile devices. In this video; Gary Leenhouts opens a database in Exclusive mode; uses the Encrypt with Password feature to set a password; and tests its encryption.
