Become familiar with the arrangement of the Access
screen, the components of a database, and how to get help when necessary. Learn the recognized approach for planning a
database, then create the basic structure.
- Become familiar with the various aspects of the Access
screen, specifically the Database window which contains the various
components of an Access database. Consult the Help Task Pane and the
Question Help Box for assistance when necessary, and learn the nature of
naming database components so that they are recognizable at a glance and
provide stability to your database.
- Use the seven recognized steps of database planning to
lay the groundwork for your database, making database creation almost a
formality. Create the actual database either from scratch or by
using any of Access’ built-in templates, and explore the two basic ways to
view database structure and data.
Basic Table Structure, Part One
planned and created your database, begin adding or editing tables, which will
store data. Next, tell Access how the
new tables relate to each other and begin entering data.
- Create tables either by using a wizard or from scratch,
and tell Access which fields are unique in order that table relationships
can be established.
- Having created the tables that contain will your data,
tell Access how these tables relate to each other. Having done so,
you can create queries, forms, and reports to display information from
several tables at once. Finally, use Datasheet view to begin
& Controlling Table Data, Part Two
way Access stores, handles, and displays table information, using special
formatting to facilitate data entry and minimize error.
- Set the format for dates and times (such as January 1,
2006, 01-05-2006, etc.), create captions that make the screen more
visually appealing (First Name vs. fname), tell Access whether or not
users will need to search on the field and thereby speed the process of
locating data, and more.
- Facilitate data consistency and ease of entry by
customizing fields with Input Masks (which format data automatically, such
a phone number or zip code) and Lookup Columns (which turn a field into a
drop-down menu of choices). Keep related information one click away,
eliminating the need to open the related table directly.
you to ask questions of the information in your database. Explore the four approaches to asking such
- Create a basic query from scratch and save it for
future use, and use two of Access’ built-in wizards to make creating basic
queries quickly, easily, and accurately.
- Use various techniques to enter criteria into
particular query fields, allowing you to hone in precisely on records you
need to see in a given moment.