Coverart for item
The Resource Access 2016 : in easy steps, Mike McGrath

Access 2016 : in easy steps, Mike McGrath

Label
Access 2016 : in easy steps
Title
Access 2016
Title remainder
in easy steps
Statement of responsibility
Mike McGrath
Creator
Author
Subject
Language
eng
Summary
Access 2016 in easy steps neatly demonstrates the important functions of Access 2016 in a clear and concise manner, so you can get going quickly with this popular database application. Areas covered include: Optimizing database design Creating Tables to store data in formatted fields Using handy templates to give you a head start Defining relationships between data Importing and exporting of data Making queries to extract specific data Producing Forms for data entry Constructing Reports for data presentation Sharing your database to impress your colleagues! Whether you?re upgrading to Access 2016 or new to the database concept, use this guide to learn the key features constructively and get more out of Access 2016 ? in easy steps!
Member of
Cataloging source
YDX
http://library.link/vocab/creatorDate
1956-
http://library.link/vocab/creatorName
McGrath, Mike
Dewey number
005.5
Illustrations
illustrations
Index
index present
LC call number
QA76.9.D3
LC item number
M39535 2017
Literary form
non fiction
Series statement
In easy steps
http://library.link/vocab/subjectName
  • Database management
  • Database design
Label
Access 2016 : in easy steps, Mike McGrath
Instantiates
Publication
Copyright
Note
Includes index
Carrier category
volume
Carrier category code
  • nc
Carrier MARC source
rdacarrier
Content category
  • text
  • still image
Content type code
  • txt
  • sti
Content type MARC source
  • rdacontent
  • rdacontent
Contents
  • Machine generated contents note: 1.Getting Started -- Introducing Access 2016 -- Launching the Access app -- Exploring the user interface -- Customizing Quick Access -- Managing files Backstage -- Personalizing Access options -- Converting older databases -- Using Access templates -- Searching for templates -- Getting some Help -- Applying Access updates -- 2.Designing Databases -- Arranging related data -- Understanding relationships -- Developing database design -- Producing data Tables -- Optimizing database design -- 3.Creating Tables -- Exploring the Table window -- Working in Datasheet View -- Formatting Datasheets -- Working in Design View -- Managing rows -- Setting the Primary Key -- Selecting data types -- Attaching objects -- Calculating fields -- Specifying field properties -- Stating Validation Rules -- Creating an Input Mask -- Defining a Default Value -- Referencing Indexes -- Providing a Lookup Column -- 4.Defining Relationships -- The Relationships window --
  • Contents note continued: Specifying relationships -- Enforcing integrity -- Specifying Join properties -- Directing Joins -- 5.Handling Data -- Entering data -- Using the Clipboard -- Copying data to/from Excel -- Importing data from Excel -- Importing data from Access -- Managing import tasks -- Exporting data from Access -- Filtering data -- Totalling fields -- Checking spelling -- Formatting Tables -- 6.Making Queries -- Introducing Queries -- Employing the Query Wizard -- Working with Query Design -- Adding criteria to a Query -- Querying multiple Tables -- Stating criteria for numbers -- Specifying criteria for text -- Creating a Make Table Query -- Creating an Append Query -- Creating an Update Query -- Creating a Delete Query -- 7.Coding Queries -- Introducing SQL -- Exploring the SQL window -- Using the SELECT clause -- Using the WHERE clause -- Employing SQL functions -- Combining UNION Queries -- 8.Producing Forms -- Designing a Form -- Entering data via a Form --
  • Contents note continued: Filtering Form data -- Employing the Form Wizard -- Providing a Simple Form -- Offering a Split Form -- Presenting Multiple Items -- Finding a record -- 9.Enhancing Forms -- Working with Design View -- Employing the Field List -- Working with Layout View -- Adding Headers and Footers -- Adding controls to a Form -- Fine-tuning Form controls -- Changing control properties -- Creating Calculated controls -- Adjusting the Tab Order -- Producing a Tabbed Form -- Using Command Buttons -- Displaying a Modal Dialogue-- Executing Macros -- 10.Supplying Reports -- Exploring the Report Wizard -- Providing a Simple Report -- Working with Design View -- Adding fields to a Report -- Adding controls to a Report -- Adding Headers and Footers -- Sorting and grouping data -- Printing labels -- Setting custom label sizes -- Using Print Preview -- Printing Reports -- Sending Reports via email -- 11.Sharing Access -- Protecting with passwords -- Preventing alteration --
  • Contents note continued: Securing with backups -- Splitting databases -- Interacting with SharePoint
Control code
000061390980
Dimensions
23 cm.
Extent
192 pages
Isbn
9781840787733
Isbn Type
(pbk.)
Media category
unmediated
Media MARC source
rdamedia
Media type code
  • n
Other physical details
colour illustrations
System control number
(OCoLC)972803535
Label
Access 2016 : in easy steps, Mike McGrath
Publication
Copyright
Note
Includes index
Carrier category
volume
Carrier category code
  • nc
Carrier MARC source
rdacarrier
Content category
  • text
  • still image
Content type code
  • txt
  • sti
Content type MARC source
  • rdacontent
  • rdacontent
Contents
  • Machine generated contents note: 1.Getting Started -- Introducing Access 2016 -- Launching the Access app -- Exploring the user interface -- Customizing Quick Access -- Managing files Backstage -- Personalizing Access options -- Converting older databases -- Using Access templates -- Searching for templates -- Getting some Help -- Applying Access updates -- 2.Designing Databases -- Arranging related data -- Understanding relationships -- Developing database design -- Producing data Tables -- Optimizing database design -- 3.Creating Tables -- Exploring the Table window -- Working in Datasheet View -- Formatting Datasheets -- Working in Design View -- Managing rows -- Setting the Primary Key -- Selecting data types -- Attaching objects -- Calculating fields -- Specifying field properties -- Stating Validation Rules -- Creating an Input Mask -- Defining a Default Value -- Referencing Indexes -- Providing a Lookup Column -- 4.Defining Relationships -- The Relationships window --
  • Contents note continued: Specifying relationships -- Enforcing integrity -- Specifying Join properties -- Directing Joins -- 5.Handling Data -- Entering data -- Using the Clipboard -- Copying data to/from Excel -- Importing data from Excel -- Importing data from Access -- Managing import tasks -- Exporting data from Access -- Filtering data -- Totalling fields -- Checking spelling -- Formatting Tables -- 6.Making Queries -- Introducing Queries -- Employing the Query Wizard -- Working with Query Design -- Adding criteria to a Query -- Querying multiple Tables -- Stating criteria for numbers -- Specifying criteria for text -- Creating a Make Table Query -- Creating an Append Query -- Creating an Update Query -- Creating a Delete Query -- 7.Coding Queries -- Introducing SQL -- Exploring the SQL window -- Using the SELECT clause -- Using the WHERE clause -- Employing SQL functions -- Combining UNION Queries -- 8.Producing Forms -- Designing a Form -- Entering data via a Form --
  • Contents note continued: Filtering Form data -- Employing the Form Wizard -- Providing a Simple Form -- Offering a Split Form -- Presenting Multiple Items -- Finding a record -- 9.Enhancing Forms -- Working with Design View -- Employing the Field List -- Working with Layout View -- Adding Headers and Footers -- Adding controls to a Form -- Fine-tuning Form controls -- Changing control properties -- Creating Calculated controls -- Adjusting the Tab Order -- Producing a Tabbed Form -- Using Command Buttons -- Displaying a Modal Dialogue-- Executing Macros -- 10.Supplying Reports -- Exploring the Report Wizard -- Providing a Simple Report -- Working with Design View -- Adding fields to a Report -- Adding controls to a Report -- Adding Headers and Footers -- Sorting and grouping data -- Printing labels -- Setting custom label sizes -- Using Print Preview -- Printing Reports -- Sending Reports via email -- 11.Sharing Access -- Protecting with passwords -- Preventing alteration --
  • Contents note continued: Securing with backups -- Splitting databases -- Interacting with SharePoint
Control code
000061390980
Dimensions
23 cm.
Extent
192 pages
Isbn
9781840787733
Isbn Type
(pbk.)
Media category
unmediated
Media MARC source
rdamedia
Media type code
  • n
Other physical details
colour illustrations
System control number
(OCoLC)972803535

Library Locations

    • Lionel Bowen Library and Community CentreBorrow it
      669-673 Anzac Parade, Marouba, NSW, 2035, AU
      -33.938111 151.237977
Processing Feedback ...