Module 1: Relationships
- Review
- Referential Integrity
- Relationships
- Data Types and Relationships
- Formalize the Relationship between Tables
- A Few Words about Naming Convention
Module 2: Queries
- Query Design View
- Review of Select Queries
- Review of Select Queries with Criteria
- Logical Operators
- Parameter Queries
- Action Queries
- Make Table Queries
- Append Queries
- Update and Delete Queries
- Rename a Query
Mobile 3: Table Functions
- Importing Data
- Linking Tables from External Sources
- Import Tables from other Databases
- Tables from Templates and Application Parts
Module 4: Forms
- Design View
- Form Sections
- Adding a Header and Footer
- Adding a Logo to the Header
- Adding a Title to the Header
- Adding Fields to a Form
- Arranging Fields on a Form
- Spacing Objects on a Form
- Formatting
- Tab Order
- Setting Properties on a Form
- Controls
- Create Forms with Application Parts
- Creating a Subform
- Alter a Form
Mobile 5: Reports
- Design View
- Report Sections
- Adding a Report Header/Footer
- Adding a Logo to the Report Header
- Adding a Title to the Report Header
- Adding Fields to a Report
- Add Calculated Fields
- Arranging Fields on a Report
- Resizing the Detail Section
- Eliminating Repeating Headings
- Grouping and Sorting
- Setting Properties on a Report
- Report Property Sheet
- Adding Record Counts
- Special Report Fields
- Controls
- Subreports
- Application Parts
- Deleting a Report
- Formatting a Report
Module 6: Macros
- Macro Basics
- Open a table, form and report
- Run a query
- Print a query
- Running a Macro
Benefiti:
- Video snimak predavanja u periodu od 365 dana posle kraja obuke
- Pristup laboratorijama u toku trajanja kursa
- Materijal u elektronskom obliku
- Zvaničan Microsoft sertifikat o pohađanju kursa
Poželjno predznanje:
Experience with Introduction to Access 2013.
Dalje usavršavanje:
Analyzing Data with Excel (MS20779)