This Microsoft Access 2013 for Developers test is designed to assess the knowledge of developers working in the Access 2013 environment. Topics covered include design, query writing, requirements/features, data, reports and forms, and database. It is appropriate to administer this assessment to MS Access 2013 developers who have a year or more of experience. Microsoft Access 2013 is also available and is considered to be more of a user test. Total Questions 42 Question Types Multiple Choice Competencies Tested Requirements/FeaturesDataQuery WritingReports and FormsDesignDatabase Tasks Tested Design ToolsAccess 2013 InstallationMicrosoft Access 2013 WizardsCloud StoragePrimary KeysData TypesPre-existing ValuesEnforce Referential IntegrityAccessing External DataExporting DataJoining TablesSQL Statement ClausesSELECT Statement in a SQL StatementJoinsHaving ClauseScripting LanguageParameter PurposeOrdering Data with Largest Value on TopInvalid SQL KeywordResult SetValid Report DataReport View that Matches Printed VersionExporting FormatsAction and EventsValid Field TypesRelationship ViewThird Normal FormField TypePrimary KeyPivot TablesBuilding an AppTable RelationshipsField Property that Limits ValuesMany-to-Many RelationshipDatabase BackupDatabase File ExtensionTool to Replace File with Compacted FileIndex Field PropertyObject DependenciesMax Database SizeNew Database CreationDatabase Format
