If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels. Note for Mac Users: Access 2013 does not work on Mac OS.
Microsoft access for mac 2013 software#
Course software requirements with the appropriate versions are listed under the course materials site. This software is not provided by the course material grant and must be purchased/provided by the student. Students must have access to Microsoft Access software. This course focuses on developing Microsoft Access Switchboard applications it includes: designing and building form and report interfaces, interfacing the Access database to a web page, building dynamic web pages, integrating Access with other Office applications such as Excel, building pivot tables and charts, categorizing the various types of join operations, examining the rudiments of the Visual Basic for Applications (VBA) code, debugging VBA code, creating macros and functions, and designing Access applications. APUS recommends using Windows OS even on Mac. This course also explores distributed databases, Online Analytic Processing (OLAP) systems, data warehouses, and object-oriented databases. This course examines database design, normalization for OLTP systems, Codd’s rules for OLTP systems, data integrity, database system functions (journaling, forward recovery, backward recovery), database security (authentication and authorization), and database administration. Topics include data definition, data manipulation, relational algebra, Structured Query Language (SQL), and Online Transaction Processing (OLTP) systems. This course is an introduction to the concepts, management issues, and advantages of relational database management systems.
The book meets the topical requirements for the Microsoft Office Specialist (MOS).
They will also examine and develop advanced queries such as: top values, list of values, cross tab, find duplicates, and find unmatched. They will examine the rudiments of referential integrity and normalization, and apply this knowledge to design the database tables that implement validation rules to ensure application integrity. Students will apply their knowledge of the principles of data design and database engineering to design and develop a database application that includes user interfaces, form design, data analysis, and data presentation. This course introduces the student to the concepts of relational databases and to the principles of relational database design in the context of the Microsoft Access Relational Database Management System (RDBMS). The course will be taught from a mixture of analytical and practical methods. This course focuses on the role, function, and operations of relational databases in the management of information.
0 kommentar(er)
