Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.
The Backstage view is where you'll find all the commands for managing your database file. To use the Backstage view, click on the red File menu at the top left of the screen. Save, Open, and Close are right on top. If you need to rename your database or move it to a new location, you can use Save Database As. If you want to make a duplicate of one of your Tables, Forms, or Reports, use Save Object As. Here are your recently used databases, so you can open them with one click. The Info button gathers information and tools. It's dynamic.
It will change according to your database. Simple tools that may appear here include Compact & Repair, encryption, enabling content in SharePoint Publishing Services. The Recent button shows your recently opened files. And down here, you can specify how many of them you'd like to see in the menu on the left. The New button allows you to create a new Database from scratch or from a template. Print has all your printing options. Quick Print will send your objects straight to the Printer without a dialog box. Print will open up the Printing Options dialog box, allowing you to choose your printer, or your number of copies.
If you want to only print a certain set of records, you can highlight them first and then click here to print just that group. I'll click Cancel, go back to the File menu, and back to Print. Print Preview shows you what your page will look like when printed, and gives you the options for Paper Size, Margins, Portrait, and Landscape, zooming in to see it ,and more. You can even export from this window into an Excel file a delimited Text File, a PDF, or attach it to an e-mail.
Click the big red X to close the Print Preview and return to your database, and then click back on the red File tab again to return to Backstage view. The Save & Publish button allows you to convert the database to previous formats. And here are a number of advanced features that we will look at later in this course. You can use Package and Sign to attach a digital signature to confirm authenticity when you e-mail it to others. You can back up your database. Use the ACCDE button to create a stand- alone run-time application, allowing others to use your database even if they don't have Access on their computers, and click here to save your database to a SharePoint server.
If I click on Publish to Access Services, you can convert your database to a Web-based file, so you can publish it on the Internet via a SharePoint server. Help has been brought down to this menu. And here are Access's Options both of which we will explore in future lessons, back again to File. And here is the Exit button to quit Access, although you can also use the big red X in the upper right-hand corner. The Backstage view is a comprehensive zone for working on your database file itself.
Find answers to the most frequently asked questions about Access 2010 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.