Database Reference
In-Depth Information
Create databases and
2
simple tables
IN THIS CHAPTER, YOU WILL LEARN HOW TO
Create databases from templates.
Create databases and tables manually.
Manipulate table columns and rows.
Refine table structure.
Deine relationships between tables.
Microsoft Access 2013 takes a lot of the difficult and mundane work out of creating and
customizing a database by providing database templates. Access also provides templates
for common elements that you might want to plug into a database. These application parts
consist of sets of objects—a table and related forms, queries, or reports—that together
provide a complete, functioning part of a database, ready for you to customize. If none of
the templates meet your needs, you can create databases manually. However, an empty
database is no more useful than an empty document or worksheet. It is only when you fill
a database with data (referred to as populating a database ), that it starts to serve a purpose.
In this chapter, you'll examine web app templates and create a desktop database from a
template. You'll also create a table manually. Next, you'll adjust the display of a table to
meet your needs. Finally, you'll define relationships between tables. By the end of this
chapter, you'll have a desktop database that contains a few tables and you'll understand
a bit about how the database tables you will use for the exercises in the remaining chap-
ters of the topic were created.
PRACTICE FILES You don't need any practice files to complete the exercises in this chapter.
 
Search WWH ::




Custom Search