[Анфиса]

Microsoft Access 2013 Step By Step


Год: 2013
Автор: Joan Lambert, Joyce Cox
Издательство: Microsoft Press
ISBN: 978-0-7356-6908-6
Серия: Step By Step
Язык: Английский
Формат: PDF
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 448
Описание:Experience learning made easy—and quickly teach yourself how to build your own database with Access 2013. With Step by Step, you set the pace—building and practicing the skills you need, just when you them! Includes downloadable practice files and a companion eBook.

Build a database from scratch or ready templates
Create easy-to-use data-entry forms
Write queries to extract and manipulate data
Design reports to summarize data in effective ways
Import data from other databases and documents

NOTE: This book is based on Office Customer Preview; its content and publication date will be updated for final Office 2013 software.

Simple database techniques
Chapter 1 Explore Microsoft Access 2013
Identifying new features of Access 2013
Working in the Access 2013 user interface
Understanding database concepts
Exploring tables
Exploring forms
Exploring queries
Exploring reports
Previewing and printing database objects
Key points

Chapter 2 Create databases and simple tables
Creating databases from templates
Creating databases and tables manually
Manipulating table columns and rows
Refining table structure
Defining relationships between tables
Key points

Chapter 3 Create simple forms
Creating forms by using the Form tool
Formatting forms
Arranging the layout of forms
Key points

Chapter 4 Display data
Sorting information in tables
Filtering information in tables
Filtering information by using forms
Locating information that matches multiple criteria
Key points

Chapter 5 Create simple reports
Creating reports by using a wizard
Modifying report design
Previewing and printing reports
Key points
Relational database techniques

Chapter 6 Maintain data integrity
Specifying the type of data
Setting the field size
Restricting the format of data
Validating the data
Allowing only values in lists
Allowing only values in other tables
Key points

Chapter 7 Create queries
Creating queries by using a wizard
Creating queries manually
Summarizing data by using queries
Calculating by using queries
Updating records by using queries
Deleting records by using queries
Key points

Chapter 8 Create custom forms
Modifying forms created by using a wizard
Adding controls
Displaying subforms
Key points

Chapter 9 Create custom reports
Creating reports manually
Modifying report content
Adding subreports
Key points
Database management and security

Chapter 10 Import and export data
Importing information
Exporting information
Copying to and from other Office programs
Key points

Chapter 11 Make databases user friendly
Designing navigation forms
Creating custom categories
Controlling which features are available
Key points

Chapter 12 Protect databases
Assigning passwords to databases
Splitting databases
Securing databases for distribution
Preventing database problems
Key points

Chapter 13 Work in Access more efficiently
Changing default program options
Customizing the ribbon
Manipulating the Quick Access Toolbar
Key points

Appendix Glossary

Appendix Keyboard shortcuts
Access 2013 keyboard shortcuts
Navigate records
Access web app keyboard shortcuts
Office 2013 keyboard shortcuts

Appendix About the authors
Joyce Cox
Joan Lambert
The team
Online Training Solutions, Inc. (OTSI)