MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Access 2007 Part 4: Advanced Features

Course Summary

Part 4 of 5 in the Access 2007 series. If you are tasked with building a new database, fixing your company's Access database, or just wish to ditch the bulky Excel spreadsheet, this is the course for you. This course will teach you to track and report dat


  • +

    Course Syllabus

    ● Creating PivotTables and PivotCharts
        ◦ Creating a PivotTable
        ◦ Modifying a PivotTable
        ◦ Creating a PivotChart
        ◦ What We Covered
    ● Creating Basic Forms
        ◦ Form/Report View
        ◦ Ways to Create Forms
        ◦ Tour of Create Tab Form Options
        ◦ Using the Form Wizard
        ◦ Creating a Form from Design View
        ◦ Parts of a Form
        ◦ How to Modify/Edit Forms
        ◦ Adding Form Controls
        ◦ Creating a Calendar Control
        ◦ Creating Command Buttons
        ◦ Setting Form Properties
        ◦ What We Covered
    ● Designing Macros
        ◦ Introduction to Macros
        ◦ Introduction to Security
        ◦ Creating a Basic Macro
        ◦ Embedded Macros
        ◦ Advanced Macro Techniques
        ◦ Creating Conditions
        ◦ Building a Macro to Run Automatically
        ◦ What We Covered
    ● Creating Basic Reports
        ◦ Ways to Create Reports
        ◦ Using the Report Wizard
        ◦ How to Modify/Edit Reports
        ◦ Creating a Report from Design View
        ◦ Grouping and Sorting
        ◦ Adding a Company Logo
        ◦ Adding Reports Controls
        ◦ Other Report Properties
        ◦ What We Covered
    ● Creating a Switchboard
        ◦ Protecting Data
        ◦ Overview of Switchboards
        ◦ Creating a Switchboard
        ◦ Using the Switchboard Manager
        ◦ Customizing Startup Options
        ◦ Assigning an Application Title
        ◦ Creating/Assigning an Icon
        ◦ Displaying a Form on Open
        ◦ Hiding the Navigation Pane
        ◦ What We Covered
        ◦ That's All Folks

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top