Sharing documents with others sometimes means saving or exporting data in alternate formats. In this video, how to export data in PDF format and move it to a new Excel workbook. Additionally, discover how to format data into two columns before printing.
- [Instructor] Your database has tables, forms, and reports … that you'd probably like to share with others. … In this video I'll show you how to prepare … and print your records, forms, and reports. … I'll show you how to export the data … in alternate formats such as Excel or a PDF file. … And I'll also show you how you can display … the data in two or more columns, … which makes the information much easier to read. … Let's jump right into our print and export database … and take a look at our employee information table. … Now, if I want to pull just one record … out of this table and save it as a PDF file, … I first select the record, we'll do Lisa Hunter, … and on the external data tab under export, I'll select PDF. … I'll select the record and go to PDF in the export group. … I want to navigate to the Desktop, … go into my exercise files into chapter two, … let me rename the file Employee Information. … I do want to open the file after publishing … so we can take a look at it. … Notice that you have two options, a standard option, …
- Modifying the database structure
- Managing table relationships and keys
- Exporting data
- Managing records and fields
- Creating and running queries
- Configuring form controls
- Modifying form positioning
- Grouping report fields
- Formatting reports
- Taking the practice exam
Skill Level Intermediate
1. Microsoft Office Specialist (MOS) Exam Overview
2. Managing Databases
3. Create and Modify Tables
4. Create and Modify Queries
5. Modify Forms in Layout View
6. Modify Reports in Layout View
7. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.