- Duration: 3 Hours
Course details
Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007. This course explains how SharePoint sites can be used with Access and demonstrates options such as moving data to a SharePoint site, publishing data to a SharePoint site, importing from or linking to a SharePoint list, creating an Access view of a SharePoint list, working offline with SharePoint lists, as well as tracking data versioning in SharePoint. Another feature of Access 2007 is its programmability. Using Access macros and Visual Basic for Applications (VBA) code you can easily add functionality to a database to suit your business needs. In addition to SharePoint integration, this course provides an introduction to programming in Access and explores when to use macros or VBA code to automate processes. It also demonstrates how to create, launch, and modify macros and explains the use of the Visual Basic Editor to create event handlers and set control property values.
- customize datasheets in Access 2007
- recognize how to compact and repair a database
- illustrate how to convert earlier Access database formats to Access 2007
- specify how to back up databases and restore database files
- customize the datasheet view in Access 2007
- convert an earlier Access database to Access 2007 format
- change the default file format of an Access 2007 database
- outline how to view and change object dependencies in Access 2007
- illustrate how to analyze objects for performance
- outline how to use the database documenter and the Table Analyzer wizard to optimize database performance
- use the performance analyzer
- use the Database Documenter
- use the Table Analyzer wizard
- view an object's object dependencies
- identify how to enable content for an Access 2007 database
- recognize how to hide a database object
- summarize how to encrypt a database by setting a database password
- restate how to protect VB code in Access 2007
- determine how to split a database and repair database links
- use an Office Access 2007 database in a trusted location
- restate how to package, sign, and distribute an Office Access 2007 database
- protect a database by setting a database password
- add a new location to the trust center
- split a database
- create a s
About New Horizons Lebanon
As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT and Business training company. Over the past 35 years, New Horizons has delivered a full range of IT and business skills/Management training through innovative learning methods that have transformed businesses and helped over 35 million students reach their goals. New Horizons Lebanon branch was established in 1996.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Office 2019 Bundle Compliance CentralUSD 31
USD 320Duration: Upto 1 Day - Microsoft Excel : VLOOKUP Formula Course DriveUSD 24
USD 160Duration: Upto 1 Hour
