Sample Access databases that you can download and adapt

Applies to
Microsoft Office Access 2003
Microsoft Access 2000 and 2002

One of the best ways to put Access to work is to adapt an existing database or database object (database objects: An Access database contains objects such as tables, queries, forms, reports, pages, macros, and modules. An Access project contains objects such as forms, reports, pages, macros, and modules.) to suit your needs. To help you be more productive, the Access team provides a number of databases that you can download and adapt for your own use.

 Tip    Try Office 2010 Access 2010 features 5 web database templates that you can publish to a SharePoint server that is running Access Services, and then use in a browser.
Read an article or try Office 2010!

Database of Access 2000 sample forms

The sample forms (form: An Access database object on which you place controls for taking actions or for entering, displaying, and editing data in fields.) in this database demonstrate a variety of form types and techniques, including how to manipulate data, use controls (control: A graphical user interface object, such as a text box, check box, scroll bar, or command button, that lets users control the program. You use controls to display data or choices, perform an action, or make the user interface easier to read.), and create undo and redo operations.

Download the sample forms database

ShowWant to make sure this download is right for you? Here's a list of all the sample forms.

  • Automatically detect if a form is being edited
  • Bring a subtotal from a subform to a main form
  • Create a running sum
  • Create a stopwatch form
  • Create an AfterUndo form event
  • Create an unbound form
  • Create an Undo Record button
  • Create user idle time or inactivity
  • Determine if a form is maximized or minimized
  • Disable PAGE UP and PAGE DOWN keys
  • Display line numbers on subform records
  • Dynamically synchronize two forms using code
  • Export an object as HTML
  • Fill current record with data from previous record automatically
  • Get the right and down measurements of a form
  • Hide the combo box drop-down arrow
  • Limit the number of characters permitted to the size of a text box
  • Manipulate CommandBar items
  • Move from a subform to a main form using TAB or ENTER
  • Open multiple instances of a form
  • Set focus to a subform using the GoToControl action
  • Simulate drag-and-drop capabilities
  • Start another application from a text box
  • Synchronize two combo boxes on a form
  • Use a toggle button to hide and display a subform
  • Use the Callback property of a balloon
  • Use a lightweight form that contains hyperlinks
  • Use an ADO record source
  • Use code to determine the selected page of the Tab control
  • Use the Tab control to view several subforms

ShowHow to use the sample forms database

When you open the sample forms database, a switchboard appears. You can view all the sample forms or sort them by category. When you select a form, the switchboard displays a list of the database objects that the form uses, plus a link to a corresponding Knowledge Base article, if one exists. To use a form, select it and click Display Selected Sample.

The sample forms switchboard

Database of Access 2000 sample reports

The sample reports (report: An Access database object that you can print, which contains information that is formatted and organized according to your specifications. Examples of reports are sales summaries, phone lists, and mailing labels.) in this database demonstrate a number of techniques, including how to shade every other row or every nth row in a report, how to create a table of contents or an index for a report, and how to create a top 10 report.

Download the sample report database

ShowWant to make sure this download is right for you? Here's a list of the sample reports.

  • Convert numbers to words for check writing
  • Create a top-values-per-group report
  • Draw vertical lines in a section that can grow
  • Eliminate white space in reports with CanShrink and code
  • Create a table of contents or index for a report
  • Create a top 10 report
  • Create fixed scale charts in reports and forms
  • Fill text boxes in a report using Visual Basic
  • Make an empty or null OLE object not appear on a report
  • Print a constant number of lines per group
  • Print blank lines every nth line in a report
  • Print line numbers for each record or group in a report
  • Print the odd or even pages in a report
  • Reference parameters in reports
  • Repeat a subreport's header when the subreport spans multiple pages
  • Repeat a group header in a report
  • Shade every other detail line in a report
  • Skip used mailing labels and print duplicate labels
  • Specify a custom starting page number for a report
  • Sum a column of numbers in a report by page
  • Use automation to print reports
  • Use Visual Basic code to collate and print two reports
  • Keep a subreport or text box together
  • Create a page header that spans the full width of a multi-column report
  • Send a fax through MSFAX using code
  • Set Filter and FilterOn from a pop-up form
  • Set OrderBy and OrderByOn from a pop-up form
  • Set the Filter property of a report to a form's Filter property
  • Use HasData when referencing a subreport control

ShowHow to use the sample reports database

When you open the sample reports database, a switchboard appears. You can view all the sample reports or sort them by category. When you select a report, the switchboard displays a list of the database objects that the report uses, plus a link to a corresponding knowledge base article, if one exists. To use a report, select it and click Show Example.

The sample reports switchboard

Database of Access 2000 sample queries

The sample queries (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form or report.) in this database demonstrate a number of querying techniques, including how to rank records within a query, how to group one set of records and sort on another, and how to use custom functions in queries.

Download the sample query database

ShowWant to make sure this download is right for you? Here's a list of the sample queries.

  • Create a make-table query with a union query
  • Change column headings in a crosstab query using code
  • Create a crosstab query with multiple fields
  • Group column headings in a crosstab query
  • Use IIF() in crosstab queries to limit column headings
  • Create a join on a range of values
  • Create a parameter query that accepts a list of values
  • Filter a query using an option group
  • Return all records when a query parameter is blank
  • Sort a query using an option group
  • Sort and group in a query using a portion of a field's value
  • Use a custom function in a query
  • Use a query to filter for unique data
  • Use a subquery as a criterion in a Select query
  • Use the DLookup() function inside a query
  • Query by form using Dynamic QueryDef
  • Refer to a field in the previous or next record
  • Create an SQL pass-through query using code
  • Simulate parameters in an SQL pass-through query
  • Create a union query
  • Create running totals in a query
  • Group on one field and sort on another in a query
  • Extract the second-highest value from a table using a query
  • Rank records within a query

ShowHow to use the sample queries database

When you open the sample queries database, a switchboard appears. You can view all the sample queries or sort them by category. When you select a query, the switchboard displays a list of the tables and other database objects that the query uses, plus a link to a corresponding knowledge base article, if one exists. To use a query, select it and click Show Example.

The sample queries switchboard

 
 
Applies to:
Access 2003