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
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.
