... Would the network password be the same as my Mac's password?
It can be if you configured it that way, but since that is apparently not working for you it's probably not the same. You can reconfigure the Express easily enough using AirPort Utility - it is in your Utilities folder, which is found within your Applications folder.
Launch AirPort utility, then reset the Express:
To reset your Express:
Press and hold the reset button with a pen or pencil for 1 full second. The light (LED) will flash amber, indicating that the AirPort Express is in soft reset mode.
This will enable you to use AirPort Utility to reset your network password.
Note: If you do not make your changes within five minutes of pressing the reset button, AirPort Express will return to its previous configuration. The light will change back to solid green (or whatever state it was in before the reset).