This content is part of one or more learning paths. To unlock, use the Enroll button to enroll in a learning path.
This lesson shows how finding and entering data into multiple tables can be graceful using a mainform + subforms. The UI (User Interface) built with Microsoft Access is smooth, and responds with information and animation when users hover and click -- and calculates dynamic information for ready display. Behind the scenes, there is a solid structure with referential integrity.
Download Access database (ACCDB format):
The sample is designed for efficiency and flexibility when entering payments for a shop that builds and sells custom storage buildings that are delivered and set up at your location. .
A mainform is used to display and edit data in a main table, with subforms for displaying and editing data in related tables. Lots of whistles and bells to spark creativity. Respond to different screen sizes by anchoring subforms and controls so they stretch and shrink, use unbound combo boxes and list boxes to quickly filter and find records, allocate checks and charges over open orders with a custom calculator, show and update dynamic information, and streamline data entry.
Hope you like this and get ideas. Please like, comment, and share with your friends. Thank you.
~ have an awesome day ~
analysis Analysis Tools Microsoft Access Microsoft Office MVP User Interface Forms Office 365 Database women in tech
You need to click Enroll to unlock the Learning Path courseware.
You are now enrolled in this learning path. Use the Launch Course or Launch Assessment buttons below to access the courseware.
|Para acceder a este contenido, necesitará un código de acceso. Si tiene un código de acceso, ingreselo aquí y haga clic en Enviar.|
|Palabra clave: Buscar|
|No se encontraron elementos.|