Monday, October 13, 2008

Sample Access Databases From Office Online

I find that looking at a demonstration or sample database is a great way to learn more about Access. Microsoft has some great samples databases here on Micorsoft Office Online. that demonstrate some really neat techniques for forms, reports, and queries.

Here are the tables of contents from the three sample databases:

Forms Reports Queries
  • Using Code to Determine Selected Page of Tab Control
  • How to Disable PAGE UP and PAGE DOWN Keys
  • How to Bring a Subtotal from a Subform to a Main Form
  • How to Start Another Application from a Text Box
  • How to Set Focus to a Subform Using the GoToControl Action
  • How to Use the Callback Property of a Balloon
  • How to Manipulate CommandBar Items
  • How to Move from Subform to Main Form Using TAB or ENTER
  • How to Dynamically Synchronize Two Forms Using Code
  • How to Get the Right and Down Measurements of a Form
  • How to Determine If a Form Is Maximized or Minimized
  • How to Fill Current Record with Data from Previous Record Automatically
  • How to Open Multiple Instances of a Form
  • How to Detect User Idle Time or Inactivity
  • How to Create an AfterUndo Form Event
  • How to Automatically Detect If a Form Is Being Edited
  • How to Display Line Numbers on SubForm Records
  • How to Create a Running Sum
  • How to Use a Toggle Button to Hide and Display a Subform
  • How to Create a Stopwatch Form
  • How to Simulate Drag-And-Drop Capabilities
  • How to Synchronize Two Combo Boxes on a Form
  • Using the Tab Control to View Several Subforms
  • How to Limit the Number of Characters Permitted to the Size of a Text Box
  • Using a Lightweight Form That Contains Hyperlinks
  • How to Hide the Combo Box Drop-Down Arrow
  • How to Export an Object as HTML
  • How to Create an Undo Record Button
  • How to Create an Unbound Form
  • Using an ADO RecordSource
  • Setting Filter, FilterOn from a Popup Form
  • Setting OrderBy, OrderByOn from a Popup Form
  • Setting the Filter Property to a Form's Filter Property
  • How to Reference Parameters in Reports
  • How to Create Fixed-Scale Charts in Reports/Forms
  • How to Print Blank Line Every Nth line in a Report
  • How to Repeat Group Header in a Report
  • How to Print Odd or Even Pages of a Report
  • How to Use Automation to Print Reports
  • How to Create a Table of Contents or Index for a Report
  • How to Print a Constant Number of Lines Per Group
  • Converting Numbers to Words for Check Writing
  • How to Make Empty or Null OLE Object Not Appear on Report
  • Send Fax through MSFax using Code Example
  • How to Skip Used Mailing Labels and Print Duplicates
  • How to Create a Top 10 Report
  • How to Repeat a Subreport's Header When Subreport Spans Multiple Pages
  • Draw Vertical Lines in a Section that Can Grow
  • How to Shade Every Other Detail Line on Reports
  • Using HasData When Referencing a Subreport Control
  • How to Fill Text Boxes on a Report Using Visual Basic
  • Keeping a Subreport or Text Box Together
  • How to Use Visual Basic Code to Collate and Print Two Reports
  • How to Print Line Number for Each Record/Group on Report
  • How to Sum a Column of Numbers in a Report by Page
  • Creating a Top Values Per Group Report
  • Eliminating White Space in Reports with CanShrink & Code
  • How to Specify a Custom Starting Page Number for a Report
  • Page Header That Spans Full Width of Multi-Column Report
  • Send Fax through WinFax using Code Example
  • Using IIf() in Crosstab to Limit Column Headings in a Crosstab Query
  • How to Create a Make-Table Query with a Union Query
  • How to Rank Records Within a Query
  • How to Use a Subquery as Criteria in a Select Query
  • How to Group Column Headings in a Crosstab Query
  • How to Return All Records When Parameter Is Blank
  • How to Sort and Group in a Query Using a Portion of a Field's Value
  • Changing Column Headings in a Crosstab Query Using Code
  • Query by Form (QBF) Using Dynamic QueryDef
  • How to Create an SQL Pass-Through Query in Code
  • Referring to a Field in the Previous or Next Record
  • How to Create a Parameter Query That Accepts a List of Values
  • How to Simulate Parameters in an SQL Pass-Through Query
  • How to Create Running Totals in a Query
  • How to Use a Custom Function in a Query
  • How to Use a Query to Filter Unique Data
  • How to Create a Crosstab Query with Multiple Value Fields
  • How to Create a Union Query
  • How to Create a Join on a Range of Values
  • How to Sort a Query Using an Option Group
  • How to Filter a Query Using an Option Group
  • How to Use the DLookup() Function Inside a Query
  • How to Pull the Second Highest Value from a Table Using a Query
  • How to Group on One Field and Sort on Another in a Query

No comments: