book

Access® 2013 on Demand

by Perspection Inc. Steve Johnson

May 2013

Intermediate to advanced

448 pages

16h 24m

English

Que

Read now

Unlock full access

About the AuthorWe Want to Hear from You!
How This Book WorksWhat’s NewKeyboard ShortcutsStep-by-Step InstructionsReal World ExamplesWorkshopsMicrosoft Office SpecialistGet More on the Web
IntroductionUnderstanding How Databases Store DataStarting AccessUsing the RibbonChoosing CommandsWorking with the Ribbon and ToolbarsChoosing Dialog Box OptionsUsing the Status BarCreating a DatabaseOpening a DatabaseConverting an Existing DatabaseViewing the Access WindowArranging WindowsUsing Task and Window PanesGetting Help While You WorkSaving a DatabaseSaving a Database with Different FormatsWorking with AccountsWorking with Online StorageClosing a Database and Exiting Access
IntroductionOpening a Sample DatabaseWarnings About Macros and Add-InsUsing a SwitchboardChanging Database Display OptionsViewing Database ObjectsWorking with Database ObjectsGrouping and Hiding Database ObjectsTouring a TableTouring a FormEntering DataTouring a QueryTouring a ReportSwitching Views
IntroductionCreating a Custom Database TemplateUsing a Custom Database TemplatePlanning TablesCreating Tables in a DatabaseCreating a Table by Entering DataCreating an Application Part Using a TemplateImporting Data into TablesLinking to Data in TablesWorking with Table RecordsWorking with a Table in Design ViewSpecifying a Primary Key in Design ViewPlanning Table RelationshipsDefining Table RelationshipsCreating and Printing a Table Relationship ReportEnsuring Referential IntegrityIdentifying Object DependenciesModifying Object Dependencies
IntroductionInserting FieldsWorking with FieldsSpecifying Data Types and Field PropertiesViewing Field PropertiesChanging Field PropertiesUpdating Field PropertiesSetting Field SizeFormatting Text ValuesFormatting Long Text with Rich TextFormatting Date and Time ValuesFormatting Number and Currency ValuesPerforming a Total CalculationCreating Input MasksCreating Indexed FieldsSpecifying Required Fields and Default ValuesAdding a Caption to a FieldValidating Field ValuesCreating a Lookup FieldSetting Lookup PropertiesCreating a Multivalued FieldAttaching Files to Field RecordsCreating a Field Data Type TemplateSetting Table Properties

IntroductionWorking with TablesRepairing Renaming ErrorsManaging Linked TablesWorking with the ClipboardEditing TextEntering Data Accurately with AutoCorrectFinding and Replacing TextChecking SpellingUsing Custom DictionariesFormatting a DatasheetArranging Field ColumnsChanging the Size of Field ColumnsManaging Fields ColumnsSorting RecordsViewing a SubdatasheetFiltering Out RecordsCreating Complex Filters Using Forms
IntroductionUnderstanding Types of QueriesCreating a Query in Design ViewGetting Information with a QueryModifying a Query in Design ViewCreating a Query Using a WizardChanging the Query FieldsSpecifying Criteria for a Single FieldSpecifying Criteria for Multiple FieldsCreating Queries with Comparison and Logical OperatorsPerforming Calculations in QueriesCreating a Parameter QueryFinding Duplicate FieldsFinding Unmatched RecordsCreating New Tables with a QueryAdding Records with a QueryDeleting Records with a QueryUpdating Records with a QuerySummarizing Values with a Crosstab QueryCreating SQL-Specific Queries
IntroductionCreating FormsWorking with Form ControlsCreating a FormCreating a Blank FormCreating a Form Using the Form WizardCreating a Navigation FormCreating a Multiple Items FormCreating a Datasheet FormCreating a Dialog FormCreating a Split FormEntering and Editing Data in a FormWorking with a Form in Layout ViewWorking with a Form in Design ViewModifying a FormAdding Existing FieldsAdding and Modifying ControlsAdding Controls with a WizardCreating a SubformEnhancing a FormWorking with Themes on FormsUsing Windows Themes on Forms
IntroductionExploring Different Ways to Create a ReportCreating a ReportCreating a Blank ReportCreating Mailing LabelsUsing Sections in Design ViewWorking with ControlsCreating and Modifying a Report in Design ViewUsing Buttons and ControlsArranging InformationInserting a Title, Page Numbers, or the Date and TimeInserting a Picture as a LogoSetting PropertiesPerforming Calculations in ReportsGrouping and Sorting in ReportsInserting a Header or FooterAssigning a Shortcut Key to a ControlChecking for Errors in Reports and FormsChanging the Page SetupPreviewing InformationPrinting Information
IntroductionApplying a Theme to a Form or ReportCreating a Custom ThemeFormatting a Form or ReportAdding Lines and RectanglesChanging Line or Border Thickness and StyleChanging ColorsApplying Styles, Shapes, and EffectsApplying Special EffectsApplying the Format PainterApplying Conditional FormattingChanging Tabbing OrderResizing and Moving ControlsAligning ControlsPositioning ControlsGrouping and Ungrouping ControlsChanging GridlinesCreating a Tabular or Stacked LayoutChanging Control Margins and PaddingChanging Control Rows and ColumnsSharing Information Among DocumentsCopying and Pasting ObjectsInserting a New ObjectInserting an Object from a FileInserting a PictureInserting Excel Charts and WorksheetsInserting a Graph ChartFormatting Chart ObjectsMoving and Resizing an ObjectSetting OLE Options
IntroductionIntegrating Access and the InternetCreating a Hyperlink FieldInserting a Hyperlink to a File or Web PageBuilding a Hyperlink with ExpressionsLinking to an Object in a DatabaseCreating a Hyperlink to an E-mail AddressNavigating HyperlinksWorking with HyperlinksInserting a Web Browser ControlExporting Database Objects to HTMLImporting or Linking to an HTML FileCreating a Table Using SharePointImporting or Linking to SharePoint DataExporting Data to SharePointMoving Data to SharePointWorking with SharePoint Data OfflinePublishing a Database to SharePoint
IntroductionImporting and Linking DataSaving Import and Export SettingsImporting or Linking Data from an Access DatabaseImporting or Linking Data from ExcelImporting or Linking Data from a Mail ProgramGetting Data from Other SourcesImporting and Exporting XML DataExporting Data to Other ProgramsMerging Data with WordExporting Data to ExcelCreating a PDF DocumentCreating an XPS DocumentSaving a Database Object
IntroductionBacking Up a DatabaseCompacting and Repairing a DatabaseChanging Database PropertiesDocumenting a DatabaseAnalyzing a DatabaseWorking with Add-InsSetting Database Application OptionsSplitting a Database
IntroductionAdding Security Encryption to a DatabaseCreating a Digital CertificateAdding a Digital Signature to a DatabasePackaging and Digitally Signing a DatabaseAvoiding Harmful AttacksUsing the Trust CenterSelecting Trusted Publishers and LocationsSetting Document Related Security OptionsSetting ActiveX Security OptionsSetting Add-In Security OptionsSetting Macro Security OptionsChanging Message Bar Security OptionsSetting Privacy OptionsLocking a DatabaseLocking Database Records
IntroductionSetting Current Database OptionsSetting Object Designers OptionsSetting Database File OptionsSetting Editing OptionsChanging Datasheet Formatting OptionsSetting Office OptionsSetting General OptionsWorking with Touch ScreensAccessing Commands Not in the RibbonUsing Multiple LanguagesWorking with Office ToolsMaintaining and Repairing Office
IntroductionAutomating a Database with MacrosCreating or Editing a MacroRunning and Testing a MacroCreating a Macro GroupCreating a Macro ConditionAdding Comments to a MacroCreating a Message BoxAssigning a Macro to an EventAssigning a Macro to a ButtonAssigning a Macro to a ToolbarExtending a Database with VBACreating a ModuleViewing the Visual Basic EditorCreating a Sub ProcedureWriting VBA CommandsRunning a Sub ProcedureCopying Commands from the Object BrowserCreating a Custom FunctionRunning a Custom FunctionCreating a Class Module for a Form or ReportSetting Project PropertiesDebugging a ProcedureIdentifying VBA Debugging ToolsOptimizing Performance with an ACCDE File
IntroductionCreating a Web AppOpening a Web AppAdding Tables and Data to a Web AppViewing and Editing Data in a Web AppCreating a View in a Web AppModifying a Web AppChanging Properties in a Web AppCreating Actions in a Web AppCreating Database Objects in Web AppsUsing the Navigation Pane with Web AppsLaunching a Web App in a Web BrowserPackaging a Web AppWorking with a Web App on SharePointChanging Web App Settings on SharePointAdding a Web App from the SharePoint Store
IntroductionWorking Online with SharePoint and SkyDriveSigning in to SharePoint or SkyDriveSaving and Opening on SharePoint or SkyDriveAccessing Documents on SharePointSyncing Documents on SharePointSharing Documents on SkyDriveAccessing Documents on SkyDriveManaging Documents on SkyDriveDownloading or Uploading Documents on SkyDriveCreating Office Documents on SkyDriveSending Links to Documents on SkyDriveComparing the Office Desktop App to the Web AppWorking with Office Web AppsSaving or Printing Documents in Office Web AppsCo-authoring Documents with Office Web AppsBlocking Co-authoring Documents
Microsoft Access 2013
About the MOS ProgramWhat Does This Logo Mean?Preparing for a MOS ExamTaking a MOS ExamGetting More Information

Content preview from Access® 2013 on Demand

3. Planning and Creating a Custom Database

What You’ll Do

Create a Custom Database Template

Use a Custom Database Template

Plan Tables

Create Tables in a Database

Create a Table by Entering Data

Create a Table Using a Template

Import Data into Tables

Link to Data in Tables

Working with Table Records

Work with a Table in Design View

Specify a Primary Key in Design View

Plan Table Relationships

Define Table Relationships

Create and Print a Table Relationship Report

Ensure Referential Integrity

Identify Object Dependencies

Modify Object Dependencies

Introduction

The Microsoft Access database wizards make creating databases easy, but you may need to create a database that does not fit any of the predefined template choices. In that situation, ...