MS Access Forms – Part 2

1
A C C E S S
D A T A B A S E
T U T O R I A L
Menu
02 10 71 7
N O V E M BB EEY RN A 3 D 0 T , 2 MS
Access Forms Part 2
As a reminder, please review Microsoft Access
Database Forms Part 1 Formatting
The Form Layout Tools tab contains the form
customisation fields. Selecting it will display
a screen like an image above. Now, feel free to
play around with some of the settings to learn
their role in form design and the stylish choices
available to you. You may also visit the Home
tab and find the View drop-down option where you
can cycle through the form view options
available.
Form Wizard Makes Form Creation
Uncomplicated Understanding the societal desires
of people in order to constantly boost
efficiency, Microsoft has incorporated a fairly
helpful Form Wizard to enable the skipping of the
grubby, hands-on detail
The Form Wizard is a useful, fast development
tool for creating ms access forms. It enables
you to manipulate the design and provides you
with presets for rows, columns,
2
table sizes, styles, and themes. You can use the
wizard to quickly choose which form style suits
your database and client prerequisites.
A Collection of ms access forms. Obviously, you
may not always need to import a database and set
up a basic form. There are a few other form
formats and design controls available to assist
user navigation. Lets examine the four form
formats Single Table Form is a single form
which corresponds to a single database table. It
is functional, basic and can be used to perform
several tasks. Single Table Form with Lookup
Field makes use of a single form and a single
database setup. The lookup field allows the user
to show data from another table or database, or
outline the summarised values of a data range.
The data is looked up as required. Master/Detail
Form is used if you have one master form that
manages several subforms. Master/Detail Form
with Lookup Field is the same as master/detail
form but with added lookup fields in either the
master or sub forms. One of these form formats
will be found in practically every Access
database form you encounter. Take some time to
acquaint yourself with their appearance,
qualities, weaknesses, and where they should be
used. Using the Property Sheet The Property
Sheet is a helpful sidebar found in the Form
Layout Tools tab. It contains reams of helpful
information about the form and you can use it to
promptly edit, alter, and toggle various options.
For you to understand the tools use, Access
provides a helpful tooltip at the bottom left
corner of the screen.
3
The options are too many to detail, so we will
discuss the two most important Property Sheet
options you may need immediately. Hide a
Field Access allows you to hide individual field
entries, so no other users will be able to access
a certain field except you. Choose the field
you want to hide. In this case, we are choosing
the party, from our current database form. After
choosing the field, the sheet should update, and
you will be able to select No from the
Visibility drop-down option.
Lock Your ms access forms Up Your database might
as well need to be accessed by other users, yet
you dont want them to intervene with the finely
tuned internal workings of your tables and
queries, and particularly your Macros or VBA
code. Go back to the Property Sheet. Look
through the drop-down menu to find Form the
properties which will be edited will apply to the
entire form.
4
Halfway down the sheet, you should see the
accompanying options
Change every property to No so the properties
sheet should now match this
Then change to Design View and in the properties
sheet drop-down box, look for Form once more.
Change Allow Layout View to No to stop other
users from accessing the layout view where they
could directly edit the form.
Distribution Weve created our form, weve
altered the formatting, and weve restricted
editorial access. Now we need to save our ms
access forms for distribution. Before you
distribute, you need to convert the file to
.accde format to restrict any further design or
field edits. Then, save the current database to
an easy-to-remember location.
5
It is also important to consider making another
copy of the original database file before
converting it in case the database will be
corrupted. Click File then choose Save As.
Scroll down to find Make ACCDE and tick the Save
as the button to save the file to .accde format.
Type the file name when prompted then click Save.
Open the newly saved database. It is now
restricted to form view only.
There will now be two records saved in your
computer the master copy (in .accdb format) and
the distributed version (in .accde format). You
may now distribute the file to your new users.
SIGN UP AND GET FREE EBOOK
Enter Your Name
SignUp Now and Get FREE EBOOK in your inboxand
Every Friday, we send out amazing Tips and
Tricks to help you master Microsoft Access.
Enter Your Email
Send Ebook Now!
If you like thispost then please share with other
people
? Email
Tweet
Save
Share 8
Share
Like this Loading...
Related Microsoft Access Database 2013 Tutorial
On Forms
6
Microsoft Access Database Forms Part 1
Microsoft Access Database Tutorial Creating a
Menu Form
M S
A C C E S S
Leave a Reply Your email address will not be
published. Required fields are marked Comment
Name
Email
Website
Post Comment
Notify me of follow-up comments by email. Notify
me of new posts by email.
P R E V I O U S Microsoft Access Database Forms
Part 1 N E X T Create a Report in Microsoft
Access 2016 Part 1
7
Search
A C C E S S
2 0 1 6
E B O O K
O F F E R
U N D E R S T A N D I N G
A C C E S S
M A C
R E C E N T P O S T S MS Access Database Images
How To Correctly Handle Them ? Access Queries
Date Criteria May Not Always Work with MS Access
Query How to create an embedded macro? Create a
standalone macro Part 2 Whats the new Macro
Features from the release of Access database 2010?
R E C E N T C O M M E N T S benadt2017 on Access
Tab Control How To Create Multi-Page Forms
Kolade. O on Access Tab Control How To Create
Multi-Page Forms ms access forms on How to Build
Access Database Forms Microsoft Access 2016
Database eBook on Microsoft Access 2016 eBook
Offer MS access query on How to Build Access
Database Queries
C O N N E C T
U P
O N
F A C E B O O K
8
Microsoft Access Database 4,766 likes
Like Page
Contac
M O R E
S O C I A L
M E D I A
A R C H I V E S
Select Month
C A T E G O R I E S
Select Category
M Y
E Z I N E
A R T I C L E S . .
2010-2017 AccessDatabase Tutorial
Terms Of Use
Privacy Policy

Contact Us

Proudly powered by WordPress