Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Databases

54K

Solutions

39K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Share tech news, updates, or what's on your mind.

Sign up to Post

Some Basic Differences Between MySQL and MongoDB
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.

To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/webinars/mongodb-administration-mysql-dba
0
Learn how to optimize MySQL for your business need
LVL 3
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

How Do You Implement High Availability in a Database Environment?
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.

To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastructure, please call us at +1-888-316-9775 (USA), +44 203 608 6727 (Europe), or have us contact you (http://learn.percona.com/contact-me)
0
Percona Server for MongoDB
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.


How Percona can help

Percona can help you determine if Percona Server for MongoDB is the right solution for your company and if it is, help with your deployment, while ensuring optimal performance. Enterprise-class Percona Support is available 24/7 to answer all your questions, ensure your deployment runs as expected, and help you in a crisis.

To discuss how Percona can help you make your Percona Server for MongoDB deployment a success, please call us at +1-888-316-9775 (USA), +44 203 608 6727 (Europe), or have us contact you (http://learn.percona.com/contact-me).
0
Why Use Three Nodes in a Database Cluster?
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.

To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastructure, please call us at +1-888-316-9775 (USA), +44 203 608 6727 (Europe), or have us contact you: http://learn.percona.com/contact-me
0
Webinar - Best Practices Migrating to Open Source Databases
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.

In this webinar, we will look at how to address such concerns to help get a migration commitment. We’ll cover picking the right project, selecting the right organizational team to manage migration, and developing the right migration path to maximize migration success (from a technical and organizational standpoint).

If you enjoyed this video please check out more videos from Percona here. To see a list of upcoming webinars you can visit our webinar page here to sign up.

Want to get weekly updates from Percona? Subscribe now and we'll send you an update every Friday at 1pm ET.
0
Polish Reports in Access
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled out.

If you haven't already seen it, watch and do all the steps for 'Create a Query and Grouped Report and Modify Design using Access'
https://www.experts-exchange.com/videos/4514/Create-a-Query-and-Grouped-Report-and-Modify-Design-using-Access.htm

1. Download the START and SOLUTION databases

ReportPolish_START_SOLUTION.zip

2. Change equations for sum descriptions in each of the group footer sections to cut extra words.


Month format code is mmm-yy
Year format code is yyyy

3. Set Width of product category footer descriptive equation to 2.8 inches and Left to 0.2 inches.


4. Delete extra labels with the caption = sum


5. Set width of other group footer descriptive equations to 3 inches.


6. Set Top of sum amount controls to 0 in the group footer sections.


7. Bold header and footer group section controls.


8. Tighten spacing to reduce pages.


9. Set group sections to 'keep header and first record together on one page'.


10. Set Back Color and Alternate Back Color for each section:


- Product Category = aqua
- Day = orange
- Month = blue
- Year = green

11. Set group header and footer controls to Back Style = Transparent.


12. Save, Close, and Rename the report.


13. Modify the menu form to add a command button with a Click [Event Procedure] to open the report in print preview.


Remember to Debug, Compile, and then Save

14. Write VBA code to construct criteria that the user may have picked and ignore criteria that is not specified.


15. Modify the OpenReport code to call the criteria function for the WhereCondition argument.


Remember to Debug, Compile, and then Save

16. Now for the fun part ... open your new report for any date, or date range, or no criteria!

1
 
LVL 17

Administrative Comment

by:Kyle Santos
Great video submission, Crystal!  Congratulations.  Your video has been Approved and is now published on Experts Exchange.  Feel free to share this video by selecting the social sharing icons.
0
 
LVL 22
thank you, Kyle
0
How Joins Work
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of demo data.
5

Databases

54K

Solutions

39K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.