ACC95: Comparison of v. 2.0 and 95 Wizards, Builders, & Add-ins

• Microsoft Access version 7.0

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

This article compares the add-ins, builders, and Microsoft Access Wizards in Microsoft Access version 2.0 and Microsoft Access version 7.0. It also provides an overview of each new add-in, builder, and wizard with a brief description of its purpose in Microsoft Access 7.0.

MORE INFORMATION

Name in Version 2.0            Name in Version 7.0

Add-in Manager                 Add-in Manager

Add-ins                        Add-ins

Archive Query Wizard           <Not Available>

Attachment Manager             Link Table Manager

AutoDialer                     AutoDialer

AutoForm                       AutoForm: Columnar
                               AutoForm: Tabular
                               AutoForm: Datasheet

AutoReport                     AutoReport: Columnar
                               AutoReport: Tabular

Code Builder                   Code Builder

Color Builder                  Color Builder

Combo box Wizard               Combo box Wizard

Command button Wizard          command button Wizard

Crosstab Query Wizard          Crosstab Query Wizard

Database Documentor            Documentor

Expression Builder             Expression Builder

Field Builder                  Field Builder

Find Duplicates Query Wizard   Find Duplicates Query Wizard

Find Unmatched Query Wizard    Find Unmatched Query Wizard

Graph Wizard                   Chart Wizard

Groups/Totals Report Wizard    Report Wizard

Import Database Add-in         Import Table Wizard

Input Mask Wizard              Input Mask Wizard

List Box Wizard                List Box Wizard

Macro Builder                  Macro Builder

Mailing Label Report Wizard    Label Wizard

Main/SubForm Wizard            Form Wizard

Menu Builder                   Menu Builder

Microsoft Word Mail            Office Links command

ODBC Connection                ODBC Connection
String Builder                 String Builder

Option Group Wizard            Option Group Wizard

Picture Builder                Picture Builder

Query Builder                  Query Builder

Single-Column Form Wizard      Form Wizard

Single-Column Report Wizard    Report Wizard

Summary Report Wizard          Report Wizard

Table Wizard                   Table Wizard

Tabular Form Wizard            Form Wizard
                               AutoForm: Tabular

Tabular Report Wizard          Report Wizard
                               AutoReport: Tabular

Wizards Customizer             <Not Available>

Zoom box                       Zoom box

New Features in Microsoft Access 7.0

Name                           Description of Purpose

Conflict Resolver              Resolves conflicts that occur during
                               synchronization of replicated databases.

Database Splitter Add-in       Splits a database into two .mdb files: one
                               for tables and one for queries, forms,
                               reports, macros, and modules.

Database Wizard                Creates a new database for business or
                               personal use. You can choose from over 20
                               types of databases.

Import Spreadsheet Wizard      Helps you import spreadsheet data by
                               choosing data types, date formats, and so
                               on.

Link Child/Link Master         Helps you link subform or subreport data to
Builder                        the main form or report.

Macro to Visual Basic          Converts macro actions to Visual Basic for
for Applications Converter     applications code.

Performance Analyzer Wizard    Analyzes any object in your database and
                               suggests changes you can make to improve
                               performance.

Pivot Table Wizard             Creates a control on a form that enables
                               you to summarize data using a format and
                               calculation method you choose.

Simple Query Wizard            Creates single-table and multiple-table
                               queries.

Subform/Subreport Wizard       Creates subform and subreport controls.

Switchboard Manager Add-in     Creates a switchboard form for easy
                               navigation of your forms and reports.

Table Analyzer Wizard          Normalizes your tables to optimize
                               relational databases capabilities.

Text Export Wizard             Helps you import and export text data by
                               choosing field delimiters, data types, and
                               so on.

User-Level Security Wizard     Gets you started securing a database by
                               copying all objects to a new database,
                               revoking Users group permissions, and
                               encrypting the database file.

REFERENCES