book

Microsoft® Access® 2013 Step by Step

Name: Microsoft® Access® 2013 Step by Step
Author: Joan Lambert and Joyce Cox
ISBN: 9780735675445

by Joan Lambert and Joyce Cox

February 2013

Beginner

448 pages

10h 12m

English

Microsoft Press

Read now

Unlock full access

Table of Contents
Introduction
Who this book is forHow this book is organizedDownload the practice filesYour companion ebookGet support and give feedbackErrataWe want to hear from youStay in touch
I. Simple database techniques
1. Explore Microsoft Access 2013
Identifying new features of Access 2013If you are upgrading from Access 2010If you are upgrading from Access 2007If you are upgrading from Access 2003Working in the Access 2013 user interfaceIdentifying program window elementsWorking with the ribbonUnderstanding database conceptsExploring tablesExploring formsExploring queriesExploring reportsPreviewing and printing database objectsKey points
2. Create databases and simple tables
Creating databases from templatesCreating databases and tables manuallyManipulating table columns and rowsRefining table structureDefining relationships between tablesKey points
3. Create simple forms
Creating forms by using the Form toolFormatting formsArranging the layout of formsKey points
4. Display data
Sorting information in tablesFiltering information in tablesFiltering information by using formsLocating information that matches multiple criteriaKey points
5. Create simple reports
Creating reports by using a wizardModifying report designPreviewing and printing reportsKey points
II. Relational database techniques
6. Maintain data integrity
Specifying the type of dataSetting the field sizeRestricting the format of dataValidating the dataAllowing only values in listsAllowing only values in other tablesKey points

7. Create queries
Creating queries by using a wizardCreating queries manuallySummarizing data by using queriesCalculating by using queriesUpdating records by using queriesDeleting records by using queriesKey points
8. Create custom forms
Modifying forms created by using a wizardAdding controlsDisplaying subformsKey points
9. Create custom reports
Creating reports manuallyModifying report contentAdding subreportsKey points
III. Database management and security
10. Import and export data
Importing informationImporting from other Access databasesImporting from Excel worksheetsImporting from text filesImporting from other database programsImporting from Outlook foldersImporting from SharePoint listsImporting from .html filesImporting from .xml filesExporting informationExporting to other Access databasesExporting to Excel worksheetsExporting to Word documentsExporting to text filesExporting to .pdf and .xps filesExporting to SharePoint listsExporting to .html filesExporting to .xml filesCopying to and from other Office programsKey points
11. Make databases user friendly
Designing navigation formsCreating custom categoriesControlling which features are availableKey points
12. Protect databases
Assigning passwords to databasesSplitting databasesSecuring databases for distributionPreventing database problemsKey points
13. Work in Access more efficiently
Changing default program optionsCustomizing the ribbonManipulating the Quick Access ToolbarKey points
A. Glossary
B. Keyboard shortcuts
Access 2013 keyboard shortcutsOpen, save, and print databasesWork in Design, Layout, or Datasheet viewWork in the Navigation paneWork in the Property Sheet paneWork in the Field List paneEdit controls in forms or reports in Design viewWork with combo boxes or list boxesSet properties for a table in Design viewWork with text and dataSelect text in a fieldSelect a field or recordExtend a selectionMove a column in Datasheet viewMove the cursor in a fieldEnter data in Datasheet or Form viewRefresh fields with current dataFind and replace text or data (Datasheet view or Form view)Navigate recordsNavigate in Design viewNavigate in Datasheet viewNavigate between fields and recordsNavigate to another screen of dataNavigate in subdatasheetsNavigate in Form viewNavigate between fields and recordsNavigate in forms with more than one pageNavigate in Print PreviewNavigate in the Query DesignerNavigate in the top paneNavigate in the query design gridNavigate in the SQL paneAccess web app keyboard shortcutsCustomize a web app in AccessWork with a web app in a web browserOffice 2013 keyboard shortcutsWork with menusUse Open and Save As in the Backstage viewUse the Open and Save As dialog boxesDisplay and use windowsNavigate on the ribbonMove around in text or cellsWork with textMove around in and work in tablesWork with panesWork with wizardsWork with dialog boxesUse edit boxes within dialog boxesUse the Help window
C. About the authors
Joyce CoxJoan LambertThe teamOnline Training Solutions, Inc. (OTSI)
Index
About the Authors
Copyright

Content preview from Microsoft® Access® 2013 Step by Step

Introduction

Over the years, Microsoft has put a lot of effort into making Access not only one of the most powerful consumer database programs available, but also one of the easiest to learn and use. Because Access is part of Microsoft Office 2013, you can use many of the techniques you use with Microsoft Word and Microsoft Excel. For example, you can use familiar commands, buttons, and keyboard shortcuts to open and edit the information in Access tables. And you can easily share information between Access and Word, Excel, or other Office programs. Microsoft Access 2013 Step by Step offers a comprehensive look at the features of Access that most people will use most frequently.

Who this book is for

Microsoft Access 2013 Step by Step and other books ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780735675445Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft® Access® 2013 Step by Step

by Joan Lambert and Joyce Cox

Introduction

Who this book is for

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.