Movers Transport System Project

Password-protecting your database project guards against threats well known to you such as theft of the database or its objects such as tables, queries and forms by importation/exportation. To encrypt or decrypt a Microsoft Access database you need to open it in exclusive mode. WARNING: I recommend that you use a copy of your database in doing this as there is no remedy if you forget your password. Encrypting your database 1.       Launch Microsoft Access 2.       Go to file and click on open as shown below 3.       Navigate to your database file’s location and select it. Click on the arrow next to the OPEN command to see the options such as Open, Open Read Only etc. Select Open Exclusive. The database will now open in exclusive mode. 4.       To encrypt the database, go to file and click on encrypt with password. The following window will appear. Enter your desired memorable password, verify it and click on OK. 5.       You may see this error message. Just click on OK. Your database i

Introduction A classic go-to combo box makes record navigation in forms a breeze. A user doesn’t’ have to use the next, previous, last record and first record buttons to navigate through dozens or even hundreds of records stored in underlying tables. If you have watched my videos on my YouTube channel, then you’ll notice that almost every form in my projects has this nifty combo box. To navigate to a record all that a user needs to is to locate the record in the drop-down list and the record will be loaded on the form. Nonetheless, the go-to combo box is not a complete replacement of the aforementioned buttons; in fact, having a combination of both makes the user’s experience even much better. The process At this stage, you must have a form which writes data into an underlying table. Such a table can be a student details table with the following fields: StudentAdmNo , FirstName , LastName and Form . If you create a form using the Form Wizard based on this table, it should look like th

How to design visually appealing forms and reports. Forms and reports are the interface between your system and the user. The end user will not see tables, queries, SQL code or VBA code. For this reason, you need to have presentable forms and reports. The first step is to make your report/form pop up. Below is my Golden Wall Students form when pop up is disabled. It is plain ugly and uninspiring To make your form pop up, open it in design view, go to the property sheet > other> set pop to yes. The next step is to remove the scroll bars from your form. In design view, go to the property sheet > format > scroll bars > set to neither. Now that you have set up your scroll bars to neither, your form should be of a size that does not need resizing to view other items in it. Now set your form’s border style to thin by opening your form in design view > Property sheet > Border style. You may also want to change the following for a clean form. Finally, if you don’t want the

Forms are the interface between your system and the user. For this reason you'd want them to look as good as possible. You also want items on them well arranged. One of the best additions to an Access form is a clock. With a clock on your form, the user does not have to look at his/her watch or the computer's clock. You have probably noticed that whenever you add a clock to your form, it only updates when you open the form and stays frozen until you close and open the form again. This is really inconveniencing since the clock turns into just but an aesthetic addition, a mere beautification. In this blog post you will learn how to circumvent this. In your form’s design view, go to date and time and click on ok. Time and date will be shown on your form. A real-time clock on my Store Management form Open your form in design view and go to property sheet > event > timer interval. Set the timer interval to 1000 . You now need to edit the on-timer event using Visual Basic. Clic