a local taxes 2013 tutorials
in this video I'm gonna be talking you through data entry forms
so you wanna play along follow the link below the video to down a section
website and download access 2013 the bees are
8 and its opener for up
okay site data entry forms
what other well better entry forms traditionally of forms
the are used did she just for entering data into the system not ready for
modifying them
I'm but because it's the the way access is designed you can actually create one
form
and use it 5*a editing data for
for adding data so I'm I'm
interested at the moment in Table rooms there it is
I mcrae data entry form for tapeworms so
I make from click into table rooms on the
navigation pane I go to create and quite useful
and I get this which
may or may not be likely depending on YouVersion a beauty
parts first things first I'm you get rid of this
subform bomb and
with essentially actually already done much to access the most the work force
waste on as its and taken table rooms
and its use that as the record set for
this particular forms if you press if for
bring up the property she make sure some form here good data
record sources table rooms which means is taking over data from Table rooms and
it's dropping it into this form
and that's because that were able to use the navigation buttons at the bottom
and click through records and who this information missing corresponds to
information is actually in table form so
number 54 Ramadi five is room number 205 230 Palin I
and 2005 330-pound not sexy sexy takes care most the information for us
and and even to the extent
here where 5 to his FormView
homeowners might deter
know you any do something like that you actually just get the
on/off timer are know me losing the plot
areas access is done most of the work force with really needs to anything
more accepts started and also show you how to open them up
to a.m. at dates and
other at the bonds actually do a bit more to the right
and styling its I got a former go to former
and kicking down here we don't recall selectors that's a
bar here I'm gonna keep the navigation buttons
because they're Chronicle lets the
attend just get rid of the header these days
and we need to right click and save for my call it
and I'm form rooms data
entry okay that's great and
and what we do is still in the proficiency on the form
forces captured in war we're in. he will be displayed here
so that's right rooms that's kinda cool
and everything I sometimes like sometimes I don't do it depends on the
styling is
person the control bond click on a love these text boxes in the combo box
and property she i'm looking for special effects
and change it to some can so
but formed you got to look kinda nice and bit more
professional depending on what you want okay
next up I'm were interested in
buttons I as click on burn the design part the top click on the parliament
just
drop on down there and
I'm gonna actually you sum up the in bill
functionality
if we taken close form that is going to work
going to the only saving close a
notice cancel our own actually
I was on the workers we're saving close on it too undoing close
which we can do from we did you want to get from here
the record operations on the record ski the figure
gonna rain to split horizontally and I just one close I suppose
don't delay
and subtly
to league record
okay so person the control Quicken Loans bonds change to Britt
to to know is too small
the of through expiration to
and 345
ice a bit better and this band here
I'm go to property she
Mon 25 this change the name to CMD
safe
and for my and this change the picture
Sunday fear to type in S
and that's what I'm looking for I say to you
save got undue so-called on seeing the undue
and this once indeed early
change in the names and one other thing we do is change
the styling other the one changing the style in between us
horrible because it we're gonna later on this cheese
team is gonna change everything but this for now so we feel better about our
about things and that's pretty awful color in that
okay so click on the
safe bond go to on click
macro builder
and just tough in close
window object art form
Forms Data Entry so from yes
save that and close that
this one girl already be an embedded macro
down here close window
form same thing Forms Data Entry
as its and onto save no
just drag and drop to understand on menu command
I'm and the same I T
which is a close window
form Forms Data Entry
and from
for you to the thing at miss Italy you the reader
Cinderella so
close window just drag and drop that one up
if I can Vic
okkk said the three buttons since going to design view
you have a pretty good so we're gonna close
former state Sen sure it's going to make a dummy form
I can demonstrate something and
chorus 1 form test
and drop a ban on here
and will call this one
edit record
of a barn on here and call this one
new record I was looking at these are going to use these buttons
cool the form his room data entry
but I'm gonna I in the first bon we're gonna call it
so the it's not message you know so the opens to
existing data and in the second bomb gonna open the form up so it's
a new record so click on the bond press the form actually property she
go to then and complex organism macro
marker builder and open form
for name is Forms Data Entry
I am and window motor bomb
dialogue for the second bono u2
exactly the same thing except
open form for name and face entry
dialogue but now we're gonna say data mode
his at actually just for the sake consistency this change today amo to
to headed
who the fuck said anyway but so
seem consistent now you see the difference for reform if I click on
edit record was opened up a hoot is a pain
I'm the
form opens up before the date you need you can search through the records
cougar layout view
form format and
also send the yes naral open up in the center
to forego posted on the time and it recorded opens up to 50 day to the
and you can fit for the records save closer
never hurt a new record I was up exactly the same for me opens up
as very specific data entry form in the
do anything I can do at the moment is put data into the form
the press escape and close their
okay one other thing I'm gonna cover in a later video she wondered is possible
to open up forms to specific record so
so you when I opened up to room ID number four
but that would involve something like wireless box opening up for
buddy I'm going to get too much into that is the way I am designing this
database
values navigation forms nazar so specific way you do that
so marked activities to demonstrate data entry form
which was tied to table which is table rooms
I'm took no effort so to actually create before we just clicked on the table and
then
create months was created anything to deal with if it was all striving the
form
I'm and two in the buttons on I'm
to some sort basic formatting techniques and then
opening day or entry form is slightly different
I'm thing but cover the I found cover the
cover the next video so you can see how to open but their entry form to a
specific record
okay so thank you for watching
I'm and I will see you in an exterior