[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Databases

56K

Solutions

40K

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

How to incorporate Contact Management into an Access database?
Hi,

this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management.

Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments, ... and many extra bsiness tables.
http://www.msaccessgurus.com/Contacts.htm#Download

This example is elaborate as I spent hundreds of hours building and refining it over the years. Don't let its complexity scare you off from Access! Even seasoned Access developers would need to spend a lot of time to understand it all. The good news is that you can also just use it! Be sure to swap out the back-end for the one without the sample data once you are comfortable ... and if importing tables into your back-end, get them from the "blank" back-end that is included as you probably do want some of the records, like for types.

While I categorized this as "intermediate", if you are a beginner, don't be shy about getting this valuable tool! One of the best ways to learn Access is to use it ... and everyone knows people they keep contact information for.

have an awesome day,
crystal
 

1. download the contact template

http://www.msaccessgurus.com/Contacts.htm#Download

2. open your working database, or skip the rest of the steps and just open the contact template if you want to use it stand-alone

3. from Ribbon --> External Data tab

4. click Access icon in the Import group

5. from the dialog box that pops up, choose --> import (default)

6. click the Browse button to choose the (contact) database file

7. click OK to see a list of objects

8. choose queries, forms, reports, and modules that you want to import

9. OK to bring them all in

10. tables are in the back-end database -- so import these into your back-end, not your front-end


   if your database is not yet split into a front-end and back-end, of course, put them where you are developing

11. Alt-F11 to go to the VBE (Visual Basic Editor)

12. Debug, Compile from the menu

13. fix what is wrong and/or import things you forgot

14. Save

15. Hook into your existing tables by adding CID where it needs to go.


0
Exploring ASP.NET Core: Fundamentals
LVL 12
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Repair Corrupt SQL Database with Stellar Phoenix SQL Database Repair Software
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recovery of Deleted records and recovers all components of SQL Database.
1

Expert Comment

by:Lawrence Horton
Hi Bharat,

Thanks for sharing this video. I have tried this software and it worked for me. I will suggest to download this software from its official website: https://www.stellarinfo.com/sql-recovery.php
0
LVL 6

Author Comment

by:Bharat Bhushan
Hello Lawrence,

Thanks for your valuable comment.
0
How to Bring Back the SQL Database from Suspect Mode to Normal Mode?
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
1
LVL 1

Expert Comment

by:Cris tol
You can alos refer https://www.experts-exchange.com/questions/29122126/how-to-make-my-SQL-database-online-from-Suspect-mode.html to get the script to bring sql database from suspect mode to normal mode manually.


Thanks
0
How to Enforce Referential Integrity on Access Relationships
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other.

As you build tables in Microsoft Access, or link to tables that are in SQL Server, Excel range, or other database, put them on the Relationships Diagram

Stretch or shrink fieldlists so everything shows

To create a relationship in Access, click on the Primary Key in the main table, drag to the Foreign Key in the related table, and let go.

In the dialog box that pops up,
check: Enforce Referential Integrity

This is important so that there are not values that don't match up to anything.

Error creating relationship?

If there is bad data, a relationship with referential integrity cannot be created. Fix the bad data and try again.

If the table is linked, you can show it on the diagram but you cannot create a real relationship that is not already there. If relationships are not defined, you can drag lines without enforcing  referential integrity to show what is supposed to match.

Define relationships and arrange the diagram as you build your tables.
Enforce Referencial Integrity unless you have a specific reason not to.

have an awesome day,
crystal
 ~ connect to me, let's build it together
http://www.msAccessGurus.com

1. To create a relationship in Access, open the Relationships Diagram

2. click on the Primary Key in the main table

3. drag to the Foreign Key in the related table

4. and let go of the mouse.

5. When the dialog box pops up, check: Enforce Referential Integrity

6. and click Create

7. Rearrange the Relationships Diagram so everything shows and flows

1
Synchronize List Box in Access using SQL and VBA
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give it a chance. Unleash a great new potential.

This technique of basing the Row Source of one control on the value in another is called "cascading", and you will probably hear that term more in reference to combo boxes.

A list box has many similarities to a combo box such as Row Source, Column Count, Column Widths, and Column Heads. The Width of a list in a combo box is List Width; in a list box, it is the same as the control Width.

As the customer changes, VBA runs to add criteria to the SQL statement for the list box. SQL is what a query stores to know what data to get, where it comes from, and how to sort.  SQL is Structured Query Language.  Don't let the acronym intimidate you.  

An SQL statement is simply a standardized way to get information from database tables. It specifies what to show (Select), and where data comes from (From). Optional clauses include criteria (Where), and how to sort (Order By).  The basic syntax for an SQL statement is:
SELECT fieldlist
FROM tablename
WHERE criteria
ORDER BY fieldlist;

To get an SQL statement into the Row Source of a combo box or list box, you can: (1) Make a query to show what you want, switch to SQL view, and copy the SQL statement, or (2) click in a control's Row …
0
[Webinar] Why Does Multicloud Storage Matter?
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day.

Nimble Storage wants to help companies and IT personnel better understand how to avoid these misuses, while showing how to make the most of the cloud experience. The best way to start? By embracing multicloud storage options.

Watch this video to learn why multicloud solutions matter to the foundation of your cloud storage strategy.
4
Mainform + Subforms designed for efficiency and flexibility
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. When a sale is made, it may be paid outright, carried in-house, or purchased by a finance company.

Using a mainform with subforms allows data entry into multiple tables with referential integrity. There are also calculations, and ways to find and filter information; Synchronizing subforms so they update with the record changes using LinkMasterFields and LinkChildFields; Calculating sum and total number of orders and payments, and the balance due; Displaying the company logo; and more.

Learn how to undo creating a new record, use shortcuts and quick ways to enter data, and about setting the Enter key behavior in the Access Options so pressing Enter goes down one row, just like in Excel. See how easy it can be to disburse all the is remaining on an allocated amount left to a single order.

See how Anchoring subforms and controls enables them to stretch and shrink as the display area changes.

Future lessons will go into the nuts and bolts of how this form works, address issues, fix problems (there are some), and enhance capabilities.

~~~

Did you learn something new?

Please Like, Comment, and Share with your friends. Thank you.

Through sharing, we will all get better.

have an awesome day,
crystal

1. Download sample database

0
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

Expert Comment

by:Globalnetech India
Nice Article and thanks for sharing information
0
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
Determine the Perfect Price for Your IT Services
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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 19

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 24
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

56K

Solutions

40K

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.