hmm think about all the information you
come across in a typical day for example
if you go shopping at a department store
for a toaster the stores inventory of
products this information that has to be
stored somewhere along with the price of
each product and when you do make a
purchase the store has to be able to
store the sales information so they can
keep a record of how much money they
make and how the inventory is affected
available allows them to quickly
determine how many brand X toasters they
have without needing to count the
inventory on the shelves even in this
simple everyday life situation there is
a lot of data luckily we have databases
that help us manage this information
databases have an enormous impact in
almost every area of our lives think
about what is going on around you in
everyday situations and whether there
might be a database at work for example
the supermarket is stocked with items
the items have to be ordered shipped and
stocked in the store the supermarket has
to pay for those items then when the
customer buys the items the cash
register looks up prices and the
customer pays for products where my
databases be involved in this situation
what about a restaurant where does the
food come from or the traffic lights in
your city who are what controls when
they turn red or green advaita base
maintains order and structure in our
lives
databases are created using programs
such as Microsoft Office access 2007
which is a relational database program
this means that the database arranges
information in multiple tables which
makes maintaining easier and allows you
to do more with the information let's
take a look at they're ready to read
database
when you start access 2007 you will see
the getting started page and the left
pane you have the template categories
including the feature templates and the
local templates as well as the
categories or an office online templates
are pre-built databases focus on a
specific task you can download and use
them immediately
right now the featured templates are
selected so in the center area of the
screen we see the online feature
templates and above that the blank
database commands that we could use if
we wanted to create a database from
scratch to see templates that are parts
of access just click local templates in
the left pane and the screen will change
some of these are the same as the online
feature templates but are already parts
of your version of access additionally
in the rites pane you'll see a list of
recently viewed databases from this pane
you can open an existing database which
is what I'll do now I have the ready to
read database on my computer so I'll
just click ready to read now we are
actually looking at the database let me
show you around this Access database so
you can become familiar with the access
environment instead of traditional menus
Access 2007 has a tabs ribbon system
that you can use to navigate and use the
software this is the same ribbon system
that is parts of all the office 2007
applications the ribbon is organized
into tabs each tab contains commands
that are arranged into logical groups
for example on the Home tab you'll see
that there is a fonts group that
contains the fonts formatting commands
such as font type size color alignment
and more
unless you use keyboard shortcuts for
everything the ribbon is how you get the
work done and access above the ribbon is
a quick access toolbar once you've
worked with access a while you may find
that you have commands that you use more
often than others to make it easier to
use these you can put them on a quick
access toolbar by default this save undo
and redo commands appear on the toolbar
but you can customize it to meet your
needs to the left of the quick access
toolbar is the Microsoft Office button
from here you have access to basic menu
options to work with files such as new
save prints and more it is also from
this menu that you can reach your access
options