Access 2013 All-in-One For Dummies

9 books in 1

• Essential Concepts
• Tables
• Queries
• Forms
• Reports
• Macros
• Database Administration
• Programming in VBA
• Going Beyond Access

Gain access to Access and discover a great way to store, organize, and share information

Database power to the people and the small businesses! Access 2013 provides that power, so you can manage large amounts of information just like the big guys do but without their staff and budget. These 9 minibooks take you from navigating Access and understanding database concepts all the way to programming with VBA. No matter where you want to take your databases, For Dummies can help!

• Database ABCs — get a basic education in Access and database functions and learn to plan your database
• Set the tables — learn how to set up tables to store your information correctly
• Learn from your data — see how to formulate queries that get exactly the information you need from your data
• Form a report — create custom forms to work with data on-screen, use the Form Wizard, and turn forms into reports for printing
• Macro magic — tell Access how to automate common tasks and save you time
• Database housekeeping — tidy up and back up your database, safely share it, and keep it secure
• Get nerdy — explore VBA and learn to customize your database by creating your own procedures, recordsets, and more
• Access interaction — see how to use Access with SQL Server and SharePoint

Open the book and find:

• How to choose the right data types for your fields
• What relational database design is all about
• Tips on creating tables
• Rules to help you maintain data integrity
• Different types of queries and what they do
• Help printing form letters and mailing labels
• Suggestions for setting up macros
• Advantages of compacting your database