-->
Home FREE SKILL DEVELOPMENT TRAINING'S LAB ASSIGNMENT

Microsoft Access 2007 Day One

Microsoft Access 2007
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.

Software developers, data architects and power users can use Microsoft Access to develop application software. Like other Microsoft Office applications, Access is supported by Visual Basic for Applications (VBA), an object-based programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating system operations.

File extensions: Current Format 

File format
Extension
Access Blank Project Template.adn
Access Database (2007 and later).accdb
Access Database Runtime (2007 and later).accdr
Access Database Template (2007 and later).accdt
Access Add-In (2007 and later).accda
Access Workgroup, database for user-level security..mdw
Protected Access Database, with compiled VBA andr macros (2007 and later).accde
Windows Shortcut: Access Macro.mam
Windows Shortcut: Access Query.maq
Windows Shortcut: Access Report.mar
Windows Shortcut: Access Table.mat
Windows Shortcut: Access Form.maf
Access lock files (associated with .accdb).laccdb


File extensions: Legacy formats 

File format Extension
Protected Access Data Project (not supported in 2013).ade
Access Data Project (not supported in 2013).adp
Access Database (2003 and earlier).mdb
Access Database (Pocket Access for Windows CE).cdb
Access Database, used for addins (Access 2, 95, 97),previously used for workgroups (Access 2).mda
Access Blank Database Template (2003 and earlier).mdn
Access Add-in Data (2003 and earlier).mdt
Access (SQL Server) detached database (2000).mdf
Protected Access Database, with compiled VBA and macros (2003 and earlier).mde
Access lock files (associated with .mdb).ldb