How To Migrate Data from Desktop to Access App
Channel: LearnAccessByCrystal
Date: 2015-06-09

This video shows you how you used to be able to migrate data from Access Desktop databases to Access Apps, which are now depreciated.  For a couple versions (2007 and 2010), Access could create 2 types of databases, Desktop Database and Web Databases (Access Apps).

The best way to migrate tables in your Access desktop database to the web using an Access App is to prepare the data on the desktop first.  This video shows you how to do that.

Steps to Migrate Data from desktop to web using Microsoft Access

.1. Make a Blank Desktop Database.
.2. External Data, Access - Import table Definition Only and change them
.2b. External Data, Access - Import table Definition and Data and change them
.3. Check Relationships! and fix 
.4. Link Tables -- Link to the tables with data 
.5. Create and Run Append Queries

.6. Check Data and Relationships.
.7. Use Update Queries to fix mistakes.
.8. Create a Custom Access App.
.9. Import tables from the desktop database 
    (hopefully, everything will be imported successfully)
.10. Views (Forms) will be created automatically.

See where to set an Application Title, choose an Application Icon, change Document Window to Overlapping Windows, how to get Perform name AutoCorrect and Track name AutoCorrect to stick.

Use Append Queries to move data, including creating AutoNumber values.

Use Update Queries to make batch changes to tables.

Use the Lookup Wizard and Enable Data Integrity when you define relationships that can move up to the web.

Filter the Navigation Pane for just the table you want to see.  

Show Direct Relationships to make the Relationships Diagram easier to layout and see self-joins.  Start with the lookups for the main table, then the main table (or tables), then related tables.  When you think you are done, click All Relationships on the ribbon.  Document your relationships diagram.

Launch the Import Wizard to import data and link to data in other databases.  See Linked Tables display in the Navigation Pane by the datasheet icon and arrow. A Datasheet View and List View is automatically created for every table when it is imported to an Access App. See what happens when table structure is modified.

Document relationships in a web database using a query.  Take a Screen Shot using the Print Screen key. 

Copy the URL of a web database to share with others.  See database in Site Contents on your SharePoint Team Site.
______________________________

I was one of the presenters for the Microsoft MVP Virtual Conference with Julian Kirkness, Brent Spaulding, and a special infusion by Patrick Wood.
A recording of the presentation is here: 
http://channel9.msdn.com/events/MVP-Virtual-Conference/MVP-Virtual-Conference-Americas-2015/CONS2-Using-Access-and-SharePoint-for-Travel-Expenses-and-Pulling-up-Maps 

The Access App reference downloads and presentation materials are posted here: 
http://gainingaccess.net/AccessWebRef.aspx 

The contacts database used in the demo, so you can try this yourself, if on the Free Access Tips and Tools page on http://msaccessgurus.com/index.html

Office 365 login page:
https://login.microsoftonline.com

* let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!

visit MsAccessGurus and contact me today!
http://msaccessgurus.com 

I look forward to hearing from you ~

have an awesome day,
crystal