Microsoft Access, SQL: Visual Basic, Database Administration
Microsoft Access VBA, SQL Programming: Visual Basic, Microsoft Office, Database Administration Beginner To Advanced
Bạn sẽ học được:
- How To Create A Database In Access
- Creating More Tables And Relationships
- Look-Up Fields, Enumeration Type
- How To Deal With Trees And Networks
- The Access-Based User Interfaces
- Forms And Simple Controls
- Subforms
- Bound, Unbound And Computed Controls
- Tab Controls, Option Groups, Menus
- Queries- Computed Tables, Handling Null Values, Query With User Criteria
- Access Through Visual Basic
- Visual Basic Tools
- Command Buttons And Forms
- Record Sets (DAO), Modes And Menu Functions
- Visual Basic Reference
- The Statements And Declarations
- Constants And Addresses
- Operators, Conversion And Other Functions
- Display Formats And Regional Settings
- Access And SQL
- Action Queries- CRUD With SQL
- UNION Query
- Subqueries (EXISTS, IN, ANY, ALL…)
- Multiple Joint, Matrix And Dynamic Matrix Presentation
- Crosstab And Matrix Presentation
Yêu cầu:
- No Prior Knowledge Or Work Is Necessary To Take This Course.
- Pen And Paper For Precious Notes
