Access 2013: Forms and Reports

  • 4.9
  • 0 Enerolled
    • Introduction
      • Welcome 0 min
      • Using the exercise files 0 min
      • Using challenges 0 min
    • 1. Introduction to Forms
      • Introducing forms 0 min
      • Designing for the end user 0 min
      • Exploring the database 0 min
      • Creating a form with the Form Wizard 0 min
      • Refining the form in Layout view 0 min
    • 2. Form Design Basics: Creating an Employee Directory
      • Organizing the form elements 0 min
      • Formatting and the Format Painter 0 min
      • Aligning controls 0 min
      • Modifying the form through its properties 0 min
      • Adding a header and some polish 0 min
      • Challenge: Exploring properties 0 min
      • Solution: Exploring properties 0 min
    • 3. Form and Report Controls
      • Introducing form controls 0 min
      • Using lines and rectangles 0 min
      • Organizing screen space with tabs 0 min
      • Adding buttons 0 min
      • Linking to external content 0 min
      • Entering and selecting data 0 min
      • Controlling input with option groups 0 min
      • Attaching documents 0 min
      • Attaching images 0 min
      • Understanding the subform control 0 min
      • Adding charts 0 min
      • Linking controls 0 min
      • Setting default properties 0 min
    • 4. Getting around the Database
      • Creating a main menu 0 min
      • Creating a customer form 0 min
      • Setting tab stops 0 min
      • Challenge: Creating navigation 0 min
      • Solution: Creating navigation 0 min
    • 5. Report Layout
      • Grouping and sorting data 0 min
      • Understanding report structure 0 min
      • Building reports from wizards 0 min
      • Building reports from queries 0 min
      • Formatting data based on their values 0 min
      • Calculating fields 0 min
      • Adding header information 0 min
      • Segmenting your data into groups 0 min
      • Challenge: Creating a report 0 min
      • Solution: Creating a report 0 min
    • 6. Linking Forms and Reports: Creating a Profit Summary
      • Selecting the desired parameters 0 min
      • Creating the report 0 min
      • Connecting the form 0 min
      • Connecting the query 0 min
      • Adding line numbers to the report 0 min
      • Hiding repeating values 0 min
    • 7. Printing and Exporting Reports
      • Printing reports 0 min
      • Automating the workflow with macros 0 min
    • 8. Populating Business Documents
      • Preparing the scanned template 0 min
      • Selecting a record from the database 0 min
      • Constructing the report 0 min
      • Creating a form letter 0 min
    • Conclusion
      • Next steps 0 min
  • Description

    Make the information in your Access database more transparent and easier to navigate with forms and reports. This course demonstrates how you can use forms and reports to control and organize the display of your data, as well as gather parameters for queries. Author Adam Wilbert starts with the basics of form design and leveraging controls such as buttons, links, and macros. He combines these ideas in a chapter that shows how to build an application-like framework for getting around the database. Then the course dives into reports: creating efficient and readable layouts, grouping data into categories, tying reports to queries, and using conditional formatting rules to highlight key takeaways from the data. Finally, Adam demonstrates how to link forms and reports together and print your results, and introduces unique ways to save time filling out paperwork and generating form letters.

Trailer video

Build Responsive Websites

Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

This Course Incluce

5 Hours video
Certificate
56 Lectures
Lifetime access