A Little Look At Microsoft Access Application

Microsoft Access 2003 is my ideal application for creating small business databases. If you are new or want to be a part of the programmer’s world then I suggest Microsoft Access for you, with this application you can easily create professional databases for saving and sorting all kind of records and can make different reports as you need.

Its interface is graphical and very friendly with few clicks and a little planning you can build up good database applications. There are many templates and wizards that are very helpful. Microsoft Access supports Relational Database Management System (RDBMS) that means you can make links between different databases.

For making a database first of all you need to planning about it that what kind of record you or your customer need to save or for a what kind of purpose you are creating a database, after that create tables in which your data stored or you can use wizards to build up specific tables. Then create forms for inserting or posting data after that make queries for updating, sorting, appending or for showing a specific data from different tables into a single table or report. Now create reports for printing on papers desired data. There is another important tool named Macro, with this one you can create different functions and many behaviors for different forms and reports and can make different menu bars and messages for users if their turn against the rules of data that you already describe in tables and forms.

You can also create some Modules in order to make your database secure from accessing unauthorized persons or can define users and administrator groups. There is another great option for tracing a user with login time and date.

Microsoft Access is not supportable for up to 2GB data storage. If your data is larger than 2 GB then there is another option for you that you can use “Upsizing Wizard” with this one you can transfer your tables on to MS SQL Server and can use Forms and Reports that you designed in MS Access as a front application, with this method you can speed up your database and there is no chance of corrupting database and no need of optimizing and repairing. Use MS SQL Server as back end application where your data saved and front application is MS Access. You don’t need to make any change in your Forms and Reports use them as they are.

You can also convert Access Database tables on My SQL Server by using 3rd parties tool like Access to My SQL migration tool kit etc.

Motorola L7 Phone

Its Fun to Change Your Motorola L7's Casing and Repairing by Yourself

You can change the whole body or some parts of your Motorola L7 phone professionally if you follow my guides step by step below:-

First of all you need to turn off your phone and then remove its back cover, after that remove battery and sim card and memory card if it is in.

Place your nail or use some metal tool in the gap and pull to remove its aerial cover until clips off as shown in fig 1.1 below



Figure 1.1

Now use screw-driver Tool to un tight all 6 screws one by one as shown below in figure 1.2

Figure 1.2

After removing all six screws removes the silver top plate (camera cover) now you can watch your phone look like in figure 1.3

Figure 1.3


After that use your nail or tweezers tool to unclip 3 ribbons on the main board of L7, These ribbons are of Screen, screen to keypad and of signal cable as shown in figure 1.4

Figure 1.4

If you need to replace your camera too then unclip its ribbon by pulling the unit out of the main board as shown in figure 1.5 below

Figure 1.5

Use tweezers tool between the front face and middle board and pull until the front face locks open and remove the front cover gently as shown in figure 1.6 below

Figure 1.6

Now pull out of your phone’s keypad and your phone should look like this in figure 1.7 below

Figure 1.7

Now you need to remove the earpiece speaker of your Motorola L7 phone to do this use the tweezers tool pull up the earpiece speaker slowly until it comes off as shown in figure 1.8 below

Figure 1.8

Use the double sided tape or some glue to fix this earpiece speaker on a new housing

Figure 1.9

Now remove the 2 screws that hold the key pad board with the housing bone but please very carefully because it is connected through the signal’s ribbon as shown in figure 1.10 below

Figure 1.10

Now your phone looks like as in figure 1.11 below

Figure 1.11

Now its time to remove the LCD cover that is of glass, use the specific tool apply some pressure until the glass completely removed, because it is fixed with some type of glue so you need to use some force but carefully. As shown in figure 1.12 below

Figure 1.12

Now remove the LCD metal cover with tweezers tool, bend the metal cover slightly and open its locks then pull it up same as shown in figure 1.13 below

Figure 1.13

After unclipping successfully pull out the LCD simply but carefully don’t touch the front side of LCD and its ribbon to do this follow as shown in figure 1.14 below

Figure 1.14

After performing all the above operations your phone should be look like as shown in figure 1.15 below (placed all parts on a clean and plane surface in order to keep them clean and accessible)

Figure 1.15

Now use the tweezers tool to pull out the signal cable from the housing bone same as shown below figure 1.16

Figure 1.16

Pull out all unconnected ribbons from the old housing, first pull outside the silver paper and then ribbon but very carefully don’t break them figure 1.17 below

Figure 1.17

Now your phone’s hands free speaker remains inside use tweezers tool or something else in the sided gaps and with your thumb pull it out easily as shown below figure 1.18

Figure 1.18

Now pull out the aerial after opening its rubber locks and fixed it on new housing and place the hands free speaker at its place surround the aerial figure 1.19

Figure 1.19

Attach the keypad ribbon and placed it in new housing carefully as shown in the figure 1.20 below

Figure 1.20

Now insert the signal cable into a little hole from one side to another and make sure it runs through its plastic line that is on the housing same as shown in figure 1.21 below

Figure 1.21

Tight the keypad’s 2 screws as they are before and then took the LCD and put it back on the upper side of keypad board and grip it again with the metal frame as shown in figure 1.22 below

Figure 1.22

Now first connect your camera to the main board as it is before and putt the main board in the backside of housing but keep in mind that all 3 ribbons must be upper side of the main board in order to connecting them later easily as in figure 1.23 below

Figure 1.23

Now connect all ribbons carefully and put the white membrane paper on the keypad plate gently and make sure all golden points are correctly covered with this white paper after that place a keypad button plate on the white paper correctly and then get the front face put it back on the housing and pressed it with your thumbs upper side and lower side to lock it and fix it correctly as shown in figure 1.24 below

Figure 1.24

After all your phone should be look like as shown in figure 1.25 below

Figure 1.25

Now turn the phone back side and place the main board’s silver cover back on it and tight them with screws then get the lower case that is on a hands free speaker put it back and press it with your thumbs as shown in figure 1.26 below

Figure 1.26

Now take a cotton piece and clean the LCD and its glass cover, remove the finger prints and dust from LCD and glass then stick it back. Insert your sim, memory card and battery into the phone and switch on. Enjoy your phone with new casing

Figure # 1