Microsoft Office Tutorials and References
In Depth Information
Creating a Database File
Macros and modules
Macros and modules aren’t covered in this mini-book, but they are also
database objects. A macro is a series of commands. You can store macros
for running queries and doing other Access tasks. A module is a collection of
Visual Basic procedures and declarations for performing tasks in Access.
Creating a Database File
Creating a database is a lot of work, at least in the beginning. You have to
design the database (a subject that I explain shortly). You have to enter the
raw information into the tables. You have to construct queries that allow
yourself and others to read meaning into the data (see Chapter 4 of this
mini-book). By contrast, creating a database file for storing the information
is the easy part.
Access offers two ways to create a new database file. You can do it from
scratch or get the help of a template. With a template, some of the work is
done for you. The template comes with prefabricated queries, forms, and
reports. However, templates are for people who already know their way
around Access databases. To make use of a template, you have to know how
to modify a pre-existing database.
Book VII
Chapter 1
Before you create a database file, start by deciding where in your computer
to store it. Unlike other Office programs, Access requires you to save and
name a new database file as soon as you create it.
Creating a blank database file
Follow these instructions to create a blank database file:
1. On the File tab, choose New.
The New window appears.
2. Click the Blank Database icon.
A dialog box appears for choosing the folder where you will store your
new database.
3. Click the Browse button.
You see the File New Database dialog box.
Search JabSto ::




Custom Search