Exam 77-424: Microsoft Access 2013 2.0 Build Tables 2.1 Create a Table: Import External Data into Tables (Excel spreadsheet)

Import Data into Access: Review the New Information Look before you leap. Many companies send spreadsheets with updated product information. Before you import any data in Microsoft Access, you should review it.   1. Try it: Review the New Data Start Microsoft Excel. Go to File->Open. Browse for the file: tblMoviesNEW.xlsx. Please open the spreadsheet.   What Do You See? There are 20 new movies in this spreadsheet. The first Row is the Header Row. It includes the following Fields: Movie, Year, Rating, Genre and Stars.   What Should You Be Looking For? These Field names MATCH the ones in the Access Table, tblMovies.   Close the spreadsheet. The next step is in Access. Microsoft Excel->Home