Join Alicia Katz Pollock for an in-depth discussion in this video Toggling between Design and Data views, part of Access 2010: Shortcuts.
When you're building a database, you will frequently switch back and forth between the Design View where you build the structure of the table, form or report and it's data view, where you actually use it. Access gives you a variety of methods of moving back and forth between the two. When you double-click on an object, let's say a table in the Navigation pane, it defaults to opening in Data View, handy for working on your data immediately. If you need to switch to the Design View to work with the structure of that table, go up to the very first button on the Home Ribbon. You will see a button with an architect's triangle and a pencil on it.
Click on this button, right on the triangle and your view will switch to Design View. To go back to the datasheet, simply click that button again. You will notice that the button has a dropdown arrow underneath it. Click on that dropdown and you also have options to switch to a PivotTable or a PivotChart View, as well as Design View. These two options are available when you're working on a table. Let's open up the form to see how this works on a form. I want to scroll down to the Forms and I will choose my Product Split Form. I will double-click on it and it opens, and now the button in the corner gives me the option of going to the Layout View or back to the Datasheet View and if I click on the dropdown, I also have the option of going straight to Design View.
So as you can see, each of the different objects types, Tables, Forms, Queries and Reports will all have two main views to toggle with the top half and a wider variety with the dropdown arrow. But that's just the first way to move between the two. Here are a few more. Look down in the lower right-hand corner of your window. There are little buttons down here to toggle between each of your views. If you don't see these buttons, right- click on the bar and put a check mark in front of View Shortcuts. If you right-click on an Objects tab, you can also change the view from there and if you right-click on an object in the Navigation pane, you can also open up directly into the view that you like.
I use that technique a lot. If you're working in the contextual ribbons, the ones that open when you are in Design View or Layout View, the first tab will always have a toggle to go back and forth between your views. And when you're working on a form in Design View here is one more powerful option. See this little box in the upper left -hand corner between the horizontal and vertical ribbons. If I right-click on that, I also have View selectors there as well. Note however that that option only shows up in the Design View on Forms and Reports.
It doesn't work on Tables or Queries on in Datasheet or Layout Views. Knowing a variety of methods to toggle between your object views will definitely speed up your development time.
Author
Released
2/8/2011- Creating new field with field templates
- Understanding errors
- Filtering data
- Aligning and distributing controls
- Customizing the interface
- Navigating quickly between records
- Speeding up data entry
- Analyzing a table for redundant data
- Creating a multi-field primary key
- Moving records with append and delete queries
- Transforming a query into a PivotTable or PivotChart
- Working with images, charts, and Smart Tags in forms
- Hiding duplicates in reports
- Formatting shortcuts
- Using macros
Skill Level Intermediate
Duration
Views
Related Courses
-
Access 2010: Queries
with Adam Wilbert3h 2m Intermediate -
Setting Up a Database in Excel 2010
with Dennis Taylor43m 23s Appropriate for all -
Excel 2010: Pivot Tables
with Curt Frye3h 43m Intermediate -
Excel 2010: Data Validation
with Dennis Taylor59m 38s Intermediate
-
Introduction
-
Welcome47s
-
-
1. Top Tips
-
Using input masks2m 39s
-
Four ways to filter data2m 56s
-
2. File Management
-
Opening recent files2m 33s
-
-
3. Ribbon and Quick Access Toolbar Tips
-
4. Interface Shortcuts
-
Right-clicking2m 47s
-
Using keyboard shortcuts2m 50s
-
5. Navigation Shortcuts
-
6. Data Entry and Editing Shortcuts
-
Undo and Redo tips2m 18s
-
Copying and pasting content2m 44s
-
Inserting today's date1m 10s
-
Using AutoCorrect1m 36s
-
Using concatenated fields2m 16s
-
Linking Outlook contacts2m 23s
-
-
7. Table Techniques
-
Creating Quick Start fields1m 49s
-
Saving application parts2m 43s
-
Setting default field types2m 55s
-
Using flag fields2m 1s
-
Using an index2m 4s
-
Filtering by selection1m 25s
-
8. Relationship Techniques
-
Using subdatasheets1m 27s
-
Using relationship reports1m 55s
-
9. Query Techniques
-
Using wildcards5m 40s
-
Using IN instead of OR1m 29s
-
Changing captions1m 30s
-
Finding duplicate records2m 13s
-
Using make-table queries2m 12s
-
Creating an update query2m 55s
-
Using SQL statements2m 31s
-
-
10. Form Techniques
-
Creating option groups2m 43s
-
Creating tabbed form layouts4m 45s
-
Inserting charts3m 41s
-
Creating your own smart tags1m 24s
-
Hiding fields in printouts1m 26s
-
Setting tab stops3m 41s
-
11. Report Techniques
-
Creating headers and footers5m 49s
-
12. Formatting Shortcuts
-
Using the Format Painter2m 25s
-
13. Macro and Event Techniques
-
Using AutoExec macros1m 53s
-
14. Database Management Techniques
-
Saving templates2m 10s
-
Locking files42s
-
-
Conclusion
-
Goodbye44s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Toggling between Design and Data views