Microsoft Office Tutorials and References
In Depth Information
Creating a Database
3. Click a template, choose a folder location and a name, and click
Choosing the folder and name works the same way as it does for
creating a new, blank database as described in the previous section.
4. If Access protects you from possible malicious code (which it will do
if the template contains any active content at all), click the Enable
Content button to unleash the full functionality of the database.
For some templates, a helpful training video may pop up, compliments
of Microsoft. You can decide whether to watch it or go directly to the
5. Prowl around the database, looking at the tables to see whether the
design will work for you.
Use the Navigation pane, described in Chapter 2 of this minibook, to see
the tables. Open each table in Design view to see a list of the fields and
their field types.
6. Change the design as needed.
Book II, Chapter 1 describes how to change the design of an existing
table. You can rename tables and fields, add fields that the template
doesn’t include, and delete fields that you don’t think you’ll need.
If you make a new database from a template, and the template turns out not
to be useful for you, you can always delete the database and try another
template, or start from scratch.
Analyzing and documenting your table design
Access comes with a wizard that can eyeball
your database design, looking at the way that
you divide your information into related tables.
Specifically, it helps you fix a table that
contains repeated values in some fields, splitting
the table into two or more related tables. The
Table Analyzer Wizard walks you through the
process, creating the new tables and moving
the fields and values. To run the wizard, click
the Analyze Table button in the Analyze group
on the Database Tools tab of the Ribbon.
Another Access feature can provide
documentation on almost any aspect of your new
database, helping you track the changes made
in your database and providing information
to your users. The Documenter allows you to
select the components of your database for
which you want to create documentation and
then creates that documentation
automatically. It even allows you to select the format in
which that documentation is stored. To run the
Documenter, click the Database Documenter
button in the Analyze group on the Database
Tools tab of the Ribbon.