Microsoft Office Tutorials and References
In Depth Information
Creating a Database
5. Create your tables.
Book II, Chapter 1 tells you how to create tables. You define each of
the fields in the database, including the field name, data type, and field
6. Create relationships among the tables.
Making relationships is described in Book II, Chapter 6. Access displays
a Relationships window that draws lines between related tables, like the
diagram shown in Figure 3-5, earlier in this chapter.
You can always rename the database later. Close the database, and run
Windows Explorer. If you have Windows 7 or an older operating system, do
this by double-clicking My Computer on the desktop or choosing Start ➪ All
Programs ➪ Accessories ➪ Windows Explorer. Navigate to the folder that contains
the database, find and select its filename, press F2, and type a new name for
the database file. You can’t rename an Access database within Access. If you
have Windows 8, just navigate to the folder that contains the database and
rename it the same way you do in the earlier Windows environments.
If you have Windows 8, click the Folders icon at the bottom of your screen to
display Windows Explorer.
When you create a database, Access uses the newer .accdb format that was
introduced with Access 2007 unless you tell it to use the older .mdb format.
Note that Access 2003 and older versions can’t open .accdb-format
databases; if you try, you’ll just get an error message.
Creating a new database from a template
Access comes with a bunch of templates — databases that already include
tables and relationships but no data. You also get queries, forms, and reports —
very handy! If you’re creating a database for a purpose for which Microsoft
has designed a template, you can use the template to provide the initial design
and then make changes to adapt the objects in the database for your own
use. Looking at Microsoft’s templates is a good way to get design ideas, too.
To create a database from a template, follow these steps:
1. Click the File tab on the Ribbon, click New, and look through the
You see buttons for several templates.
2. If you don’t see what you want, type a template category ( Assets ,
Business , Contacts , and so on) in the Search Online Templates search
box, and click the magnifying-glass icon.
Access displays a more-targeted set of templates in your chosen category.