Explore Databases on Experts Exchange

Expert Solutions for Your Tech Problems

Databases

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes tha...

Read more
  • 830K Content
  • 45K Contributors

Expert Spotlight
Gary PattersonVP Technology / Senior Consultant

Experienced, hands-on IT expert.  IBM i / iSeries / AS/400, Windows, Linux, security, performance, web, mobile, SQL, RPG, Java, .NET, more.

Video
Shuffle - 4 - Append Query

Shuffle - 4 - Append Query

We have a Totals query, and change it to an Append Query, so we can use it to add records. Create an…
Video
Shuffle - 3 - Table Design

Shuffle - 3 - Table Design

We are going on a deep dive to the foundation of data structure -- what is in the  design view of a …
Video
Shuffle - 2 - Totals Query

Shuffle - 2 - Totals Query

Data was imported into Access from Excel. In part 1, we examined it, and learned how to do a few …
Video
Shuffle - 1 - Examine Data in Access that was imported from Excel

Shuffle - 1 - Examine Data in Access that was imported from Excel

Examine data that was imported from Excel. Filter data in Access just like you do in Excel, for just…
Video
How to Install and Make an Add-in for Access

How to Install and Make an Add-in for Access

Learn how to install an add-in for Access. Add-ins can save time, and make your code more …
Video
import an Excel spreadsheet into an Access database

import an Excel spreadsheet into an Access database

Learn how to Import data from Excel into a Microsoft Access database using the wizard. Change data …
Video
Highlight the Current Record on an Access form with a Yellow background color

Highlight the Current Record on an Access form with a Yellow background color

Make it easier to see the current record on your Microsoft Access forms! To highlight the current …
Video
Wrapper-2, VBA.  Show result of Excel Worksheet Function in Access Query

Wrapper-2, VBA.  Show result of Excel Worksheet Function in Access Query

A query can call a function, and a function can call Excel, even though we are in Access. This is …
Video
Wrapper-1, Query.  Show result of Excel Worksheet Function in Access Query

Wrapper-1, Query.  Show result of Excel Worksheet Function in Access Query

Wrapper-1-Query. Use an Excel function to calculate a column for an Access query. Part 1. Shows a …
Video
How to incorporate Contact Management into an Access database?

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 …
Video
How to Bring Back the SQL Database from Suspect Mode to Normal Mode?

How to Bring Back the SQL Database from Suspect Mode to Normal Mode?

2018-01-22
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server …
Video
Repair Corrupt SQL Database with Stellar Phoenix SQL Database Repair Software

Repair Corrupt SQL Database with Stellar Phoenix SQL Database Repair Software

2018-01-226
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues…
Video
How To Insert Foreign and Special Characters when in Windows Applications

How To Insert Foreign and Special Characters when in Windows Applications

Enter Foreign and Special Characters

Enter characters you can't find on a keyboard using …
Video
How to Add a "Save As" icon to the Quick Access Toolbar

How to Add a "Save As" icon to the Quick Access Toolbar

How can you see what you are working on when you want to see it while you to save a copy?

Add a …
Video
How to Enforce Referential Integrity on Access Relationships

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 …
Video
Synchronize List Box in Access using SQL and VBA

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 …
Video
Subform to show Calculations in Microsoft Access

Subform to show Calculations in Microsoft Access

Look below the covers at a subform control , and the form that is inside it. Explore properties and …
Video
Mainform + Subforms designed for efficiency and flexibility

Mainform + Subforms designed for efficiency and flexibility

This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data …
Video
Some Basic Differences Between MySQL and MongoDB

Some Basic Differences Between MySQL and MongoDB

2017-07-281
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax …
Video
How Do You Implement High Availability in a Database Environment?

How Do You Implement High Availability in a Database Environment?

2017-07-28
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more