Full Day:Upon completion of this course, the students will be able to restructure an existing set of data to improve the design of a database. They will create macros that will improve data entry efficiency and integrity and maintain an Access database by using various utility tools.
Structuring Existing Data • Import Data • Analyze Tables • Create a Junction Table • Improve Table Structure
Writing Advanced Queries • Create Unmatched and Duplicate Queries • Group and Summarize Records Using the Criteria Field • Summarize Data with a Crosstab Query • Create a PivotTable and a PivotChart • Display a Graphical Summary on a Form
Simplifying Tasks with Macros • Create a Macro • Attach a Macro to a Command Button • Restrict Records Using a Where Condition
Adding Interaction and Automation with Macros • Require Data Entry with a Macro • Display a Message Box with a Macro • Automate Data Entry
Making Forms More Effective • Change the Display of Data Conditionally • Display a Calendar on a Form • Organize Information with Tab Pages
Making Reports More Effective • Cancel Printing of a Blank Report • Include a Chart in a Report • Arrange Data in Columns • Create a Report Snapshot
Maintaining an Access Database • Link Tables to External Data Sources • Back Up a Database • Compact and Repair a Database • Protect a Database with a Password • Determine Object Dependency • Document a Database • Analyze the Performance of a Database
"Children have more need of models than of critics." -Sidonie-Gabrielle Colette
Safe Home Connections, a division of KidsTerrain, Inc. assists individuals with the option to age in place, that is, to live in one's home while having access to services and support as needs change.
Webinars are multi-media programs that enable you to view a presentation, lecture, or seminar from the comfort of your office or home. Available 24/7 via the Internet, webinars are an effective alternative to on-site presentations.
