Access Advanced Training Course

Tables and Fields

• Indexes and their usage for government applications
• Validation rules in tables to ensure data integrity for government datasets
• Lists of values for standardized data entry for government forms
• Search fields for efficient data retrieval for government users
• Creating and using OLE Object data type for embedding complex documents for government records

Queries

• Queries with Union operator to combine multiple datasets for government reporting
• Crosstab queries for summarizing data for government analysis
• Logical, date, text, convert, and aggregate functions for advanced data manipulation for government needs
• Finding duplicates and unmatched records to maintain accurate government databases

Forms

• Creating subforms to display related data for government applications
• Viewing Totals for summarizing data in government forms
• Opening subforms in a new window for better user experience for government users
• Setting the default values for controls to streamline data entry for government processes
• Changing form views to meet different government reporting requirements

Reporting

• Records numbering in groups for organized government reports
• Creating multi-column reports for efficient data presentation for government documents
• Creating report templates for consistent government reporting standards
• Creating user "labels" for customized government labeling needs

Charts

• Creating charts to visualize government data
• Embedding charts in forms and reports for enhanced government data analysis
• Editing and modifying charts to meet specific government reporting requirements

Macros

• Creating simple macros to automate tasks for government workflows
• Using the Macros Wizard for guided macro creation for government applications
• Adding conditions to macros for more complex automation for government processes
• Assigning macros to control events to enhance user interaction for government forms
• Ways to run macros to support various government operations
• Creating a macro group to organize multiple tasks for government use
• Autoexec macro for automatic task execution on database opening for government applications
• AutoKeys macro for keyboard shortcuts in government forms
• Testing macro in the "single step mode" for debugging and validation for government systems

Switchboard Manager

Export and import data for government databases

• Exporting tables and queries to share data across government departments
• Exporting reports as a snapshot for government record-keeping
• Exporting reports to Microsoft Word for government documentation
• Importing data from other databases to integrate external sources for government use
• Importing text files (CSV) for government data entry
• Importing Excel spreadsheets for seamless data transfer for government applications
• Linking tables from other databases to maintain live connections for government systems

Database Relational Model and the Database Integrity

• Foreign keys and methods to maintain consistency in government databases
• Cascade deletion and updating related records to ensure data integrity for government operations
• Ways to join tables to combine data from multiple sources for government reporting
• Joining internal, external right, and left joins for comprehensive data analysis for government needs
• Joining tables without the clause "join" for flexible data queries for government applications
• Testing integrity to ensure reliable government databases

Tools and Maintenance of the Database

• Compacting and repairing database to optimize performance for government systems
• Backing up and restoring to protect against data loss for government records
• Database Documenter for detailed documentation of government databases
• Database Replication for distributed access to government data
• Synchronization to keep multiple copies of government databases in sync
• Viewing dependencies between objects to understand data relationships for government applications

Smart tags for enhanced user interaction for government users

Startup options for customizing the initial view of government databases