Emmanuel Katto Dubai : How to Create Professional Form Styles in Access (3 Viewers)

emmanuelkatto24

New member
Local time
Today, 15:30
Joined
Oct 17, 2024
Messages
8
Hello everyone,

I’m Emmanuel Katto from Dubai, United Arab Emirates (UAE) quite comfortable with designing databases, tables, and writing code, but I feel that my forms tend to look basic and outdated. I’d like to improve my form styling and learn how to use Access’s design tools to create more professional-looking forms.

I’ve searched for courses, but I haven’t found much information specifically on form styling. Can anyone point me to resources or references that can help me enhance the visual design of my forms?

Thanks in advance for your help!

Best regards,
Emmanuel Katto
 
I believe the answer is going to be in what you consider a professional form style. The example you provide is going to tell you what you have to do. We could assist in letting you know how hard it can be.
 
To make a judgment first you should see a file that you have recently made.
Often we care more about aesthetics than content and this is serious.
 
Have you looked at Sample Databases in this forum?

Pick up some books on Access, 900 pages plus. Most Access books are fairly basic (no pun intended) and for new users. Work by Litwin, Getz & Gunderlay tend to be technically better but not sure about their form appearance. A book like Access 2010 Inside Out may help Conrad & Viescas may help a little but all the useful stuff is on the CD as the book ends at page 1387. Look at as many as you can even though you may only pick up one or two useful ideas from each. I dropped on one design idea in Access97 Power Programming by Barker maybe 20 years ago that I will sometimes use here and there to make the best use of a screen area in certain cases.

I would advise that you get as much as you can onto one screen without it being a mess. So that the user can see everything connected with the subject. Avoid adding/editing by opening one form then another and so on. After six or seven everyone will forget what was on the first. Many users will forget what was on the first by the time they get to screen three. An extreme example are many online logon forms, banks are one. They will often have two or three logon forms, when one would do the job. Many, including Google will have one form for the name and another for the password. Why create two forms when one would do? Keep to one font and colour, avoid bold type. Think about the colour blind. During over 30 years of writing software, until Pat mentioned it on the forum I'd never given them a thought. Reds and greens are one. Avoid text just a shade darker that the background. Most of the IDEs I've used are guilty of that. Ensure your screens are clear and easy to read.

But of course you could do what everyone else does. Find a design pattern that you like, then adapt it to suit yourself. It may take a year or so before you drop on one. None of us here have the faintest idea as to which design would suit you. Which is pretty much why there isn't just one design of car.
 
Last edited:
@emmanuelkatto , @emmanuelkatto23 , @emmanuelkatto24

You are going on my ignore list as you have failed to respond to any of the answers provided in any of your myriad questions.
This tends to make me think you are either a bot, or a wind up, or simply here to waste peoples time.
 

Users who are viewing this thread

  • Back
    Top Bottom