Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
The story of punk rock singer Laura Jane Grace of Against Me! who came out as a woman in 2012, and other members of the trans community whose experiences are woefully underrepresented and misunderstood in the media.
Documentary shorts conceived of and directed by famous actors. Jeff Garlin, Katie Holmes, Alia Shawkat, Judy Greer, and James Purefoy
Park Bench is a new kind of "talking show" straight from the mind of born and bred New Yorker and host, Steve Buscemi.
Digital influencer Justine Ezarik (iJustine) is back. After covering the world of wearable tech last season, iJustine is expanding her coverage this year by profiling the hottest tech trends across the country.
Enter the graceful but competitive world of ballet through the eyes of executive producer, Sarah Jessica Parker. This behind-the-scenes docudrama reveals what it takes to perform on the ultimate stage, the New York City Ballet. Catch NYCB on stage at Lincoln Center.
Nicole Richie brings her unfiltered sense of humor and unique perspective to life in a new series based on her irreverent twitter feed. The show follows the outspoken celebrity as she shares her perspective on style, parenting, relationships and her journey to adulthood.
Explore what it means to be human as we rush head first into the future through the eyes, creativity, and mind of Tiffany Shlain, acclaimed filmmaker and speaker, founder of The Webby Awards, mother, constant pusher of boundaries and one of Newsweek’s “women shaping the 21st Century.”
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity.
Hank Azaria’s touching, humorous, and often enlightening journey from a man who is not even sure he wants to have kids, to a father going through the joys, trials and tribulations of being a dad.
ACTING DISRUPTIVE takes viewers inside the businesses and passion projects of Hollywood’s top celebrities.
Follow Scott Schuman, the Sartorialist, from the streets of NYC to the capitals of Europe on his quest to photograph and document the best in culture and fashion.
Go behind-the-scenes with racing's hottest, young talent, 17-year-old Dylan Kwasniewski, as he aspires to make it in the #1 motorsport in America – NASCAR
How to use Microsoft Access - Importing Tables - part 7 of 13 in this educational video from dizzo95.
Tags:Microsoft Access - Importing Tables - part 7 of 13,dizzo 95,dizzo95,dr dan izzo,education,importing tables,microsoft access,part 7 of 13,software
Grab video code:
We've created the customers table, now we need the invoices table. We’ll get this data from another program with access you can use data you’ve already entered in other programs such as spreadsheets or other database programs. There are two basic ways to do this, you can either import data meaning bring data into access and make it an access table, or your can link to data in which case the data remains in its original program but you can use access to work with it. We’d use the spreadsheet program Microsoft excel 97 to create a work sheet with invoice information.
We want to move that information into our access data base so we’ll import the invoice worksheet. We click on the file menu and select get external data. From the submenu we’ll choose import and when we do the import dialog box opens. To display any excel files we open the files of type list, we’ll select Microsoft excel and when we do the excel files display. We’ll import the invoices file. We double click on it and the import spreadsheet wizard dialog box opens.
The wizard’s displays the spreadsheet data the import wizard asks if the first row contains column headings that can be used as field names for the table. This is what we want, so we click in the check box the labels in the first row become column headings. Then we click on next to move to the next import dialog box. It asks if we want our data in a new table or added to an existing table. We want a new table so we leave that selected, we click on next. This dialog box lets us set the field name and indexing for each field. The data type is grade out because its already set in the excel worksheet. We move on to the next dialog box. Here the wizard ask for a primary key. The default setting is for access to add one. We’d like the invoice field to be the primary key field. This way we don’t have to worry about duplicate invoice numbers.
We click on choose my own primary key and access suggest the first field invoice number. We could choose another field but that’s the one we want. The wizard highlights the selected field we click on next. The final wizard dialog box lets us give the table a name. So we type invoices in upper and lower case, which we prefer. We click on the finish button access displays a message box telling us the importing is completed. So we click on okay.
The worksheet is now an access table, to open the table we double click on it. Here is our imported invoices table. The table is an invoice number order with the costumer ID in voice total and due date. Now notice the text information is left justified, while numerical data and date information are right justified. We’ll best fit all of the columns now. And now we can format and edit this table just as if we created in access. The invoices table is setup the way we want it and in the next topic were going to use access to create a relationship between the invoices table and the customers table.