Microsoft Access Intermediate

Princeton X

• Section 1 1:10:05

  • 1: Access Forms and Reports - 1 - Autoforms 14:01
  • 2: Access Forms and Reports - 2 - Form Wizard 08:52
  • 3: Access Forms and Reports - 3 - Changing a form with design view 26:10
  • 4: Access Forms and Reports - 4 - Adding controls to your form 21:02

• Section 2 36:44

  • 5: Access Forms and Reports - 5 - Subforms 14:51
  • 6: Access Forms and Reports - 6 - Using Autoreport to create a report 03:20
  • 7: Access Forms and Reports - 8 - Changing a report in design view 11:19
  • 8: Access Forms and Reports - 7 - Using the Report Wizard to create a report 07:14

• Section 3 35:25

  • 9: Access Forms and Reports - 9 - Adding Calculations to your report 09:12
  • 10: Access Forms and Reports - 10 - Adding Groups, Sorts and Totals to reports 16:09
  • 11: Access Forms and Reports - 11 - Making labels with the Label Wizard 04:25
  • 12: Access Forms and Reports - 12 - Form and Report Properties 05:39

• Section 4 28:15

  • 13: Access Forms and Reports - 13 - Exporting a report to Excel 03:14
  • 14: Access Forms and Reports - 14 - Creating a menu with the Switchboard Manager 17:13
  • 15: Access Forms and Reports -15 - Finalizing the Application 07:48

Certainly! Here's an outline for a comprehensive Microsoft Access course:

#### Module 1: Introduction to Microsoft Access
- Overview of Access interface and navigation
- Understanding the purpose and benefits of Access
- Creating a new database and exploring templates

#### Module 2: Creating and Designing Tables
- Introduction to database tables
- Designing table structures: fields, data types, and properties
- Defining primary keys and establishing relationships

#### Module 3: Working with Table Data
- Entering and editing data in tables
- Sorting and filtering records
- Applying validation rules and input masks

#### Module 4: Introduction to Queries
- Understanding queries and their types
- Creating select queries using Query Design View
- Running and modifying queries

#### Module 5: Advanced Query Techniques
- Joining tables in queries
- Using calculated fields and aggregate functions
- Creating parameter queries for flexible data retrieval

#### Module 6: Forms Design
- Creating forms to input and display data
- Adding form controls and formatting
- Using subforms for related data

#### Module 7: Reports Design
- Generating reports to present data effectively
- Designing report layouts and formatting options
- Grouping and summarizing data in reports

#### Module 8: Advanced Data Management Techniques
- Importing and exporting data between Access and other applications
- Linking external data sources to Access databases
- Implementing data validation and error-handling techniques

#### Module 9: Automation with Macros
- Introduction to macros and their uses
- Creating and running simple macros
- Automating common tasks with macros

#### Module 10: Introduction to Visual Basic for Applications (VBA)
- Understanding the basics of VBA programming
- Writing simple VBA code to automate tasks
- Integrating VBA with Access objects and events

#### Module 11: Security and Maintenance
- Securing Access databases with user-level security features
- Backing up and restoring databases
- Optimizing database performance and troubleshooting common issues

#### Module 12: Final Project and Review
- Applying learned concepts to a final project
- Reviewing key topics covered in the course
- Setting goals for further exploration and mastery

- Video Tutorials: Step-by-step video tutorials for each module.
- Hands-on Exercises: Practical exercises to reinforce learning.
- Quizzes and Assessments: Assessments to test understanding and retention of course material.
- Supplementary Resources: Additional reading materials, cheat sheets, and reference guides.
- Community Support: Access to a community forum for asking questions and sharing insights with fellow learners.

No prior knowledge or experience required

There are currently no Q&As for this course. Be the first to ask a question.