Access databases can contain macros and visual basic code that is typically needed to ensure that the database functions as intended, but can potentially contain malicious routines. In this movie, Adam shows you how to add the exercise files to a trusted location so that Access will allow them to run.
- [Voiceover] Access databases can contain macros and Visual Basic code that is typically needed to ensure that the database functions as intended. This code is written in the Visual Basic programming language and it's possible, though rare, that the code in an Access database can contain malicious routines. Because of this, Microsoft requires that you specifically white-list each and every database file that you start up. You'll see this presented every time you open an exercise file by this yellow bar across the top of the screen. You can press the Enable Content button to trust that single file, but you'll have to do this for every file that we open.
Rather than do that for each and every one of the databases that we'll use throughout this course, I'd like to make one small change to the program settings which will grant the required permissions to all of our exercise files at once. To do this, we'll come over here to the File tab, and then we'll come down to Options. In the Access Options window, we're going to find the Trust Center setting here at the bottom, then come over to the far right and press Trust Center Settings. On the Trust Center Settings window, we're going to come up here to the top and press Trusted Locations, and then come down here to the bottom and add a new location. I'm going to press the Browse button here and browse onto my Desktop which is where I've stored the exercise files for me.
Go ahead and scroll down here and select the Exercise Files folder and press OK. Then, make sure you check this box here that says Subfolders of this location are also trusted. This way all of the files within the chapter folders are also trusted. I'm going to add a description here to remind myself of why I'm adding this trusted location, and I'll just called Access 2016: Forms and Reports in Depth. Go ahead and press OK, and OK again, and OK one more time. So now that our exercise databases are trusted by Access, we can get to the business of exploring forms and reports without the constant interruption.
Author
Released
7/6/2016Then the course dives into reports: creating efficient and readable layouts, grouping data into categories, tying reports to queries, and using conditional formatting rules to highlight key takeaways from the data. Finally, Adam demonstrates how to link forms and reports and print your results, and introduces unique ways to save time filling out paperwork and generating form letters.
- Creating forms with the Form Wizard
- Formatting and aligning form objects
- Combining text boxes
- Adding a header and labels
- Controlling input
- Adding attachments and images
- Linking form controls
- Creating menus and data entry forms for the database
- Building reports
- Creating calculation fields
- Linking forms and reports
- Printing and exporting reports
- Creating a form letter
Skill Level Intermediate
Duration
Views
Related Courses
-
Access 2013 Essential Training
with Adam Wilbert5h 4m Beginner -
Access 2013: Tips & Tricks
with Adam Wilbert2h 50m Intermediate
-
Introduction
-
Welcome1m
-
-
1. Introduction to Forms
-
2. Form Design Basics: Creating an Employee Directory
-
Organize the form design7m 27s
-
Object alignment5m 1s
-
Anchor controls3m 30s
-
Modify form properties5m 44s
-
Combine text boxes2m 42s
-
Add a form header4m 47s
-
-
3. Form and Report Controls
-
Label control6m 22s
-
Lines and rectangles6m 8s
-
Button controls7m 23s
-
Link to external content5m 38s
-
Select data with a combo box9m 37s
-
Attach external documents6m 23s
-
Add images to a form5m 51s
-
Embed a subform control5m 11s
-
Display a chart6m 39s
-
Link form controls6m 12s
-
Edit the Tab Stop sequence4m 35s
-
-
4. Getting Around the Database
-
Create a main menu5m 41s
-
Refine button macros4m 19s
-
Create a data entry form7m 1s
-
Finalize the customer form4m 58s
-
-
5. Report Layout
-
Build a report from a query3m 55s
-
Create calculation fields4m 44s
-
Add a report header5m 7s
-
Segment data into groups5m 43s
-
6. Linking Forms and Reports: Creating a Profit Summary
-
Build the query4m 56s
-
Create the report structure4m 49s
-
Add data to the report8m 54s
-
Connect the form6m 21s
-
Connect the query3m 35s
-
-
7. Printing and Exporting Reports
-
8. Populating Business Documents
-
Prepare the scanned template1m 36s
-
Construct the I-9 report5m 36s
-
Create a form letter5m 22s
-
-
Conclusion
-
Next steps59s
-
- 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: Add exercise files to a trusted location