No, He even knew that Adam would sin, but created the world anyway, for the reasons I've mentioned.
does omniscient omnipotent creator know how to make an adam that does not sin ?
He could have made an automaton with no free will and called it 'Adam,' but this would have defeated the purpose of creation, as I've already explained. Would His creation be better if Adam had never sinned? By no means, for "The first man Adam was made into a living soul; the last Adam into a quickening spirit" (1 Corinthians 15:45). The last Adam has Himself said: "I am come that they may have life,
and may have it more abundantly" (John 10:10). The "new creature" in Christ Jesus (Galatians 6:15; cf. 2 Corinthians 5:17) is as superior to the old as the Virgin Mary's active 'Fiat' to the Annunciation (cf. Luke 1:38) is to the primordial waters' unconscious passion under the 'Fiat' of God (cf. Genesis 1:3), but this new creation would not have been possible without the conscious Passion of the Son of God under Pontius Pilate, "For we are buried together with him by baptism into death; that as Christ is risen from the dead by the glory of the Father, so we also may walk in newness of life" (Romans 6:4). This new life is a grace which God bestows in view of the infinite condign merit of the Sacrifice of His only-begotten Son, which we (as the theologians say) may congruently merit inasmuch as we "put on Christ" (Galatians 3:27) and follow Him by taking up our crosses (cf. Matthew 16:24, Mark 8:34, Luke 9:23), thereby filling "up those things that are wanting of the sufferings of Christ" and constituting "his body, which is the church" (Colossians 1:24). "For if we have been planted together in the likeness of his death, we shall be also in the likeness of his resurrection" (Romans 6:5); but unless we share in the atoning Sacrifice of the Son, we will by no means share in His Resurrection and Glorification at the right hand of the Father—and without Adam's sin, there would have been no need for such a Sacrifice, so that the Passion of our Lord would have been meaningless and unworthy of God's Justice, and would therefore never have happened. This is why the Latin Church, in her Good Friday liturgy, calls the sin of Adam 'felix culpa'—'happy fault'—for it was this alone which made possible the admirabile commercium in which God becomes human in order that men may participate by grace in the divine Nature, and in which this Nature is simultaneously revealed as the self-subsistent and self-emptying, transcendent and immanent Love of the Father Who gives His Son up for the world and the Son Who gives Himself up for His Father (cf. John 3:16, Philippians 2:7), to be adored and glorified forever.
"This is part of the infinite goodness of God, that He should allow evil to exist, and out of it produce good."