Join Alicia Katz Pollock for an in-depth discussion in this video Backstage view, part of Access 2010 Essential Training.
- View Offline
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.
- Understanding database concepts and terminology
- Building tables with Application Parts
- Defining field properties
- Creating relationships between fields and tables
- Sorting and filtering
- Creating forms with the Form Wizard
- Analyzing data with the Query Designer
- Automating with macros
- Formatting reports with Layout Tools