Buy Dideo Subscription
Check out the full course at https://www.knowledgecity.com/en/library/CMP1136/course/access-2016-advanced. When you start your project, you should open your database in Exclusive mode. That way if anything goes wrong with the process, you will be protected from any mishaps that could occur when you split the database. The database will be split into the front-end section, which will contain forms, queries, reports and macros; the second half will be split into the back-end section, which will contain the data in the tables.Some of the reasons to split a database are for tighter security; many users can manipulate the data; it is easier to update; many users can work on the space at the same time; a split database is easier to upgrade. Take a look at the video to see how to split a database. Course Lessons Welcome Introduction Overview Advanced Form Design Overview Create a Form in Design View Modify Form Layout Add Controls to a Form Add Design Elements Add Command Buttons Control Tab Order Create Tab Pages Apply Conditional Formatting Data Validation Overview Setting Field Properties Creating an Input Mask Look-up List Advanced Reports Overview Create a Report in Design View Report Properties Organizing Reports Adding Charts Printing Reports Using Macros Overview Create a Macro Events Restrict Records Validating Data Automate Data Entry Convert Macros to VBA Working with Different Query Types Overview Action Queries Part 1 Action Queries Part 2 Crosstab Query Finding Duplicates Unmatched Queries Advanced Database Management Overview Link Excel Sheet to a Database Open a Database Exclusively Compact and Repair a Database Object Dependency Database Documenter Analyze Performance Secure and Distribute Overview Split a Database Set a Password Convert Database Using Switchboards Overview Switchboard Manager Create a Switchboard Add Design to a Switchboard Start-up Options Conclusion https://www.knowledgecity.com | Online Employee Training Platform. KnowledgeCity offers 12,000+ online video tutorials in Business, Computer, Safety, Compliance, and Finance. Subscribe to our YouTube Channel: https://www.youtube.com/user/knowledgeocity?sub_confirmation=1 Check our Blog: https://goo.gl/q47XKK Connect with KnowledgeCity! Twitter: https://goo.gl/wToC6s Facebook: https://goo.gl/3eMEq9 LinkedIn: https://goo.gl/vg1aXt Google+: https://goo.gl/Gjkffm
