Advertisement Access Forms can make data entry tasks more convenient for you and your database users. Create a user-friendly Microsoft Access is a complex database tool with a steep learning curve. If you're searching for more intuitive and free alternatives with comparable features, we've got you covered!without exposing the internal database workings and grant yourself peace of mind that your data is safe.

• Microsoft Access 2016 User Guide

Following up our way back in 2010, after a request from reader Jeanne Thelwell, this tutorial will cover Access Form creation, modification, design control and form properties to give you power over your database design. For the purpose of this tutorial, we will be using the open-source US Senators Contact Information Sheet.

Once you’ve, you’ll need to unzip it to a memorable place – we’re going to need it in just a second. Let’s Begin Before we can create our Access Form, we will have to import our database. If you are playing along at home, that’s the link above, though this tutorial will work with your own dataset.

Start off by selecting “Blank desktop database” as seen below. The left hand column indicates your available database objects and if everything has worked so far, you should now see our imported data objects contactinformation and member.

Double-click to open member. Your database fields should now be populated with glorious US Senator Contact Information.

Our Quick Access Forms Tutorial Access Forms are customisable design objects allowing you to provide an accessible database experience for yourself and your database users. A well designed form can aide efficiency and improve data entry accuracy, so it is worth to save yourself time, editing costly errors. Let’s move onto the fun bits.

Our database is full. Our fingers are nimble. Select the Create tab followed by Form. Outlook will default to a basic form for our selected table, displayed in the aptly named layout view. Some of these outrageously exciting tools will come into play in a moment.

First, lets play around with the formatting of our Senators Contact Information Form. Formatting Our Form Layout Tools tab contains the form customisation fields.

Selecting it will deliver you to a similar screen to ours. At this point, feel free to play around with some of the settings to understand their role in form design and the aesthetic options available to you. You may also want an Ainsley Harriot background with green fill, bold italic underlined green text and green outlines. Something very MySpace/MSN Messenger about this, but perhaps not for everyone If that isn’t the visually appealing, engaging design you were interested in, you could choose some sensible options, too. Head back up to the Home tab where you can find the view option.

Here you can cycle through the available Form views. Congratulations, you have just made your first customised Access Form. Your database users will rush to thank you! Form Wizard Makes Form Creation Easy Microsoft have been exceptionally kind in their 2013 Office release. Understanding our societal desires to continually improve efficiency, they have included a rather handy Form Wizard to enable the skipping of the grubby, hands-on detail. The Access Form Wizard is a useful, rapid form development tool that puts you in the driving seat for design, whilst speeding you through the nomenclature, providing you with presets for columns, rows, table sizes, styles and themes. You can use the wizard to quickly decide which form style suits your database and user requirements.

Varieties of Access Forms Of course you might not always need to import a database and set up a basic form. There are several other form formats, depending on your data, as well as design controls to aid user navigation. Let’s examine some of these now. The Four Form Formats. Single Table Form.

It’s as it sounds: a single form, corresponding to a single database table. It is functional, basic and can be used to accomplish a number of tasks. Single Table Form with Lookup Field: Still using just a single form, single database setup, the lookup field allows us to display data from another table or database, or project the summarised values of a data range. The data is ‘looked up’ as required. Master/Detail Form: Master to Subform relationship i.e. One master form directs many subforms.

Master/Detail Form with Lookup Field: The same master/subform relationship, but with additional lookup fields in either the master or subforms. One of these four form formats will be found in almost every Access database form you encounter, so take some time to familiarise yourself with their appearance, strengths, weaknesses and where they should be applied. Use the Properties Sheet The Properties Sheet is a jolly useful sidebar, found in the Form Layout Tools tab: It contains reams of useful information about your Form and you can use it to quickly edit, modify and toggle numerous options. Not sure what an option does? Access provides a handy tooltip in the bottom left of your screen.

We cannot stress how useful the properties sheet can be for making changes on the fly. However, the options are too numerous to detail each one, so we’ll cover two you might require immediately: Hide a Field Want to ensure your users don’t access a certain field?

Access allows you to hide individual field entries. Select the field you want to hide. We’ve chosen party, from our existing database form. When you select the field, the properties sheet should update and you’ll be able to toggle field visibility through a drop-down box.

Lock Your Form Up Your database may well need to be accessed by other users – but you don’t want them to meddle with the finely tuned inner-workings of your tables and queries, and especially not any of your VBA code. Head back to the properties sheet. Scroll through the pictured drop-box to find Form – the properties we’ll be editing will apply to the entire form, as opposed to the single field isolation we covered above. Roughly halfway down the properties sheet you should see the following options: Change each property to no. Your properties sheet should now match this: Next, switch to design view and in the properties sheet drop-down box, find Form once again. Toggle Allow Layout View to no. This stops any additional users accessing the layout view, where they could directly edit the Form.

Distribution We’ve made our Form, we’ve meddled with formatting, we’ve played with properties and we’ve restricted editorial access. Now we need to save our Form for distribution. Before distributing our database, we need to convert the file from.accdb to.accde, restricting any further design changes or field editing. Save the current database to a memorable location. Before converting our file in Access make sure you make a copy (or two!) of the original database file, in. This will act as our master copy. We can update the form design or records available through this file, save, and redistribute.

Head to FileSave As. You should be presented with these options: Choose ACCDE File and hit save as.

Your database is now restricted to Form View only: There will now be two files in your save location: our master copy –.accdb – and our distribution version –.accde. Distribute the file with the massive padlock to your users. Come Back Next Time This tutorial should have illuminated the Which tool should you use to manage data? Access and Excel both feature data filtering, collation and querying.

We'll show you which one is best suited for your needs. Forms for you, giving you an understanding of basic design, formatting, properties and distribution. We’ll be back in the near future detailing the range of Access Design Control features to enable you to build more detailed Forms to suit your needs. Have you enjoyed this tutorial? Do you have any Access Form tricks to pass onto other readers? Share your knowledge below!

I have Access 2016. The other day I started to use it and found a help system, by chance it seems. Today I can't find that help library. I can find the video tutorials easily enough, but I want a straightforward, old-fashioned text version. I'm afraid I find the American accents of the tutors painful to listen to, and the constant movement doesn't help my concentration.

Microsoft Access 2016 User Guide

In the absence of an 'official' (F1 key) help system, is there another tucked away somewhere? At least until my Amazon order of a book on Access 2016 arrives later this week. Thank you all for your comments. I kicked myself for not noting the location of that help system that I found just by chance. It seemed to be a complete manual on creating relational database systems, but a day later I couldn't find it. Office 365 (Home version) doesn't (yet?) have a help system via F1. I haven't done any work on databases, including Access, since I retired thirteen years ago, so I need a reference that covers the lot.

I am aware that the earlier versions are virtually the same, but I don't have anything except Office 365, so I can't refer back. I did spend an hour today searching the web, but what I found was either very basic or inconveniently fragmented. I agree there is lots around, but it also takes a lot of time examining those sites! Thanks again. I said I've got 2016: not so.

I have, as I also said, Office 365 which has the 2013 components on Windows (Access 2016 is on the Mac I think, but I don't use that machine much). I have at last got my head sorted around the problems I imagined I had. I had looked at my Office 365 'Account' page which confirmed that I had all the latest updates and that I had the 2013 versions of Office components, e.g. Note the 'automatic updates' bit, which clearly hadn't happened and had not been disabled by me. This page also claimed that my files were up to date, which was not true.

Today I decided to go for re-installing Office anyway, from the 'My Account' page: It worked, and I now have all the 2016 components, including Access 2016 (for Windows), and the Help libraries that go with them and which are the ones I wanted, whereas the 2013 components did not have any help attached. So it seems to me that the subscription Office 365 does not provide automatic updates.

You have to know that they are available, then reinstall. Maybe, to be fair, I have missed something somewhere; I'm becoming quite an expert in how to be confused.

This may, or may not, help Gina, who had replied to my original post with: 'I wish I could say yes but alas no, you will need to wait for your Amazon order. If I am wrong I hope someone corrects me!' Hope this Helps. If you sign on to U TUBE and search for ACCESS 2016 you will find a complete set of show and tell videos showing you how to build an ACCESS 2016 database, How to fill in a Table Completely. (this takes two videos ) how to build a form, etc. I am an Old gentlemen (not kidding about the old part) who used to know Access Cold. Now that Microsoft has realized what a moneymaker they have and how they can compete with the other commercial databases on the market they have make this product a very hearty and beefed up product.

The products ability to pick up imbed databases inside other databases during the design phase makes it very friendly to use. I haven't gotten to the analysis phase yet but I suspect after a few WEEKS of suffering through learning programing again, It will be=become at least as clear as mud. At my age, that is all I can discuss. Good Luck All. Here are some more manuals I've found over the years: STL / Best training has had a number of free manuals online (there is a free manuals link on this page - this is a google search I've used to find trainnig materials. When things are bad, you can either: - cuss, - cry or - laugh.

Why not choose to laugh.