This video shows you How To Migrate Data from Desktop to Access App. Access can create 2 types of databases, Desktop Database and Web Databases, now called 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.
In May, I was one of the presenters for the Microsoft MVP Virtual Conference.
My co-presenters were Julian Kirkness, Brent Spaulding, and a special infusion by Patrick Wood.
A recording of the presentation is here: http://channel9.msdn.com/ev...
(Brent's link presentation will be made available)
The Access App reference downloads and presentation materials are posted here: http://gainingaccess.net/Ac...
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/in...
Office 365 login page:https://login.microsoftonli...
Through sharing we will all get better
~ have an awesome day ~