Download Microsoft Access 2013 Cheat Sheet and more Cheat Sheet Microsoft Access Skills in PDF only on Docsity! Microsoft ® Access 2013 Cheat Sheet Create a Database: -Click a template category in the list and click the template you want to use and click Create -Click Blank Database button Open Existing Database: -Click a database in the Open Recent Database list or click More and browse for it Program Layout Getting Started Window File Tab Quick Access Toolbar Ti t le Bar M i n im i ze Max im ize C lose Ribbon Status Bar Navigation Pane Object Tabs Record Navigator Table in Datasheet View Cus tom ize the Qu ick Access Too lbar to ho ld comm and s such as Save, Prin t, Undo, Red o, Co py and Paste. File Tab & Backstage View: Hold s the o p t i o n s to s t a r t a new database, o p e n a sa v ed f i l e, s a v e, p r i n t, p r e pa re fo r d i s t r i b u t i o n, p u b l i sh t h e database, c l ose t h e pr og ram an d sh ow recen t l y v i ewed databases Views Create New Database: Click Fi le Tab, select New Open Exist ing Database: Click Fi le Tab, select Open Save a Database: Click Fi le Tab, select Save Save with a different name: Click Fi le Tab, select Save As Print Preview: Click Fi le Tab, select Print Preview Print: Cl ick Fi le Tab, select Print Navigation Keyboard Shortcuts: Tab : Move to next f ield Shift + Tab : Move to previous f ield F 11: Toggle the Navigation Pane Keys to Remember: Backspace: Erases back one space Delete: Erases forward one space Num Lock: Controls the 10-key pad Choose Template Category Open Existing Database Create Blank Database Select a Template Program Basics Database Objects Create Tab Tables Grou p Forms Grou p Reports Grou p Macros & Code Group Table Form ReportQuery Tables: Add New Blank Table: Click the Table icon in the Tables Group Add New Table from a Template: Click the Application Parts icon in the Templates Group and choose a template from the list Edit Table Design: Click the Table Design icon in the Tables Group and you will be taken to Design View Forms: Add New Form: Click the Form icon in the Forms Group Add Split Form: Click the More Forms icon in the Forms Group Add Blank Form: Click the Blank Form icon in the Forms Group Edit Form Design: Click the Form Design icon in the Forms Group Forms: Are custom screens that provide an easier way to enter and view data Reports: Present data from a table or query in a printed format Query: Create New Query: Click the Query Wizard icon in the Query Group Edit Query Design: Click the Query Design icon in the Query Group Reports: Add New Report: Click the Report icon in the Reports Group Add Blank Report: Click the Blank Report icon in the Reports Group Edit Report Design: Click the Report Design icon in the Reports Group Open Report Wizard: Click the Report Wizard icon in the Reports Group Using Database Objects: Open an object: Double-click the object in the Navigation Pane Modify an Object: Open the object, click the Format tab on the Ribbon, click the View button in the Views group and choose Design or Layout view Delete an Object: Select the object and press Delete and click Yes Rename an Object: Right-click the object, select rename, enter new name and press Enter Import & Export Data: Use the External Data tab on the Ribbon Tables: Store related data in records (rows) and f ields (columns) Queries: View, f ilter, calculate, change, sort and examine data in a table Queries GroupTemplates Group