In this movie, Adam will show you how to bring data about the Landon’s guests from an Excel spreadsheet and move it into an Access database using the import wizard from the External Data tab of the ribbon. The wizard will create a new table, define the fields and assign data types, and import the data all at once.
- [Voiceover] If you already have data…stored in a spreadsheet then there's no reason…to manually recreate it in Access.…You could use the tools available…on the External Data tab of the ribbon…to bring that data in and create the…tables to store it in one step.…Right now I'm looking at the Guests Excel file…from the chapter two folder of the exercise files.…I'd like to import this data about the…Landon Hotel's guests into the Access database…that we started in the last movie.…In order to streamline the process…I wanna verify that the first row in the spreadsheet…contains the names that I wanna apply…to the columns in Access.…I also wanna verify that the data that I wanna import…will start on row two here in Excel.…
Finally, I wanna make sure that there aren't any…extraneous values typed into other portions…of the Excel worksheet which might…confuse the import procedure.…When you're satisfied that the spreadsheet is cleaned up…and ready to go, it's time to switch over to Access.…To import the data in Access,…I'm gonna come up here to the External Data tab.…
If you need a deeper dive into the topics discussed, check out Adam's Office 365: Access 2016 Essential Training course.
- Loading a premade template database
- Exploring the interface
- Defining data types
- Creating tables
- Defining table relationships
- Editing forms
- Creating queries and reports
- Editing reports in Layout view