Which app on my iPad will let access my videos uploaded from the computer through iTunes

Synced Videos that are stored in iTunes should may appear in the TV App in Library, under Home Videos usually.

If you are trying to share the videos as shown in the support document you posted from, they'll be in whatever app you transferred the videos to there.