|
Access 2003 Advanced Level SeminarFull 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
Download this outline as a PDF.
|

|
|