Hello. My Name is Sali Kaceli.
The following is a comprehensive tutorial on
using Microsoft Access 2016. During this
tutorial will cover basic concepts
related to databases and how to design
and use a basic database using Access
2016. We will start with a very basics of
the application and of databases overall
and then we'll get moving into working
with data in a database the tutorial is
designed to be concepts paste and simple
to understand the best way to learn is
to follow the video hands-on on your
computer so let's get started first some
general concepts related to databases
and how databases work
first we're going to start with the
definition of a database database is a
collection of data that is stored in a
computer system a database allows their
users to enter access and update and
analyze their data quickly and easily
they are powerful tool that you see them
all the time when you go to the doctor's
office when you go to the grocery store
when you go online to purchase something
all that information is usually stored
in what's called a database the easiest
way to understand the database is to
think of it as a collection of lists so
think of it for example if you're
running a business you have a list of
customers you have a list of orders from
those customers you have a list of items
that you are selling to your customers
or services that you're providing to
your customers and then you might have a
list of invoices and other purchases
from vendors and things like when you
put all those lists together in a
database those lists are linked together
and the information is related from one
table to another and that's partially
was it
her to as a relational database so where
does access fit into this microsoft
access is a relational database software
program or database management system
dbms that runs on Windows operating
system it is used to manage data that is
organized into lists such as information
about customers products vendors
employees projects so basically
microsoft access is a relational
database management system created by
Microsoft to store organize and
manipulate data as well as to select and
report on it so some of the components
just to summarize them briefly our
tables queries forms and reports tables
that's where the data is stored within
the database then the queries retrieve
specific data from the tables or other
queries and displays only the data that
you specify queries allow you to ask
questions about the data in your tables
for example I want just the first name
last name and email address and the form
is used to enter new records in a table
that's the data entry component of it
and to edit or delete existing records
into the table usually the data is not
entered directly into the table manually
but it is done through the forms and
then the reports are the fourth
component here and those would be very
similar to the output they summarize the
fields or records from a table or query
an easy-to-read format for example that
would be a report that you print out
something that you print out to give to
your manager for the sales of that day
now what does all of this look like in
national database
here's a really simple database that we
have we have a database called the
customer sales here and we have a bunch
of tables in this case we have the
summer table we have a contact table and
then we have invoices so think again
about these as separate lists so the
customer table of course it'll have the
list of customers we have here the
customer ID company first name last name
telephone number state at a city state
and so on so those will be very similar
to what we have seen in Excel you can
sort this day they filter it and things
of that nature but think of it just
isn't as a list now besides the
customers if you're running a business
then you probably have different
contracts or different sales so in this
case this is another example of a table
of contacts table if we double-click on
it we have a contact number
customer ID contact amount the date and
the type and then notice we have another
table here called invoices and the
invoice table has the date number and
the item what it was for the amount and
whether it's are spayed or not
so those are the tables again this is
where the data is stored into a database
think of it you hear tables storage
the next component in a database and I
mentioned earlier it is the queries so
if we go here the queries for example
are like we have a table customers
notice we have a whole bunch of fields
here
the fields are those names of the
columns here and let's say that we want
the generated list of only the first
name last name and then let's say email
address and some other pieces of
information here we create what's called
a queer in order how to create queries
monetarily here so notice i have another
entry here under the customer table and
this is a query that we have run that I
defined earlier if i double Kline know
this i have only the first name last
name telephone number and email address
so that I think of it the processing of
the data based on a criteria and this is
an example of a form the form is
basically instead of you going to the
customer table scrolling all the way to
the bottom and entering the data
manually here which is not recommended
you go under the customer data entry
form for example in a form similar nicer
than this and enter the records right
here and you just basically fill in the
data in real business this is what the
assistant would utilize for entering the
data into the into the database and then
the final component as i mentioned
earlier it is the reports and reports
are very similar to queries but they are
just designed so they can be printed out
and they look nicer
so these were some of the basic
components of a database the tables are
where the data stored the queries are
how the data is manipulated then the
forms are how the data is updated and
added on to and then the reports how the
data is printed out or output